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 11–20 of 150

Q11

A company needs to restrict access to its Azure SQL Database based on user role. What should be implemented?

  • A Azure Active Directory authentication
  • B SQL user with permissions
  • C Firewall rules
  • D Connection strings
Explanation Azure Active Directory authentication allows for role-based access control, unlike other options which do not address user roles directly.
Q12

What happens when you apply a conflict resolution policy on an Azure SQL Database?

  • A Delete conflicting records
  • B Overwrite with latest data
  • C Ignore conflicts entirely
  • D Log all conflicts
Explanation Applying a conflict resolution policy typically resolves conflicts by overwriting with the latest data; the other options either contradict or do not describe standard behavior.
Q13

Which service is primarily used for monitoring Azure SQL databases?

  • A Azure Monitor
  • B Azure Blob Storage
  • C Azure Functions
  • D Azure DevOps
Explanation Azure Monitor provides comprehensive monitoring features for Azure SQL databases, while the others serve different functions.
Q14

A company needs to ensure that their SQL databases remain available even in the event of an on-premises data center outage. What should they implement?

  • A Geo-Replication
  • B Point-in-Time Restore
  • C Service Tiers
  • D Azure Firewall
Explanation Geo-Replication enables high availability across geographic regions, while the other options do not provide continuous availability during outages.
Q15

You are configuring security for an Azure SQL database and want to restrict access to specific IP ranges. What must you do?

  • A Set up Azure VPN
  • B Configure Firewall Rules
  • C Use Managed Identity
  • D Implement RBAC
Explanation Configuring Firewall Rules explicitly allows or denies traffic based on IP, while the others do not specifically manage access control by IP ranges.
Q16

Which feature allows Azure SQL Database to automatically adjust resources during peak loads?

  • A Auto-scaling
  • B Elastic pools
  • C On-demand scaling
  • D Resource manager
Explanation Elastic pools can manage multiple databases and dynamically allocate resources, unlike the other options which either require manual intervention or apply to different services.
Q17

A company needs to preserve historical data while ensuring that their primary tables remain performant. What do you recommend?

  • A Partitioning the tables
  • B Using Row-Level Security
  • C Implementing Change Data Capture
  • D Transferring data to Azure Blob Storage
Explanation Change Data Capture (CDC) tracks changes without altering performance, while the other options do not specifically address the need for historical data management.
Q18

What happens when you set the MAXDOP option to 1 in Azure SQL Query execution?

  • A Query runs faster in parallel
  • B Single-threaded execution is enforced
  • C Increases resource utilization
  • D Query times out immediately
Explanation Setting MAXDOP to 1 restricts execution to a single thread, minimizing parallel processing that could speed up execution.
Q19

Which service can be used to migrate an on-premises SQL Server database to Azure SQL Database with minimal downtime?

  • A Azure Database Migration Service
  • B Azure Blob Storage
  • C Azure Data Lake
  • D Azure Functions
Explanation Azure Database Migration Service is specifically designed for this purpose, while others are unrelated.
Q20

A company needs to run a query across multiple Azure SQL Databases frequently. What is the best architectural choice?

  • A Elastic Query
  • B Azure Data Warehouse
  • C SQL Server Replication
  • D Azure Analysis Services
Explanation Elastic Query allows querying across multiple databases; the others don't facilitate cross-database querying efficiently.