ExamGecko
Login
Home / Microsoft / DP-900 / List of questions
Ask Question

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

Add to Whishlist

List of questions

Question 91

Report Export Collapse

HOTSPOT

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


Microsoft DP-900 image Question 91 90707 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 91 90707 10022024020007000
Explanation:

Reference:

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

asked 02/10/2024
SAI CHARAN TANGELLA
40 questions

Question 92

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 92 90708 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 92 90708 10022024020007000
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

asked 02/10/2024
mark anthony sampayan
39 questions

Question 93

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 93 90709 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 93 90709 10022024020007000
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

asked 02/10/2024
Elliott Fields
36 questions

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.


Microsoft DP-900 image Question 94 90710 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 94 90710 10022024020007000
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/

asked 02/10/2024
Haythem KEfi
38 questions

Question 95

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 95 90711 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 95 90711 10022024020007000
Explanation:

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

asked 02/10/2024
MICHELE CRISTINA DOS FELIX
41 questions

Question 96

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 96 90712 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 96 90712 10022024020007000
asked 02/10/2024
Scott Taylor
36 questions

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.


Microsoft DP-900 image Question 97 90713 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 97 90713 10022024020007000
asked 02/10/2024
German Lopez
45 questions

Question 98

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 98 90714 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 98 90714 10022024020007000
asked 02/10/2024
Anupam Ojha
44 questions

Question 99

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 99 90715 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 99 90715 10022024020007000
asked 02/10/2024
Katlego Nkwane
52 questions

Question 100

Report Export Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Microsoft DP-900 image Question 100 90716 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 100 90716 10022024020007000
asked 02/10/2024
Brandon O'Driscoll
41 questions
Total 285 questions
Go to page: of 29
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have an application that runs on Windows and requires access to a mapped drive. Which Azure service should you use?
DRAG DROP Match the data processing languages to the appropriate real-time analytics services. To answer, drag the appropriate language from the column on the left to its service on the right. Each language may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
DRAG DROP 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.
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 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.
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?
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 Select the answer that correctly completes the sentence.
You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?