Microsoft Dp 300 Administering Relational Databases Azure Practice Test - Set 1
Test your knowledge with this Microsoft Dp 300 Administering Relational Databases Azure mock exam. Get real-world IT questions and prepare for certification success.
Unknown Exam - Exam Information
Exam Information
Exam Code
Microsoft Dp 300 Administering Relational Databases Azure
Exam Title
Unknown Exam
Vendor
Microsoft
Difficulty
Varies
Duration
Varies
Question Format
Multiple Choice
Last Updated
February 25, 2025
Prepare for your Microsoft certification with our comprehensive practice exams.
1. Which feature of Azure SQL Database provides automatic scaling based on workload demands?
Elastic Pools
Always Encrypted
Azure Monitor
Database Tuning Advisor
✅ Correct Answer: Elastic Pools
2. Which tool is recommended for migrating on-premises SQL Server databases to Azure SQL Database?
Azure Database Migration Service
SQL Server Management Studio
Azure Data Factory
Azure Synapse Studio
✅ Correct Answer: Azure Database Migration Service
3. What is the primary purpose of Azure SQL Database?
Managed relational database service
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Managed relational database service
4. Which feature in Azure SQL Database provides transparent data encryption?
Always Encrypted
Elastic Pools
Azure Monitor
Database Tuning Advisor
✅ Correct Answer: Always Encrypted
5. What is the primary function of Azure SQL Managed Instance?
Fully managed SQL Server instance in Azure
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Fully managed SQL Server instance in Azure
6. Which tool is used for monitoring and optimizing Azure SQL Database performance?
Azure Monitor
SQL Server Management Studio
Azure Data Factory
Azure Synapse Studio
✅ Correct Answer: Azure Monitor
7. What is the primary purpose of Azure SQL Data Sync?
Synchronize data across multiple databases
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Synchronize data across multiple databases
8. Which feature in Azure SQL Database provides automatic tuning of queries?
Automatic Tuning
Elastic Pools
Always Encrypted
Database Tuning Advisor
✅ Correct Answer: Automatic Tuning
9. What is the primary function of Azure SQL Database Hyperscale?
Scalable storage and performance for large databases
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Scalable storage and performance for large databases
10. Which tool is used for managing and querying Azure SQL Database?
SQL Server Management Studio
Azure Data Factory
Azure Synapse Studio
Azure Monitor
✅ Correct Answer: SQL Server Management Studio
11. What is the primary purpose of Azure SQL Database Geo-Replication?
Replicate data to different regions for disaster recovery
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Replicate data to different regions for disaster recovery
12. Which feature in Azure SQL Database provides row-level security?
Row-Level Security
Always Encrypted
Elastic Pools
Database Tuning Advisor
✅ Correct Answer: Row-Level Security
13. What is the primary function of Azure SQL Database Auditing?
Track and log database activities
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Track and log database activities
14. Which tool is used for automating database deployments in Azure SQL Database?
Azure DevOps
SQL Server Management Studio
Azure Data Factory
Azure Synapse Studio
✅ Correct Answer: Azure DevOps
15. What is the primary purpose of Azure SQL Database Threat Detection?
Identify and respond to potential security threats
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Identify and respond to potential security threats
16. Which feature in Azure SQL Database provides automatic backups?
Automated Backups
Elastic Pools
Always Encrypted
Database Tuning Advisor
✅ Correct Answer: Automated Backups
17. What is the primary function of Azure SQL Database Query Store?
Monitor and troubleshoot query performance
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Monitor and troubleshoot query performance
18. Which tool is used for managing and querying Azure SQL Managed Instance?
SQL Server Management Studio
Azure Data Factory
Azure Synapse Studio
Azure Monitor
✅ Correct Answer: SQL Server Management Studio
19. What is the primary purpose of Azure SQL Database Data Masking?
Protect sensitive data by masking it
Data integration
Data warehousing
Real-time data processing
✅ Correct Answer: Protect sensitive data by masking it
20. Which feature in Azure SQL Database provides automatic failover for high availability?
Auto-Failover Groups
Elastic Pools
Always Encrypted
Database Tuning Advisor
✅ Correct Answer: Auto-Failover Groups
21. Which feature enables cross-database queries in Azure SQL Database?
Elastic Query
PolyBase
Linked Servers
External Tables
✅ Correct Answer: Elastic Query
22. What is the maximum database size supported by Azure SQL Database Hyperscale?
100 TB
1 TB
10 TB
Unlimited
✅ Correct Answer: 100 TB
23. Which PowerShell cmdlet is used to create Azure SQL Database backups?
New-AzSqlDatabaseExport
Backup-AzSqlDatabase
Export-AzSqlDatabase
Save-AzSqlDatabase
✅ Correct Answer: New-AzSqlDatabaseExport
24. What is the primary purpose of Query Store in Azure SQL Database?
Track query performance history
Encrypt sensitive data
Automate backups
Manage indexes
✅ Correct Answer: Track query performance history
25. Which feature provides automatic index management in Azure SQL Database?
Automatic Tuning
Query Store
Elastic Jobs
Intelligent Insights
✅ Correct Answer: Automatic Tuning
26. What is the maximum retention period for Azure SQL Database automated backups?
10 years
1 year
35 days
7 days
✅ Correct Answer: 10 years
27. Which tool provides performance recommendations for Azure SQL Database?
Azure Advisor
Query Store
SQL Server Profiler
Database Tuning Advisor
✅ Correct Answer: Azure Advisor
28. What is the primary purpose of Azure SQL Database Ledger?
Tamper-evident data tracking
Data encryption
Query optimization
Backup management
✅ Correct Answer: Tamper-evident data tracking
29. Which feature enables querying Azure Blob Storage from Azure SQL Database?
External Tables
PolyBase
BULK INSERT
OPENROWSET
✅ Correct Answer: External Tables
30. What is the maximum number of databases supported in an Elastic Pool?
500
100
1000
Unlimited
✅ Correct Answer: 500
31. Which PowerShell module is used for Azure SQL Database management?
Az.Sql
AzureRM.Sql
SqlServer
DBATools
✅ Correct Answer: Az.Sql
32. What is the maximum DTU limit for Azure SQL Database Premium tier?
4000 DTUs
1000 DTUs
800 DTUs
Unlimited
✅ Correct Answer: 4000 DTUs
33. Which feature provides real-time performance monitoring for Azure SQL Database?
Query Performance Insight
Azure Monitor
SQL Profiler
Extended Events
✅ Correct Answer: Query Performance Insight
34. What is the maximum storage limit for Azure SQL Managed Instance?
8 TB
4 TB
16 TB
Unlimited
✅ Correct Answer: 8 TB
35. Which feature enables point-in-time restore for Azure SQL Database?
Automated Backups
Geo-Replication
Export Database
SQL Agent Jobs
✅ Correct Answer: Automated Backups
36. What is the maximum retention period for Long-Term Backup Retention?
10 years
1 year
5 years
Unlimited
✅ Correct Answer: 10 years
37. Which feature provides cross-subscription database copies in Azure SQL Database?
Database Copy
Geo-Replication
Export/Import
Backup/Restore
✅ Correct Answer: Database Copy
38. What is the maximum number of failover groups per Azure SQL Database server?
1
5
10
Unlimited
✅ Correct Answer: 1
39. Which T-SQL command is used to pause Azure SQL Database Hyperscale?
ALTER DATABASE PAUSE
DBCC PAUSE
SUSPEND DATABASE
STOP DATABASE
✅ Correct Answer: ALTER DATABASE PAUSE
40. What is the maximum number of concurrent workers in Azure SQL Database Hyperscale?
300
100
500
Unlimited
✅ Correct Answer: 300
41. Which feature enables near real-time analytics on operational data in Azure SQL Database?
Ledger
Intelligent Insights
PolyBase
Elastic Query
✅ Correct Answer: Ledger
42. What is the maximum number of secondary replicas supported in Azure SQL Database Hyperscale?
4
2
1
Unlimited
✅ Correct Answer: 4
43. Which Azure service provides a fully managed service for SQL Server disaster recovery?
Azure Site Recovery
Azure Backup
Azure SQL Database Geo-Replication
Azure Traffic Manager
✅ Correct Answer: Azure Site Recovery
44. What is the maximum number of databases supported in a single Azure SQL Database server?
5000
1000
500
Unlimited
✅ Correct Answer: 5000
45. Which feature enables querying data across multiple Azure SQL Databases as if they were a single database?
Elastic Query
PolyBase
External Tables
Linked Servers
✅ Correct Answer: Elastic Query
46. What is the maximum size of a single transaction log file in Azure SQL Database?
2 TB
1 TB
500 GB
Unlimited
✅ Correct Answer: 2 TB
47. Which PowerShell cmdlet is used to create a new Azure SQL Database?
New-AzSqlDatabase
Create-AzSqlDatabase
Add-AzSqlDatabase
Set-AzSqlDatabase
✅ Correct Answer: New-AzSqlDatabase
48. What is the maximum number of concurrent logins supported by Azure SQL Database Business Critical tier?
30,000
10,000
5,000
Unlimited
✅ Correct Answer: 30,000
49. Which feature provides automatic performance recommendations for Azure SQL Managed Instance?
Intelligent Insights
Query Store
Azure Advisor
Database Tuning Advisor
✅ Correct Answer: Intelligent Insights
50. What is the maximum number of tables supported in a single Azure SQL Database?
Unlimited
10,000
50,000
100,000
✅ Correct Answer: Unlimited
51. Which Azure service provides a fully managed service for SQL Server backups?
Azure Backup
Azure Site Recovery
Azure Blob Storage
Azure Archive Storage
✅ Correct Answer: Azure Backup
52. What is the maximum number of columns allowed in a single table in Azure SQL Database?
1024
512
2048
Unlimited
✅ Correct Answer: 1024
53. Which feature enables you to restore a deleted Azure SQL Database?
Point-in-time restore
Geo-restore
Long-term retention
Database copy
✅ Correct Answer: Point-in-time restore
54. What is the maximum number of concurrent requests supported by Azure SQL Database Hyperscale?
Unlimited
1,000
5,000
10,000
✅ Correct Answer: Unlimited
55. Which feature provides detailed query performance analysis for Azure SQL Managed Instance?
Query Store
Extended Events
SQL Profiler
Azure Monitor
✅ Correct Answer: Query Store
56. What is the maximum number of indexes allowed on a single table in Azure SQL Database?
999
500
250
Unlimited
✅ Correct Answer: 999
57. Which PowerShell cmdlet is used to create an Azure SQL Database failover group?
New-AzSqlDatabaseFailoverGroup
Add-AzSqlDatabaseFailoverGroup
Create-AzSqlDatabaseFailoverGroup
Set-AzSqlDatabaseFailoverGroup
✅ Correct Answer: New-AzSqlDatabaseFailoverGroup
58. What is the maximum number of parameters allowed in a stored procedure in Azure SQL Database?
2100
1024
512
Unlimited
✅ Correct Answer: 2100
59. Which feature provides automatic detection and classification of sensitive data in Azure SQL Database?
Data Discovery & Classification
Always Encrypted
Dynamic Data Masking
Row-Level Security
✅ Correct Answer: Data Discovery & Classification
60. What is the maximum number of concurrent sessions supported by Azure SQL Database General Purpose tier?
30,000
10,000
5,000
Unlimited
✅ Correct Answer: 30,000
The Microsoft Dp 300 Administering Relational Databases Azure certification is a globally recognized credential for IT professionals.
This practice test helps you prepare by covering key topics like hardware, networking, troubleshooting, and security.
Want more practice? Check out our other mock exams: