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 31–40 of 150

Q31

Which service provides serverless SQL capabilities in Azure?

  • A Azure SQL Database Serverless
  • B Azure Synapse Analytics
  • C Azure SQL Managed Instance
  • D Azure Data Lake Storage
Explanation Azure SQL Database Serverless automatically scales resources based on demand, while others do not provide serverless options.
Q32

A company needs to securely access Azure SQL Database from an on-premises network. What should they implement?

  • A Point-to-Site VPN
  • B Public IP Whitelisting
  • C On-Premises Data Gateway
  • D ExpressRoute
Explanation ExpressRoute provides a private, high-speed connection to Azure, while others may not ensure security or performance.
Q33

What happens when a database in Azure SQL Database is set to 'Read Scale-Out'?

  • A Write operations are disabled
  • B Performance improves for read operations
  • C Data is replicated automatically
  • D It incurs extra licensing fees
Explanation Read Scale-Out allows for improved performance on read-only queries by redirecting them to readable secondaries, while the other options either don’t apply or are incorrect.
Q34

Which service provides built-in analytics for SQL databases?

  • A Azure SQL Analytics
  • B Azure Monitor
  • C Azure Data Factory
  • D Azure Storage
Explanation Azure SQL Analytics specifically analyzes SQL databases, while the others focus on broader or different needs.
Q35

A company needs to minimize downtime during upgrades. What should they configure?

  • A Active Geo-Replication
  • B Database Sharding
  • C SQL Database Auditing
  • D Elastic Pools
Explanation Active Geo-Replication allows for failover with minimal downtime, while the others do not directly address downtime during upgrades.
Q36

You are configuring a SQL Managed Instance. What happens if you set more computed columns than the limit?

  • A No error, columns ignored
  • B Error; not all columns created
  • C Columns created but non-functional
  • D Instance goes into read-only mode
Explanation If you exceed the limit, an error occurs, preventing creation rather than ignoring or creating non-functional columns.
Q37

A company needs to enable geo-replication for its Azure SQL Database. Which service should they use?

  • A Azure SQL Database
  • B Azure Storage
  • C Azure Functions
  • D Azure Blob Storage
Explanation Azure SQL Database supports geo-replication natively; the others do not.
Q38

What happens when you perform a 'ROLLBACK' command in a transaction block?

  • A Commit all changes made
  • B Undo all changes made
  • C Save the transaction forever
  • D Permanently delete the database
Explanation ROLLBACK undoes all changes made during the transaction; the others describe incorrect outcomes.
Q39

You are configuring a Dynamic Data Masking strategy in Azure SQL. Which of the following is a valid masking function?

  • A Default
  • B Nullify
  • C MaskD
  • D Partial
Explanation 'Default' is a valid masking function; others are not recognized masking functions.
Q40

Which service is best for low-latency responses in Azure SQL?

  • A Azure SQL Database
  • B Azure Blob Storage
  • C Azure Data Lake Storage
  • D Azure App Service
Explanation Azure SQL Database provides low-latency SQL responses, while other options serve different purposes.