Microsoft Azure

Administering Microsoft Azure SQL Solutions

DP-300

Become proficient in Azure SQL with the DP-300 exam focused on administration.

150 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 21–30 of 150

Q21

What happens when you disable a failover group in Azure SQL Database?

  • A All databases are deleted.
  • B Automatic failover is disabled.
  • C Replication is paused indefinitely.
  • D Azure support must be contacted.
Explanation Disabling a failover group disables automatic failover but does not delete databases or require Azure support.
Q22

Which service is best for SQL database migration to Azure?

  • A Azure Database Migration Service
  • B Azure Blob Storage
  • C Azure Data Factory
  • D Azure Functions
Explanation Azure Database Migration Service specializes in SQL migrations, while others do not.
Q23

A company needs to restrict access to its Azure SQL Database based on user roles. What should you implement?

  • A Database Auditing
  • B Role-Based Access Control
  • C SQL Auditing
  • D Dynamic Data Masking
Explanation Role-Based Access Control is designed for user role management, unlike the other options that focus on auditing and security features.
Q24

You are configuring an Azure SQL Database. What happens when you choose 'General Purpose' tier?

  • A Higher transaction rate availability
  • B Optimized for capacity planning
  • C Cost-effective with balanced performance
  • D Limited elastic pool support
Explanation The 'General Purpose' tier offers a balance of cost and performance, unlike other options that don't accurately describe it.
Q25

Which service provides automated backups in Azure SQL Database?

  • A Azure Blob Storage
  • B Azure SQL Database
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure SQL Database automatically handles backups, unlike the other services, which serve different purposes.
Q26

A company needs a solution to optimize query performance and lower costs. What feature should they use?

  • A Read Scale-Out
  • B Elastic Pools
  • C Managed Instance
  • D Geo-Replication
Explanation Elastic Pools allow multiple databases to share resources effectively, improving cost and performance.
Q27

You are configuring VNet service endpoints for Azure SQL Database. What happens if you don't authorize an IP address?

  • A Access is granted automatically
  • B Access is denied
  • C Connection times out
  • D Server reboots to authorize
Explanation If the IP is not authorized, access will be denied to maintain secure connectivity.
Q28

Which service allows you to analyze SQL query performance?

  • A Azure SQL Analytics
  • B Azure Storage Explorer
  • C Azure DevOps
  • D Azure Data Lake
Explanation Azure SQL Analytics provides deep insights on query performance, while the others serve different purposes.
Q29

A company needs to ensure that sensitive data is encrypted at rest in Azure SQL Database. What should be implemented?

  • A Transparent Data Encryption
  • B Activity Log
  • C Firewalls and VNet
  • D Geo-replication
Explanation Transparent Data Encryption secures data at rest, while the other options do not provide this specific functionality.
Q30

You are configuring a long-running transaction in Azure SQL Database. What happens if you exceed the database transaction log limit?

  • A Database automatically truncates logs
  • B Further operations are blocked
  • C System crash occurs
  • D Service degrades temporarily
Explanation Exceeding the transaction log limit blocks further operations until logs are cleared, unlike the other choices which are incorrect pertaining to log behavior.