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 is

The average score is 0%