Spring Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Pass the Microsoft Certified: Azure Database Administrator Associate DP-300 Questions and answers with Dumpstech

Home
Microsoft
Microsoft Certified: Azure Database Administrator Associate
DP-300
DP-300 Questions and Answers

Exam DP-300 Premium Access

View all detail and faqs for the DP-300 exam

Go to Exam

Practice at least 50% of the questions to maximize your chances of passing.

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Questions # 21:

You are evaluating the role assignments.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Question # 21

Options:

Answer

Answer:

Explanation

Box 1: Yes

DBAGroup1 is member of the Contributor role.

The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.

Box 2: No

Box 3: Yes

DBAGroup2 is member of the SQL DB Contributor role.

The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.

[Reference:, https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles, , ]

Questions # 22:

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.

What should you do?

Options:

Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.

Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.

Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.

Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

Answer

Explanation

[Reference:, https://azure.microsoft.com/en-gb/blog/announcing-azure-monitor-aiops-alerts-with-dynamic-thresholds/, , , ]

Questions # 23:

What should you implement to meet the disaster recovery requirements for the PaaS solution?

Options:

Availability Zones

failover groups

Always On availability groups

geo-replication

Answer

Explanation

Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.

The auto-failover groups feature allows you to manage the replication and failover of a group of databases on a server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale. You can initiate failover manually or you can delegate it to the Azure service based on a user-defined policy.

The latter option allows you to automatically recover multiple related databases in a secondary region after a catastrophic failure or other unplanned event that results in full or partial loss of the SQL Database or SQL Managed Instance availability in the primary region.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview, , , , , ]

Questions # 24:

Which counter should you monitor for real-time processing to meet the technical requirements?

Options:

SU% Utilization

CPU% utilization

Concurrent users

Data Conversion Errors

Answer

Explanation

Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns.

To monitor the performance of a database in Azure SQL Database and Azure SQL Managed Instance, start by monitoring the CPU and IO resources used by your workload relative to the level of database performance you chose in selecting a particular service tier and performance level.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview, ]

Questions # 25:

Which windowing function should you use to perform the streaming aggregation of the sales data?

Options:

Sliding

Hopping

Session

Tumbling

Answer

Explanation

Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytics process will perform aggregations that must be done continuously, without gaps, and without overlapping.

Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.

[Reference:, https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/stream-analytics/stream-analytics-window-functions.md, ]

Questions # 26:

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

Options:

an Azure SQL database

an Azure Blob Storage container

a SQL Server filegroup

an Azure Files share

Answer

Questions # 27:

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

Options:

Run the sys.5p_cdc_en«ble_db stored procedure.

Run the alter table statement and specify the enable chahgc_tracking clause.

Run the alter database statement and specify the set cmange_trackinc> - on clause.

Run the sp_addarticle stored procedure.

Answer

Questions # 28:

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?

Options:

Configure Microsoft Entra authentication for the logical server that hosts DB3.

Create a database that has database-scoped credentials.

Configure a private endpoint for connectivity to DB3.

Create data base-scoped credentials in DB3.

Answer

Questions # 29:

You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE Each correct selection is worth one point.

Question # 29

Options:

Answer

Answer:

Questions # 30:

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

Options:

Configure virtual network service endpoints.

Enable database firewall rules.

Create database-scoped credentials.

Configure connection strings that reference the read-write listener.

Answer

Viewing page 3 out of 5 pages

Viewing questions 21-30 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).