Exam4help.com Is the Best Source For Preparations Of Microsoft DP-300 Dumps PDF

Question No:01

D18912E1457D5D1DDCBD40AB3BF70D5D

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. sys.dm_pdw_nodes_tran_locks

B. sys.dm_exec_compute_node_errors

C. sys.dm_exec_requests

D. sys.dm_cdc_errors

E. sys.dm_pdw_nodes_os_wait_stats

F. sys.dm_tran_locks

Answer: A,E

Explanation:

SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent

blocking queries.

A: Use sys.dm_pdw_nodes_tran_locks instead of sys.dm_tran_locks from Azure Synapse Analytics (SQL

Data Warehouse) or Parallel Data Warehouse.

E: Example:

The following query will show blocking information.

SELECT

Question No:02

D18912E1457D5D1DDCBD40AB3BF70D5D

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance

requirements.

What should you run as part of the implementation?

A. CREATE LOGIN and the FROM WINDOWS clause

B. CREATE USER and the FROM CERTIFICATE clause

C. CREATE USER and the FROM LOGIN clause

D. CREATE USER and the ASYMMETRIC KEY clause

E. CREATE USER and the FROM EXTERNAL PROVIDER clause

Answer: E

Explanation:

Scenario: Authenticate database users by using Active Directory credentials.

(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)

Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:

CREATE USER [Fritz@contoso.com] FROM EXTERNAL PROVIDER;

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sq

Question No:03

Note: This question is part of a series of questions that present the same scenario. Each question in the

series contains a unique solution that might meet the stated goals. Some question sets might have more

than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these

questions will not appear in the review screen.

You have two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL

database named Database1.

You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on

Server2.

Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the

Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.

Does this meet the goal?

A. Yes

B. No

Answer: B

Explanation:

Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and

the REPLACE option.

Note: REPLACE should be used rarely and only after careful consideration. Restore normally prevents

accidentally overwriting a database with a different database. If the database specified in a RESTORE

statement already exists on the current server and the specified database family GUID differs from the

database family GUID recorded in the backup set, the database is not restored. This is an important safeguard.

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql

For more info :

https://www.exam4help.com/microsoft/dp-300-dumps.html