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 5 out of 10 pages
Viewing questions 41-50 out of questions
Questions # 41:

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

Options:

A.

extract transform, and load (ETL)


B.

a data warehouse


C.

online analytical processing (OLAP)


D.

online transaction processing (OLTP)


Expert Solution
Questions # 42:

Select the answer that correctly completes the sentence.

Question # 42


Expert Solution
Questions # 43:

Match the processes to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

Question # 43


Expert Solution
Questions # 44:

Select the answer that correctly completes the sentence.

Question # 44


Expert Solution
Questions # 45:

Select the answer the correctly completes the sentence.

Question # 45


Expert Solution
Questions # 46:

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

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete

solution. (Choose two.)

NOTE: Each correct selection is worth one point.

Options:

A.

the throughput


B.

the read region


C.

the partition key


D.

the API


Expert Solution
Questions # 48:

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?

Options:

A.

stream processing


B.

Online Transaction Processing (OLTP)


C.

batch processing


D.

Online Analytical Processing (OLAP)


Expert Solution
Questions # 49:

Select the answer that correctly completes the sentence.

Question # 49


Expert Solution
Questions # 50:

Match the Azure SQL services to the appropriate use cases.

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


Expert Solution
Viewing page 5 out of 10 pages
Viewing questions 41-50 out of questions