DP-300 Matching — 10 Questions

Question 1

Match each Azure SQL Database pricing tier to its key feature.

Accepted Answer

Basic: Low-cost, lightweight workloads with minimal compute and memory resources.. These tiers define the compute and memory resources available for Azure SQL Database.

Answer

Basic: Balanced compute and memory resources for most enterprise workloads with scalable storage.

Answer

Standard: High memory-to-core ratio for memory-intensive workloads like analytics.

Question 2

Match each Azure SQL Database migration tool to its description.

Accepted Answer

Azure Database Migration Service: A fully managed service designed for online migrations to Azure SQL Database with minimal downtime.. Correct matches: A - Azure Database Migration Service (online/offline migration), B - Data Migration Assistant (assessment), C - SSMA (cross-platform migration), D - Azure Migrate (central hub). Common confusion: mixing up the migration service with offline-only tools or ignoring the assessment step.

Answer

Azure Database Migration Service: A tool that only performs offline migrations and requires significant downtime.

Answer

Data Migration Assistant: A service that automatically migrates databases with no assessment step.

Question 3

Match each Azure SQL Database service tier to its description.

Accepted Answer

General Purpose: Balanced performance for most cloud workloads with compute and storage separation.. These are the main service tiers in Azure SQL Database, each designed for different performance and scalability needs.

Answer

General Purpose: High I/O and low latency with multiple read-only replicas.

Answer

Business Critical: Scalable storage up to 100 TB with auto-scaling compute.

Answer

Hyperscale: Balanced performance for small to medium workloads with compute and storage separation.

Question 4

Match each Azure SQL Database security feature to its purpose.

Accepted Answer

Transparent Data Encryption (TDE): Encrypts data at rest. TDE protects data at rest by encrypting the database files. Always Encrypted protects data in use by encrypting on the client side. Dynamic Data Masking hides sensitive data in query results from unauthorized users. Common confusions involve mixing up TDE and Always Encrypted.

Answer

Transparent Data Encryption (TDE): Encrypts data in use on client side

Answer

Always Encrypted: Encrypts data at rest

Question 5

Match each Azure SQL Database backup type to its description.

Accepted Answer

Full backup: Contains all data in the database.. These are the three types of backups used for point-in-time restore in Azure SQL Database.

Answer

Full backup: Contains only changes since the last full backup.

Answer

Differential backup: Contains all committed transactions since the last full backup.

Question 6

Match each Azure SQL Database monitoring metric to its meaning.

Accepted Answer

DTU percentage: Measures the percentage of DTU limit used by the database.. These metrics are used to monitor resource usage and performance in Azure SQL Database.

Answer

DTU percentage: Measures the percentage of CPU limit used by the database.

Answer

CPU percentage: Measures the percentage of data I/O limit used by the database.

Answer

Data IO percentage: Measures the percentage of DTU limit used by the database.

Question 7

Match each Azure SQL Database error code to its meaning.

Accepted Answer

4060: Cannot open database requested by the login. Login failed.. Common Azure SQL Database error codes: 4060 (database not accessible), 18456 (login failure), 40197 (transient error), 40501 (throttling). Distractors swap the definitions between 4060 and 18456.

Answer

4060: Login failed for user 'username'.

Answer

18456: Cannot open database requested by the login.

Question 8

Match each Azure SQL Database high availability feature to its description.

Accepted Answer

Zone-redundant availability: Protects against datacenter failures by replicating databases across three availability zones within a region.. These features provide different levels of availability and disaster recovery for Azure SQL Database.

Answer

Zone-redundant availability: Automatically fails over databases across different Azure regions.

Answer

Active geo-replication: Creates four replicas in the same datacenter to provide high availability.

Question 9

Match each Azure SQL Database performance tuning feature to its description.

Accepted Answer

Query Performance Insight: Provides intelligent query analysis with performance history and recommendations.. Azure SQL Database provides several performance tuning features. Query Performance Insight offers query-level analysis, Automatic Tuning automatically applies index and plan changes, Intelligent Insights gives proactive diagnostics, and Database Advisor provides configuration recommendations. Common confusions involve swapping the automatic tuning and insight features.

Answer

Query Performance Insight: Automatically applies performance improvements like index creation and plan forcing.

Answer

Automatic Tuning: Provides proactive performance monitoring with root cause analysis and diagnostics.

Question 10

Match each Azure SQL Database command to its function.

Accepted Answer

CREATE DATABASE: Creates a new database. In Azure SQL Database, CREATE DATABASE initializes a new database, ALTER DATABASE changes its configuration, DROP DATABASE removes it, and BACKUP DATABASE creates a backup (though backups are often automatic). Common confusions include swapping CREATE with DROP and ALTER with BACKUP due to similar administrative contexts.

Answer

CREATE DATABASE: Deletes a database

Answer

ALTER DATABASE: Creates a backup