Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

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

Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions
Questions # 21:

Match the types of visualizations to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Question # 21


Expert Solution
Questions # 22:

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

Question # 22


Expert Solution
Questions # 23:

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 # 24:

Match the database normalization 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 all.

NOTE: Each correct match is worth one point.

Question # 24


Expert Solution
Questions # 25:

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to persist the SQL query so that other users can use the query. What should you create?

Options:

A.

a table


B.

an index


C.

scalar function


D.

a view


Expert Solution
Questions # 26:

To complete the sentence select the appropriate option in the answer area.

Question # 26


Expert Solution
Questions # 27:

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

Question # 27


Expert Solution
Questions # 28:

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.

Which type of data store should you recommend?

Options:

A.

document


B.

key/value


C.

object


D.

columnar


Expert Solution
Questions # 29:

Which type of database contains nodes and edges?

Options:

A.

graph


B.

columnar


C.

key/value


D.

time series


Expert Solution
Questions # 30:

Your company is designing a data store that will contain student data. The data has the following format.

Question # 30

Which type of data store should you use?

Options:

A.

graph


B.

key/value


C.

object


D.

columnar


Expert Solution
Viewing page 3 out of 10 pages
Viewing questions 21-30 out of questions