Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Pass the Microsoft Microsoft Certified: Azure Data Fundamentals DP-900 Questions and answers with CertsForce

Viewing page 8 out of 10 pages
Viewing questions 71-80 out of questions
Questions # 71:

Match the types of data stores to the appropriate scenarios.

To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Question # 71


Expert Solution
Questions # 72:

Select the answer that correctly completes the sentence.

Question # 72


Expert Solution
Questions # 73:

To complement the sentence, select the appropriate option in the answer area.

Question # 73


Expert Solution
Questions # 74:

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Options:

A.

Scale down the data warehouse units (DWUs).


B.

Pause the pool.


C.

Create a user-defined restore point.


D.

Delete the pool


Expert Solution
Questions # 75:

Your company needs to ensure that in Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use?

Options:

A.

Azure DNS


B.

Azure Application Gateway


C.

Azure Private link


D.

Azure Traffic Manager


Expert Solution
Questions # 76:

Match the Azure services to the appropriate locations in the architecture.

To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Question # 76


Expert Solution
Questions # 77:

Match the job roles to the appropriate tasks.

To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Question # 77


Expert Solution
Questions # 78:

Select the answer that correctly completes the sentence.


Expert Solution
Questions # 79:

Select the answer that correctly completes the sentence.

Question # 79


Expert Solution
Questions # 80:

What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

Options:

A.

normalized data


B.

schema defined in a database


C.

schema defined when reading unstructured data from a database


D.

normalized data


E.

light writes and heavy reads


F.

heavy writes and moderate reads


Expert Solution
Viewing page 8 out of 10 pages
Viewing questions 71-80 out of questions