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 131–140 of 150

Q131

A company needs to restrict SQL database access to certain IP addresses. What feature should they use?

  • A SQL Server Authentication
  • B Azure Active Directory
  • C Firewall Rules
  • D Privileged Identity Management
Explanation Firewall Rules allow for IP restrictions, whereas the others do not provide this specific function.
Q132

You are configuring Azure SQL Database with geo-replication. What happens if the primary database fails?

  • A Secondary database automatically activates
  • B Data loss occurs
  • C Applications fail only
  • D Manual intervention required
Explanation The secondary automatically becomes primary during failover, while others suggest incorrect behaviors.
Q133

Which service allows for automatic scaling of SQL databases?

  • A Azure SQL Database Elastic Pools
  • B Azure Functions
  • C Azure Blob Storage
  • D Azure App Service
Explanation Azure SQL Database Elastic Pools scale resources based on demand, while the others are for different services.
Q134

A company needs to ensure its SQL databases can recover from a region failure quickly. What should they implement?

  • A Active Geo-Replication
  • B Backup and Restore
  • C Database Auditing
  • D Point-in-time Restore
Explanation Active Geo-Replication allows cross-region failover, while the others do not provide quick recovery in another region.
Q135

You are configuring a SQL Server on an Azure VM. Which storage option provides the best performance?

  • A Standard HDD
  • B Premium SSD
  • C Standard SSD
  • D Blob Storage
Explanation Premium SSD offers the highest performance for SQL databases, while the other options are slower or not for SQL tasks.
Q136

Which service is used to manage SQL databases in Azure?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure SQL Database is designed specifically for relational databases, while the others serve different purposes.
Q137

A company needs to protect sensitive data in Azure SQL Database using encryption. What should they enable?

  • A Transparent Data Encryption
  • B Access Control Lists
  • C Network Security Groups
  • D Azure Active Directory
Explanation Transparent Data Encryption (TDE) encrypts data at rest, preserving security for sensitive information, unlike the other options.
Q138

You are configuring an Azure SQL Database managed instance. What happens if you exceed the compute capacity tier's resources?

  • A The database shuts down.
  • B Performance is throttled.
  • C Applications cannot connect.
  • D Data is automatically deleted.
Explanation Exceeding compute capacity results in performance throttling, rather than shutting down or losing data.
Q139

Which service is used for serverless SQL pools in Azure Synapse Analytics?

  • A Azure SQL Database
  • B SQL Server on Azure VM
  • C Azure Synapse Studio
  • D Serverless SQL Pools
Explanation Serverless SQL Pools allow on-demand querying; others are not specifically for serverless SQL.
Q140

A company needs to implement multi-region high availability for their Azure SQL Database. What should they configure?

  • A Geo-replication
  • B Elastic Pools
  • C Read Scale-Out
  • D Backup Policies
Explanation Geo-replication provides multi-region availability; other options do not ensure high availability across regions.