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

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

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 111

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 111
Correct answer: Question 111

Question 112

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 112
Correct answer: Question 112

Question 113

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

Question 114

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 114
Correct answer: Question 114

Question 115

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 115
Correct answer: Question 115

Explanation:

Question 116

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 116
Correct answer: Question 116

Question 117

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 117
Correct answer: Question 117

Explanation:

CSV

CSV (Comma-separated values): This is a text file format that uses commas (,) as column delimiters and carriage returns (\r\n) as row delimiters. CSV files are widely used for exchanging data between different applications and platforms123.

Question 118

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 118
Correct answer: Question 118

Explanation:

JSON (JavaScript Object Notation): This is a text file format that uses a human-readable and compact syntax to represent data as a collection of name-value pairs and arrays. JSON files can express complex and nested data structures by using objects and arrays as values123.

Question 119

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

Question 120

Report
Export
Collapse

HOTSPOT

Select the answer that correctly completes the sentence.


Question 120
Correct answer: Question 120

Explanation:

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