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 51–60 of 150

Q51

What happens when you set the minimum and maximum DTUs to the same value in Azure SQL Database?

  • A Creates a Hyperscale database
  • B Enables serverless mode
  • C Fixed performance given
  • D Automatically scales according to load
Explanation Setting min and max DTUs equal configures a fixed performance level; the others imply scalability or different configurations not applicable here.
Q52

Which service can be used for automated backups in Azure SQL Database?

  • A Point-in-time restore
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Virtual Network
Explanation Point-in-time restore enables automated backups, while the others are unrelated storage solutions.
Q53

A company needs to extract data from an on-premises SQL Server to Azure SQL Database. What should they use?

  • A Azure Data Factory
  • B Azure Functions
  • C Azure Virtual Machines
  • D Azure DevOps
Explanation Azure Data Factory is designed for data integration and extraction from on-premises to Azure.
Q54

You are configuring geo-replication for an Azure SQL Database. What will happen if your primary database becomes unavailable?

  • A Automatic failover to secondary
  • B No action taken
  • C Manual failover required
  • D Secondary becomes primary automatically
Explanation Manual failover is required for geo-replication; automatic failover is not supported in this context.
Q55

Which service provides insight into SQL database performance?

  • A Azure Monitor
  • B Azure Logic Apps
  • C Azure Functions
  • D Azure Data Lake
Explanation Azure Monitor is designed for performance insights, while others focus on automation or data storage.
Q56

A company needs to improve its SQL database availability. Which feature should they implement?

  • A Active Geo-Replication
  • B Read Scale-out
  • C SQL Database Auditing
  • D Dynamic Data Masking
Explanation Active Geo-Replication allows for higher availability across regions, unlike the others which serve different purposes.
Q57

What happens when you exceed SQL Database DTU limits?

  • A Database becomes read-only
  • B Queries will be throttled
  • C Database auto-scales
  • D Error messages appear
Explanation Exceeding DTU limits results in throttled performance rather than the other options listed.
Q58

Which service is best for data analytics on Azure SQL?

  • A Azure Synapse Analytics
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure DevOps
Explanation Azure Synapse Analytics offers powerful analytics capabilities that integrate well with Azure SQL.
Q59

A company needs to ensure that only certain IPs can access its Azure SQL Database. What should they configure?

  • A Database auditing
  • B Firewall rules
  • C Virtual Network Integration
  • D Managed Instance
Explanation Firewall rules allow specifying which IPs can access the database, enhancing security.
Q60

You are configuring Azure SQL Database failover groups. What happens when a failover occurs?

  • A No data is lost, but connection breaks
  • B Reverts to previous backup automatically
  • C Automatically syncs to on-premises SQL
  • D Endpoints remain accessible without interruption
Explanation During failover, connections may drop as control transitions to the secondary database.