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

Q1

Which service provides serverless options for SQL databases?

A Azure Cosmos DB
B Azure SQL Database
C Azure Data Lake Store
D Azure Blob Storage

Explanation Azure SQL Database has a serverless option, making it suitable for variable workloads.

Q2

You are scheduling backups for your Azure SQL Database. What happens if the backup retention period is exceeded?

A Older backups are deleted automatically
B Backup fails until retention fixed
C Backups are retained indefinitely
D Retention can be ignored

Explanation Older backups are automatically deleted after retention period.

Q3

A company needs to analyze SQL performance. Which tool should they use?

A Azure Migrate
B Azure Data Factory
C Query Performance Insights
D Azure Monitor

Explanation Query Performance Insights provides specific details on SQL performance issues.

Q4

Which Azure service is best for SQL-based analytics?

A Azure Synapse Analytics
B Azure Functions
C Azure Blob Storage
D Azure Data Lake

Explanation Azure Synapse Analytics is designed for SQL-based analytics while the others serve different purposes.

Q5

A company needs to ensure high availability for their Azure SQL Database with minimal downtime. What should they use?

A Geo-replication
B Read replicas
C Failover groups
D Standard S3 tier

Explanation Failover groups provide automated failover with minimal downtime, unlike other options.

Q6

You are configuring a stored procedure to handle sensitive data in Azure SQL Database. What compliance requirement should you prioritize?

A User permissions
B Data encryption
C Database performance
D Networking setup

Explanation Data encryption is crucial for protecting sensitive data, while others don't specifically address compliance.

Q7

Which service provides a fully managed database experience for SQL Server workloads?

A Azure SQL Database
B Azure Blob Storage
C Azure Functions
D Azure Kubernetes Service

Explanation Azure SQL Database is specifically designed for managed database services, while the others serve different purposes.

Q8

A company needs to increase database performance dynamically based on workload. What should they implement?

A Elastic Pools
B Replication
C Transparent Data Encryption
D Database Auditing

Explanation Elastic Pools allow multiple databases to share resources, dynamically scaling performance as needed.

Q9

You are configuring a read-only replica for your Azure SQL Database. What happens if you attempt to write to the replica?

A Write operations succeed
B Write operations fail
C Replica turns read-write
D Database restarts automatically

Explanation Write operations are not permitted on read-only replicas, and attempts will fail.

Q10

Which service allows you to automate scaling of Azure SQL Database?

A Azure Automation
B Auto-Scaling feature
C Elastic pools
D Azure Functions

Explanation Elastic pools manage resource scaling across multiple databases dynamically, whereas the others do not specifically handle SQL database scaling.