Dumps4free
Home / Microsoft / Microsoft Certified: Azure Database Administrator Associate / DP-300 - Administering Relational Databases on Microsoft Azure

Latest DP-300 Exam Questions


Question # 1



You have an Azure SQL database.
You have a query and the associated execution plan as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement
based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

 

Expalantion:-

Graphical user interface, text, application, email
Description automatically generated
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.




Question # 2



You have an Azure subscription that contains a logical SQL server named Serverl. The
master database of Serverl contains a user named Userl. You need to ensure that Userl
can create databases on Serverl. Which database role should you assign to Userl?

A.

db_owner

B.

dbmanager

C.

dbo

D.

db_ddladmin




B.   

dbmanager






Question # 3



You have SQL Server on an Azure virtual machine.
You need to add a 4-TB volume that meets the following requirements:
Maximizes IOPs
Uses premium solid state drives (SSDs)
What should you do?

A.

Attach two mirrored 4-TB SSDs

B.

Attach a stripe set that contains four 1-TB SSDs.

C.

Attach a RAID-5 array that contains five 1-TB SSDs.

D.

Attach a single 4-TB SSD.




B.   

Attach a stripe set that contains four 1-TB SSDs.



https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storageconfiguration?
tabs=windows2016




Question # 4



You have an Azure subscription that contains an Azure SQL database named SQL1.
SQL1 is in an Azure region that does not support availability zones.
You need to ensure that you have a secondary replica of SQLI in the same region.
What should you use?

A.

log shipping

B.

auto-failover groups

C.

active geo-replication

D.

Microsoft SQL Server failover clusters




C.   

active geo-replication






Question # 5



You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for
the query. The solution must minimize administrative effort.

What should you use?

A.

the Azure portal

B.

Extended Events

C.

Query Store

D.

dynamic management views




C.   

Query Store



https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoringperformance-
by-using-the-query-store?view=sql-server-ver15




Question # 6



You have an Azure subscription that uses a domain named contoso.com.
You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default
SQL Server instance. DBServer1 is in the East US Azure region and contains a database
named DatabaseA. DBServer2 is in the West US Azure region.

DBServer1 has a high volume of data changes and low latency requirements for data
writes.
You need to configure a new availability group for DatabaseA. The secondary replica will
reside on DBServer2.
What should you do?

A.

Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the
secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to
Asynchronous.

B.

Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the
secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to
Synchronous.

C.

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the
secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode
to Asynchronous.

D.

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the
secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode
to Synchronous.




C.   

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the
secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode
to Asynchronous.



https://docs.microsoft.com/en-us/sql/database-engine/availabilitygroups/
windows/availability-modes-always-on-availability-groups?view=sql-server-ver15




Question # 7



You deploy a database to an Azure SQL Database managed instance.
You need to prevent read queries from blocking queries that are trying to write to the
database.
Which database option should set?

A.

PARAMETERIZATION to FORCED

B.

PARAMETERIZATION to SIMPLE

C.

Delayed Durability to Forced

D.

READ_COMMITTED_SNAPSHOT to ON




D.   

READ_COMMITTED_SNAPSHOT to ON



In SQL Server, you can also minimize locking contention while protecting transactions from
dirty reads of uncommitted data modifications using either:
The READ COMMITTED isolation level with the
READ_COMMITTED_SNAPSHOT database option set to ON.

Explanation:-

The SNAPSHOT isolation level.
If READ_COMMITTED_SNAPSHOT is set to ON (the default on SQL Azure Database),
the Database Engine uses row versioning to present each statement with a transactionally
consistent snapshot of the data as it existed at the start of the statement. Locks are not
used to protect the data from updates by other transactions.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-leveltransact-
sql




Question # 8



You have an Azure subscription that contains the resources shown in the following table.

You need to create a read-only replica of DB1 and configure the App1 instances to use the
replica.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Explanation:-

Text
Description automatically generated




Question # 9



You have an Azure Data Factory that contains 10 pipelines.
You need to label each pipeline with its main purpose of either ingest, transform, or load.
The labels must be
available for grouping and filtering when using the monitoring experience in Data Factory.

What should you add to each pipeline?

A.

an annotation

B.

a resource tag

C.

a run group ID

D.

a user property

E.

a correlation ID




A.   

an annotation



Azure Data Factory annotations help you easily filter different Azure Data Factory objects
based on a tag. You
can define tags so you can see their performance or find errors faster.
Reference:
https://www.techtalkcorner.com/monitor-azure-data-factory-annotations/




Question # 10



You are provisioning an Azure SQL database in the Azure portal as shown in the following
exhibit.

Use the drop-down menus to select the answer choice that completes each statement
based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

 

 

 

Explanation:

Graphical user interface, text, application, email
Description automatically generated



Get 337 Administering Relational Databases on Microsoft Azure questions Access in less then $0.15 per day.

Total Questions Answers: 337
Last Updated: 11-Oct-2024
Available with 1, 3, 6 and 12 Months Free Updates Plans
PDF/ Day: $0.15

Test Engine/ Day: $0.18

PDF + Engine/ Day: $0.20


Microsoft DP-300 Dumps - Latest Questions


Exam Code: DP-300
Exam Name: Administering Relational Databases on Microsoft Azure

  • 90 Days Free Updates
  • Microsoft Experts Verified Answers
  • Printable PDF File Format
  • DP-300 Exam Passing Assurance

Get 100% Real DP-300 Exam Dumps With Verified Answers As Seen in the Real Exam. Administering Relational Databases on Microsoft Azure Exam Questions are Updated Frequently and Reviewed by Industry TOP Experts for Passing Microsoft Certified: Azure Database Administrator Associate Exam Quickly and Hassle Free.

Microsoft Certified: Azure Database Administrator Associate Exams
Microsoft DP-900 Exam Dumps

Microsoft DP-300 Exam Questions


Struggling with Administering Relational Databases on Microsoft Azure prep? Get the edge you need!

Our carefully crafted DP-300 dumps give you the confidence to ace the exam. We offer:

  • Up-to-date Microsoft Certified: Azure Database Administrator Associate practice questions: Stay current with the latest exam content.
  • PDF and test engine formats: Choose the study tools that work best for you.
  • Realistic Microsoft DP-300 practice exams: Simulate the real exam experience and boost your readiness.
Pass your Microsoft Certified: Azure Database Administrator Associate exam with ease. Try our study materials today!

DP-300 Practice Test Details

180 Single Choice Questions
24 Multiple Choice Questions
82 Hotspot Questions
34 Drag Drop Questions
1 Fill in the Blanks
12 Performance Based Questions

Ace your Microsoft Certified: Azure Database Administrator Associate exam with confidence!



We provide top-quality DP-300 exam prep materials that are:
  • Accurate and up-to-date: Reflect the latest Microsoft exam changes and ensure you are studying the right content. 
  • Comprehensive: Cover all exam topics so you do not need to rely on multiple sources. 
  • Convenient formats: Choose between PDF files and online Administering Relational Databases on Microsoft Azure practice tests for easy studying on any device.
Do not waste time on unreliable DP-300 practice exams. Choose our proven Microsoft Certified: Azure Database Administrator Associate study materials and pass with flying colors.

Try Dumps4free Administering Relational Databases on Microsoft Azure Exam 2024 PDFs today!

  • Assurance

    Administering Relational Databases on Microsoft Azure practice exam has been updated to reflect the most recent questions from the Microsoft DP-300 Exam.

  • Demo

    Try before you buy! Get a free demo of our Microsoft Certified: Azure Database Administrator Associate exam dumps and see the quality for yourself. Need help? Chat with our support team.

  • Validity

    Our Microsoft DP-300 PDF contains expert-verified questions and answers, ensuring you're studying the most accurate and relevant material.

  • Success

    Achieve DP-300 success! Our Administering Relational Databases on Microsoft Azure exam questions give you the preparation edge.

If you have any question then contact our customer support at live chat or email us at support@dumps4free.com.