Microsoft DP-300 dumps - 100% Pass Guarantee!

Correct Answer:

Box 1: Key Lookup

The Key Lookup cost is 99% so that is the performance bottleneck.

Box 2: nonclustered index

The key lookup on the clustered index is used because the nonclustered index does not include the required columns to resolve the query. If you add the required columns to the nonclustered index, the key lookup will not be required.

Correct Answer: C

To send a notification in response to an alert, you must first configure SQL Server Agent to send mail. Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:

1.

In Object Explorer, expand a SQL Server instance.

2.

Right-click SQL Server Agent, and then click Properties.

3.

Click Alert System.

4.

Select Enable Mail Profile.

5.

In the Mail system list, select Database Mail.

6.

In the Mail profile list, select a mail profile for Database Mail.

7.

Restart SQL Server Agent. Note: Prerequisites include:

1.

Enable Database Mail.

2.

Create a Database Mail account for the SQL Server Agent service account to use.

3.

Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole in the msdb database.

4.

Set the profile as the default profile for the msdb database.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail- to-use-database-mail

Correct Answer: AC

An auditing policy can be defined for a specific database or as a default server policy in Azure (which hosts SQL Database or Azure Synapse):

1.

A server policy applies to all existing and newly created databases on the server.

2.

If server auditing is enabled, it always applies to the database. The database will be audited, regardless of the database auditing settings.

3.

Enabling auditing on the database, in addition to enabling it on the server, does not override or change any of the settings of the server auditing. Both audits will exist side by side.

Note:

The Server Audit Specification object belongs to an audit. A Database Audit Specification defines which Audit Action Groups will be audited for the specific database in which the specification is created.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview

Correct Answer: D

The partition count for an event hub in a dedicated Event Hubs cluster can be increased after the event hub has been created. Incorrect Answers:

A: For Azure Event standard hubs, the partition count isn't changeable, so you should consider long-term scale when setting partition count.

Reference: https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-features#partitions

Correct Answer: D

Reference: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure