Azure Database Administrator (DP-300) Azure Database Administrator (DP-300) Azure Database Administrator (DP-300) 1 / 20 What is Azure Data Factory used for? To manage and automate data workflows To provide a data lake solution To process data in real-time To store backup data securely 2 / 20 Which type of backups does Azure SQL Database use? Only Full Backups Only Differential Backups Only Transaction Log Backups Full, Differential, and Transaction Log backups 3 / 20 How do you configure high availability for Azure SQL Database? By enabling the built-in Azure SQL Database Always On Availability Groups By using the Azure SQL Database Elastic Pool By configuring a point-in-time restore By enabling geo-replication 4 / 20 What Azure service would you use to store and manage large amounts of unstructured data? Azure SQL Database Azure Cosmos DB Azure Blob Storage Azure Data Lake Storage Gen2 5 / 20 What is the difference between Azure SQL Database and Azure SQL Managed Instance? SQL Database only supports SQL Server features SQL Managed Instance does not support backups Azure SQL Database is only used for small workloads Managed Instance provides full SQL Server compatibility and includes a fully managed environment 6 / 20 What is a key benefit of using Azure SQL Database's automatic tuning feature? It automatically applies index recommendations It automatically patches the database It automatically scales the resources It automatically changes the database schema 7 / 20 What is the default storage type for Azure SQL Database? Standard SSD General Purpose Storage High Performance Storage Blob Storage 8 / 20 What is the Azure SQL Database service tier that provides the highest performance? Premium Standard Basic General Purpose 9 / 20 How can you migrate an on-premises SQL Server database to Azure SQL Database? By using the Azure Database Migration Service By using SQL Server Backup and Restore By using Azure Resource Manager By using PowerShell cmdlets 10 / 20 What feature of Azure SQL Database ensures it can scale according to application needs? Virtual Networks Point-in-time restore Automatic scaling based on demand Elastic Pools 11 / 20 Which of the following tools can be used for querying an Azure SQL Database? Azure SQL Management Studio Azure Synapse Analytics Azure Data Explorer Azure Storage Explorer 12 / 20 What Azure service should you use to back up an Azure SQL Database? Azure Backup Azure Data Factory Azure Blob Storage Azure SQL Database Automated Backups 13 / 20 How does Azure SQL Database handle patching? Patches are applied automatically with no downtime Patches are applied manually by users Patches are applied only during scheduled maintenance windows Patches are applied weekly 14 / 20 What is the function of Azure SQL Managed Instance? It is a fully managed database service that provides SQL Server compatibility It is an on-premises SQL Server database service It is a cloud-native non-relational database It provides a low-latency relational database service 15 / 20 How can you secure Azure SQL Database from unauthorized access? By using Transparent Data Encryption (TDE) By using Azure Active Directory Authentication By configuring firewall rules and virtual networks All of the above 16 / 20 What is the default recovery model for an Azure SQL Database? Full Recovery Simple Recovery Bulk-Logged Recovery Transactional Recovery 17 / 20 What feature of Azure SQL Database ensures the availability of a database during failure events? High Availability Database Sharding Backup Services SQL Query Optimization 18 / 20 How do you manage users and permissions in Azure SQL Database? By using Azure Active Directory By configuring SQL Server logins and roles Through Azure Resource Manager Through Azure Event Grid 19 / 20 Which Azure service provides scalable data storage that supports high-performance workloads? Azure Blob Storage Azure SQL Database Azure Data Lake Storage Gen2 Azure Cosmos DB 20 / 20 What is the primary purpose of Azure SQL Database? To provide relational database services in the cloud To provide non-relational data storage To store files securely To perform data analysis on large data sets Your score isThe average score is 0% 0% Restart quiz