Logo ExamsQA
Exit
Official Bank 0/388

Administering Relational Databases on Microsoft Azure Exam (DP-300) - Microsoft Exam Questions

Last updated on June 22, 2026

97% Exam Compliance
388 Total Questions
1
Question
You have an Azure subscription that contains the resources shown in the following table.

Exhibit

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do?
Options
A Decrease the auto-pause delay for db1.
B Disable auto-pause delay for dbl.
C Increase the number Of vCores allocated to db1.
D Enable automatic tuning for db1.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
You have an Azure SQL database named DB1. You run a query while connected to DB1. You review the actual execution plan for the query, and you add an index to a table referenced by the query. You need to compare the previous actual execution plan for the query to the Live Query Statistics.

What should you do first in Microsoft SQL Server Management Studio (SSMS)?
Options
A Save the actual execution plan.
B Run the SET SHOWPLAN_ALL Transact-SQL statement.
C For DB1, set QUERY_CAPTURE_MODE of Query Store to All.
D Enable Query Store for DB1.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
HOTSPOT You have an Azure subscription that contains an Always On availability group named AG1. AG1 contains three replicas named Server1. Server2. and Server3. You execute the following T-SQL statements on Server1.

Exhibit

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

NOTE: Each correct selection is worth one point.

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in the data warehouse is encrypted at rest.

What should you enable?
Options
A Always Encrypted for all columns
B Advanced Data Security for this database
C Transparent Data Encryption (TDE)
D Secure transfer required
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
HOTSPOT You have an Azure SQL database named that contains a table named Table1. You run a query to bad data into Table1. The performance Of Table1 during the load operation are shown in exhibit.

Exhibit

Exhibit
HOTSPOT
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.