WorksheetsDP-300 Azure SQL MCQs
Total questions: 20
Worksheet time: 10mins
Which Azure SQL deployment option provides the highest level of compatibility with SQL Server?
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VM
Azure Synapse Analytics
What is the primary benefit of using SQL Server on Azure Virtual Machines?
Fully managed PaaS
Automatic scaling
Full control over the OS and SQL Server configuration
Serverless compute
Which tool is best suited for automating Azure SQL deployments using infrastructure as code?
Azure Monitor
Azure Resource Manager (ARM) templates
SQL Server Management Studio (SSMS)
Azure Advisor
Which deployment model supports patching and updates for hybrid environments?
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VM
Azure Cosmos DB
Which feature allows synchronization of data between Azure SQL and on-premises SQL Server?
Azure Data Factory
SQL Data Sync
Azure Backup
Azure Site Recovery
Which tier of Azure SQL Database supports automatic scaling based on workload?
Basic
Standard
Premium
Serverless
What is the primary benefit of table partitioning in SQL Server?
Increased storage
Improved query performance and manageability
Enhanced security
Reduced licensing cost
Which compression type is most effective for reducing storage in SQL Server?
Row compression
Page compression
Columnstore compression
None
Which Azure SQL offering allows vertical scaling by changing the compute size?
Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure VM
All of the above
Which performance feature is available in Azure SQL Managed Instance but not in Azure SQL Database?
In-memory OLTP
Elastic pools
Geo-replication
Serverless compute
Which tool is recommended for assessing on-premises SQL Server readiness for migration to Azure?
Azure Migrate
Data Migration Assistant (DMA)
Azure Monitor
SQL Server Profiler
Which migration strategy minimizes downtime during migration?
Offline migration
Online migration
Backup and restore
Detach and attach
Which tool supports online migration to Azure SQL Database?
SQL Server Management Studio
Azure Database Migration Service
Azure Data Factory
Azure Monitor
What is a key post-migration validation step?
Rebooting the server
Checking firewall rules
Verifying data integrity and performance
Reinstalling SQL Server
Which method is used to migrate a database between Azure SQL services?
BACPAC export/import
FTP transfer
Azure Blob copy
Azure Monitor
Which database offering is best for high-performance analytics workloads?
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL Server on Azure VM
Which factor is most important when recommending a sharding solution?
Security
Licensing
Data distribution and scalability
Backup frequency
Which security feature is available across all Azure SQL offerings?
Transparent Data Encryption (TDE)
Always On Availability Groups
SQL Server Audit
Windows Authentication
Which partitioning strategy is best for time-series data?
Hash partitioning
List partitioning
Range partitioning
Round-robin partitioning
Which Azure SQL feature helps reduce latency for global applications?
Elastic pools
Geo-replication
Serverless compute
Data compression
