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

Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions
Questions # 11:

A bank has a system that manages financial transactions.

When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.

Of which ACID semantic is this an example?

Options:

A.

atomicity


B.

isolation


C.

durability


D.

consistency


Expert Solution
Questions # 12:

When you create an Azure SQL database, which account can always connect to the database ?

Options:

A.

the Azure Active director/ (Azure AO) account that created the database


B.

the Azure Active Directly Azure AD) administrator account


C.

the sa account


D.

the server admin login account of the logical server


Expert Solution
Questions # 13:

Match the Azure services to the appropriate requirements.

To answer, drag the appropriate service from the column on the left to its requirement 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 # 13


Expert Solution
Questions # 14:

Match the data processing languages to the appropriate real-time analytics services.

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

NOTE: Each correct match is worth one point.

Question # 14


Expert Solution
Questions # 15:

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?

Options:

A.

stream processing


B.

batch processing


C.

Online Analytical Processing (OLTP)


D.

Online Transaction Processing (OLTP)


Expert Solution
Questions # 16:

Select the answer that correctly completes the sentence.

Question # 16


Expert Solution
Questions # 17:

Select the answer that correctly completes the sentence.


Expert Solution
Questions # 18:

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

NOTE: Each correct selection is worth one point.

Question # 18


Expert Solution
Questions # 19:

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

Options:

A.

Azure HDInsight


B.

Azure SQL Database


C.

Azure Cosmos DB


D.

SQL Server on Azure virtual machines


Expert Solution
Questions # 20:

You need to store data in Azure Blob storage for seven years to meet your company's compliance

requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

Options:

A.

Archive


B.

Hot


C.

Cool


Expert Solution
Viewing page 2 out of 10 pages
Viewing questions 11-20 out of questions