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

Viewing page 1 out of 10 pages
Viewing questions 1-10 out of questions
Questions # 1:

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

container


B.

item


C.

database


D.

partition


Expert Solution
Questions # 2:

What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

Options:

A.

native support for cross-database queries and transactions


B.

built-in high availability


C.

system-Initiated automatic backups


D.

support for encryption at rest


Expert Solution
Questions # 3:

Match the ACID terms to the Appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Question # 3


Expert Solution
Questions # 4:

Select the answer that correctly completes the sentence.

Question # 4


Expert Solution
Questions # 5:

Your company if designing an application that will write a high volume of JSON data and will have an application-defined schema.

Which type of data store should you use?

Options:

A.

key/value


B.

document


C.

graph


D.

columnar


Expert Solution
Questions # 6:

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

NOTE: Each correct selection is worth one point.

Question # 6


Expert Solution
Questions # 7:

What is the primary purpose of a data warehouse?

Options:

A.

to provide answers to complex queries that rely on data from multiple sources


B.

to provide transformation services between source and target data stores


C.

to provide read-only storage of relational and non-relational historical data


D.

to provide storage for transactional line-of-business (LOB) applications


Expert Solution
Questions # 8:

You are reviewing the data model shown in the following exhibit.

Question # 8

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

Question # 8


Expert Solution
Questions # 9:

Which Azure Storage service implements the key/value model?

Options:

A.

Azure Files


B.

Azure Table


C.

Azure Blob


D.

Azure Queue


Expert Solution
Questions # 10:

You need to design and model a database by using a graphical tool that supports project-oriented offline

database development.

What should you use?

Options:

A.

Microsoft SQL Server Data Tools (SSDT)


B.

Microsoft SQL Server Management Studio (SSMS)


C.

Azure Databricks


D.

Azure Data Studio


Expert Solution
Viewing page 1 out of 10 pages
Viewing questions 1-10 out of questions