DP-300 Leak Questions

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 49

You have an Azure subscription.

You need to deploy an Azure SQL database. The solution must meet the following requirements:

• Dynamically scale CPU resources.

• Ensure that the database can be paused to reduce costs.

What should you use?

Options:

the Business Critical service tier

the serverless compute tier

an elastic pool

the General Purpose service tier

Question 50

You have the following Azure Data Factory pipelines:

Ingest Data from System1

Ingest Data from System2

Populate Dimensions

Populate Facts

Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.

What should you do to schedule the pipelines for execution?

Options:

Add a schedule trigger to all four pipelines.

Add an event trigger to all four pipelines.

Create a parent pipeline that contains the four pipelines and use an event trigger.

Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Question 51

You have an Azure SQL database named DB1.

You need to encrypt DB1. The solution must meet the following requirements;

• Encrypt data in motion.

• Support comparison operators.

• Provide randomized encryption.

What should you include in the solution?

Options:

Always Encrypted

column-level encryption

Transparent Data Encryption (TDE)

Always Encrypted with secure enclaves

Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Administering Relational Databases on Microsoft Azure Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer: