ExamGecko
Home Home / Microsoft / DP-900

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

Question list
Search
Search

List of questions

Search

Related questions











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.


Question 21
Correct answer: Question 21

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/

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.


Question 22
Correct answer: Question 22

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.


Question 23
Correct answer: Question 23

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.


Question 24
Correct answer: Question 24

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.


Question 25
Correct answer: Question 25

Explanation:


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.


Question 26
Correct answer: Question 26

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.

Question 27
Correct answer: Question 27

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.


Question 28
Correct answer: Question 28

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.


Question 29
Correct answer: Question 29

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.


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