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

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

Add to Whishlist

List of questions

Question 21

Report Export Collapse

DRAG DROP

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.


Microsoft DP-900 image Question 21 90777 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 21 90777 10022024020007000
Explanation:

Box 1: Diagnostic

Diagnostic Analytics: At this stage you can begin to answer some of those why questions. Historical data can begin to be measured against other data to answer the question of why something happened in the past. This is the process of gathering and interpreting different data sets to identify anomalies, detect patters, and determine relationships.

Box 2: Prescriptive

Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.

Box 3: Cognitive

Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitiveanalytics/

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-withiot-analytics/

asked 02/10/2024
RODRIGO BALISTA
45 questions

Question 22

Report Export Collapse

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.


Microsoft DP-900 image Question 22 90778 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 22 90778 10022024020007000
asked 02/10/2024
Jonathan Tang
46 questions

Question 23

Report Export Collapse

DRAG DROP

Match the terms to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.


Microsoft DP-900 image Question 23 90779 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 23 90779 10022024020007000
asked 02/10/2024
Phanel Xavier
50 questions

Question 24

Report Export Collapse

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.


Microsoft DP-900 image Question 24 90780 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 24 90780 10022024020007000
asked 02/10/2024
max artusa
45 questions

Question 25

Report Export Collapse

DRAG DROP

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.


Microsoft DP-900 image Question 25 90781 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 25 90781 10022024020007000
Explanation:


asked 02/10/2024
Francisco Sanchez Valdes
44 questions

Question 26

Report Export Collapse

DRAG DROP

Match the 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.


Microsoft DP-900 image Question 26 90782 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 26 90782 10022024020007000
asked 02/10/2024
Bonnie Lau
37 questions

Question 27

Report Export Collapse

DRAG DROP

Match the job roles to the appropriate tasks.

To answer, drag the appropriate role from the column on the left to its task on the right. Each role

may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Microsoft DP-900 image Question 27 90783 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 27 90783 10022024020007000
asked 02/10/2024
SERGIO MELOSEVICH
50 questions

Question 28

Report Export Collapse

DRAG DROP

Match the ACID 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 aft.

NOTE: Each correct match is worth one point.


Microsoft DP-900 image Question 28 90784 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 28 90784 10022024020007000
asked 02/10/2024
Yucel Cetinkaya
47 questions

Question 29

Report Export Collapse

DRAG DROP

Match the job roles to the appropriate tasks.

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

NOTE: Each correct match is worth one point.


Microsoft DP-900 image Question 29 90785 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 29 90785 10022024020007000
asked 02/10/2024
Eric Jones
51 questions

Question 30

Report Export Collapse

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.


Microsoft DP-900 image Question 30 90786 10022024020007000
Correct answer: Microsoft DP-900 image answer Question 30 90786 10022024020007000
asked 02/10/2024
Ray Hampson II
37 questions
Total 285 questions
Go to page: of 29
Search
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?