Free Microsoft DP-900 Practice Exam with Questions & Answers | Set: 3

You are building a Microsoft Power B1 report for a retail company. The data model for the report contains the following related Tables.

Vou need to create a visualization that shows the percentage of total sales by store type. The solution must minimize the number of fields and visuals used.

What should you do?

Select the answer that correctly completes the sentence.

Which file format has defined names and data types for each column and uses compressed columnar storage?

Match the Azure Cosmos DB APIs to the appropriate data structures.

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

NOTE: Each correct match is worth one point.

What is the primary purpose of a data warehouse?

match the Azure data factory components to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

Match the types of analytics that can be used to answer the business questions.

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

NOTE: Each correct match is worth one point.

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic interface, depict various key performance indications, and support data exploration by using drill down.

What should you use in Microsoft Power BI?

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

Select the answer that correctly completes the sentence.