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 81–90 of 150

Q81

What happens when you exceed the DTU limit in your Azure SQL Database?

  • A Database automatically upgrades tier.
  • B Database throttles queries temporarily.
  • C Connections are instantly severed.
  • D Performance improves without intervention.
Explanation Exceeding DTU limit causes query performance throttling, not automatic upgrades or improvements.
Q82

What is the maximum size for a single Azure SQL Database?

  • A 500 GB
  • B 1 TB
  • C 5 TB
  • D Unlimited
Explanation The maximum size for a single Azure SQL Database is 5 TB, while the other options are incorrect limit constraints.
Q83

A company needs to automate backups for their Azure SQL Database. Which feature should they use?

  • A Point-in-time restore
  • B Long-term retention
  • C Automated backups
  • D Manual export
Explanation Automated backups are the feature specifically designed to automate backup processes, while the others are manual or specific scenarios.
Q84

You are configuring a Managed Instance with VNet integration. What happens if the virtual network is deleted?

  • A Instance continues to function.
  • B Instance will be deleted.
  • C Instance shows limited access.
  • D Instance automatically restarts.
Explanation The Managed Instance will be deleted if its associated virtual network is deleted, whereas the other options inaccurately depict instance behavior.
Q85

Which service provides automatic scaling of SQL databases?

  • A Azure SQL Database Serverless
  • B Azure Data Lake Storage
  • C Azure Blob Storage
  • D Azure Functions
Explanation Azure SQL Database Serverless automatically scales based on demand, while others do not provide this feature.
Q86

A company needs to enable geo-replication for disaster recovery. Which Azure SQL feature should they use?

  • A Point-in-time restore
  • B Active geo-replication
  • C Long-term backup retention
  • D Database snapshots
Explanation Active geo-replication allows for real-time data replication across regions for disaster recovery, while others do not offer this capability.
Q87

What happens when a SQL Managed Instance exceeds its DTU limit?

  • A Database is automatically deleted
  • B Queries are queued until resources are available
  • C Application crashes and stops responding
  • D Server scale up occurs automatically
Explanation Queries are queued until the DTU limit is under control, while the other options are incorrect responses to hitting a limit.
Q88

What service provides serverless database options in Azure SQL?

  • A Azure SQL Database
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure Kubernetes Service
Explanation Azure SQL Database offers serverless options, while the others serve different purposes.
Q89

A company needs to migrate its SQL Server on-premises databases to Azure. Which tool is recommended for this task?

  • A Azure Migrate
  • B Azure Data Factory
  • C Azure DevOps
  • D SQL Server Management Studio
Explanation Azure Migrate provides specialized tools for database migration compared to the others.
Q90

What happens when you set the 'MAXDOP' option to 1 for a query in Azure SQL Database?

  • A Use multiple threads to execute
  • B Use a single thread for execution
  • C Execute without resource limits
  • D Increase execution speed significantly
Explanation 'MAXDOP' set to 1 restricts execution to a single thread, limiting parallelism.