ExamGecko
Search Search Login
Home Home / Microsoft / DP-900

Microsoft DP-900 Practice Test - Questions Answers, Page 10

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

DRAG DROP Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
DRAG DROP 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.
DRAG DROP Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
HOTSPOT To complete the sentence, select the appropriate option in the answer area.
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
You need to create a visualization of running sales totals per quarter as shown in the following exhibit. What should you create in Power BI Desktop?
HOTSPOT Select the answer that correctly completes the sentence.
DRAG DROP You have a table named Sales that contains the following data. You need to query the table to return the average sales amount per day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
DRAG DROP Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

Question 91

Report
Export
Collapse

HOTSPOT

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


Question 91
Correct answer: Question 91

Explanation:

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Question 92

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 92
Correct answer: Question 92

Explanation:

A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.

Reference: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reportingservices?view=sql-server-ver15

Question 93

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 93
Correct answer: Question 93

Explanation:

An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:

APPROX_COUNT_DISTINCT

AVG

CHECKSUM_AGG

COUNT

COUNT_BIG

GROUPING

GROUPING_ID

MAX

MIN

STDEV

STDEVP

STRING_AGG

SUM

VAR

VARP

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

Question 94

Report
Export
Collapse

HOTSPOT

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 94
Correct answer: Question 94

Explanation:

Box 1: Yes

Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.

Box 2: Yes

Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.

Box 3: No

Reference:

https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

Question 95

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 95
Correct answer: Question 95

Explanation:

https://learn.microsoft.com/en-us/dynamics365/customer-insights/own-data-lake-storage

Question 96

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 96
Correct answer: Question 96

Question 97

Report
Export
Collapse

HOTSPOT

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 97
Correct answer: Question 97

Question 98

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 98
Correct answer: Question 98

Question 99

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 99
Correct answer: Question 99

Question 100

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 100
Correct answer: Question 100
Total 285 questions
Go to page: of 29
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms