Azure Database Administrator

1. What is the primary responsibility of an Azure Database Administrator?

A) Managing on-premise servers B) Designing and optimizing Azure SQL Databases C) Writing front-end applications D) Configuring firewalls

2. Which Azure service is primarily used for managed SQL databases?

A) Azure Blob Storage B) Azure SQL Database C) Azure Cosmos DB D) Azure Virtual Machines

3. What is the main advantage of Azure SQL Managed Instance over Azure SQL Database?

A) Full SQL Server compatibility B) Requires less configuration C) Lower storage cost D) Better support for NoSQL data

4. In Azure, which service is best suited for NoSQL databases?

A) Azure Cosmos DB B) Azure SQL Database C) Azure Synapse Analytics D) Azure Database for MySQL

5. Which tool is commonly used for managing Azure SQL Databases?

A) MySQL Workbench B) SQL Server Management Studio (SSMS) C) MongoDB Compass D) Azure DevOps

6. What is DTU in Azure SQL Database?

A) Data Transfer Unit B) Database Throughput Unit C) Dynamic Traffic Usage D) Disk Transfer Utility

7. Which of the following backup options is enabled by default in Azure SQL Database?

A) Full, Differential, and Transaction Log backups B) Only full backups C) Only transaction log backups D) Manual backups

8. What is the maximum retention period for long-term backups in Azure SQL Database?

A) 7 days B) 35 days C) 10 years D) 1 year

9. Which Azure service is best for real-time data analytics on large datasets?

A) Azure Synapse Analytics B) Azure SQL Database C) Azure Database for PostgreSQL D) Azure Data Factory

10. What is the best way to improve query performance in Azure SQL Database?

A) Increase storage space B) Use indexes and query tuning C) Restart the database D) Change database collation

11. How does Geo-Replication in Azure SQL Database improve reliability?

A) Stores multiple copies of the database across regions B) Increases database size C) Enables automatic indexing D) Reduces query execution time

12. Which authentication method is recommended for security in Azure SQL Database?

A) SQL Server Authentication B) Active Directory Authentication C) Anonymous Login D) Local User Authentication

13. What is the purpose of Azure Private Link in database security?

A) Encrypts data in transit B) Provides secure private access to Azure SQL Database C) Blocks unauthorized users D) Automates database indexing

14. Which backup option ensures point-in-time recovery in Azure SQL Database?

A) Full Backup B) Differential Backup C) Transaction Log Backup D) Snapshot Backup

15. Which feature in Azure SQL Database automatically optimizes queries?

A) Auto-Tuning B) Query Store C) Index Fragmentation D) Manual Indexing

16. What is the maximum database size for Azure SQL Hyperscale?

A) 1 TB B) 4 TB C) 100 TB D) Unlimited

17. Which Azure tool is used for database migration?

A) Azure Data Factory B) Azure Database Migration Service C) Azure Monitor D) Azure DevOps

18. Which service helps monitor and detect anomalies in database performance?

A) Azure Security Center B) Azure Monitor C) Azure Kubernetes Service D) Azure DevOps

19. What is the best method to prevent SQL injection in Azure SQL Database?

A) Use parameterized queries B) Store passwords in plaintext C) Increase firewall rules D) Disable database backups

20. What is the main benefit of Elastic Pools in Azure SQL Database?

A) Shares compute resources across multiple databases B) Increases storage capacity C) Reduces network latency D) Improves database security

21. What is the purpose of Database Sharding in Azure SQL?

A) Splitting large databases into smaller, distributed parts B) Merging multiple databases into one C) Improving UI performance D) Encrypting data

22. Which disaster recovery solution in Azure SQL ensures automatic failover?

A) Geo-Replication B) Manual Backup C) Elastic Query D) Azure Data Sync

23. What does TDE (Transparent Data Encryption) do in Azure SQL?

A) Encrypts data at rest B) Encrypts data in transit C) Compresses database logs D) Speeds up query execution

24. Which type of index improves query performance in Azure SQL Database?

A) Clustered Index B) No Index C) Redundant Index D) Manual Query Execution

25. Which programming language is primarily used for writing stored procedures in Azure SQL Database?

A) Python B) SQL C) C++ D) JavaScript

Azure Database Administrator

🌟 Job Ready - 100% Scorers