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 41–50 of 150

Q41

A company needs to analyze large datasets in real time. Which feature should they use in Azure SQL?

  • A SQL Server Management Studio
  • B Stream Analytics
  • C Data Warehouse
  • D Backup Retention
Explanation Stream Analytics allows for real-time data processing and analysis, unlike other options meant for different use cases.
Q42

What happens when you enable geo-replication for an Azure SQL Database?

  • A Increased latency on writes
  • B Real-time data sync across regions
  • C Automatic backups every hour
  • D Load balancing incoming connections
Explanation Geo-replication allows for real-time data synchronization to a secondary region, enhancing data availability.
Q43

Which service is primarily used for migrating SQL databases to Azure?

  • A Azure Database Migration Service
  • B Azure Data Factory
  • C Azure Functions
  • D Azure Synapse Analytics
Explanation Azure Database Migration Service is designed for database migrations, while the others serve different purposes.
Q44

A company needs to ensure minimal downtime during planned maintenance of an Azure SQL Database. Which feature should they use?

  • A Geo-Replication
  • B Failover Groups
  • C Automatic Backups
  • D Database Sharding
Explanation Failover Groups provide high availability with no downtime during maintenance, while the others don't achieve this goal.
Q45

You are configuring an Azure SQL Database with Transparent Data Encryption (TDE). What happens if TDE is not enabled?

  • A Data will be automatically encrypted
  • B Data is stored in plain text
  • C All connections are denied
  • D Backups will fail
Explanation Without TDE, data at rest is stored as plain text, while the other options are incorrect functionalities of TDE.
Q46

A company needs to ensure minimal downtime during an update. Which deployment method should they use for Azure SQL Database?

  • A Blue-Green Deployment
  • B Rolling Update
  • C Canary Release
  • D Manual Switch
Explanation Blue-Green Deployment allows seamless updates with minimal downtime while other options may require more manual intervention or lead to service interruptions.
Q47

What happens when you set the Max Size property of an Azure SQL Database?

  • A Database cannot grow beyond size
  • B Database automatically shrinks
  • C Logs are deleted when full
  • D Data is relocated to Blob Storage
Explanation Setting the Max Size property restricts the database size but does not physically shrink the database or move data elsewhere.
Q48

You are configuring Geo-Replication for Azure SQL Database. What is the main benefit of this feature?

  • A Data Localization
  • B Disaster Recovery
  • C Performance Tuning
  • D Reduced Costs
Explanation Geo-Replication primarily provides disaster recovery capabilities by creating readable secondary databases in different regions, while other options do not capture its main focus.
Q49

Which service is best for running a serverless SQL database in Azure?

  • A Azure SQL Database Serverless
  • B Azure Table Storage
  • C Azure Functions
  • D Azure Blob Storage
Explanation Azure SQL Database Serverless automatically scales based on workload; others do not provide serverless SQL capabilities.
Q50

A company needs to store SQL databases that automatically replicate transactions for disaster recovery. Which option should they choose?

  • A Active Geo-Replication
  • B Read Scale-Out Configuration
  • C Database Snapshots
  • D Backup and Restore
Explanation Active Geo-Replication allows for real-time replication to secondary regions, unlike the others which do not provide this capability.