The latest Microsoft DP-900 Azure Data Fundamentals certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft DP-900 Azure Data Fundamentals exam and earn Microsoft DP-900 Azure Data Fundamentals certification.
Table of Contents
- DP-900 Question 141
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 142
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 143
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 144
- Exam Question
- Correct Answer
- Reference
- DP-900 Question 145
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 146
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 147
- Exam Question
- Correct Answer
- Explanation
- DP-900 Question 148
- Exam Question
- Correct Answer
- DP-900 Question 149
- Exam Question
- Correct Answer
- Explanation
- Reference
- DP-900 Question 150
- Exam Question
- Correct Answer
DP-900 Question 141
Exam Question
To complete the sentence, select the appropriate option in the answer area.
__________ is an object associated with a table that sorts and stores the data rows in the table based on their key values.
Answer Area:
A. A clustered index
B. A FileTable
C. A foreign key
D. A stored procedure
Correct Answer
A. A clustered index
Explanation
Microsoft Learn > SQL > SQL Server > Clustered and nonclustered indexes described
DP-900 Question 142
Exam Question
To complete the sentence, select the appropriate option in the answer area.
The massively parallel processing (MPP) engine of Azure Synapse Analytics __________.
Answer Area:
A. distributes processing across compute nodes.
B. distributes processing across control nodes.
C.redirects client connections across compute nodes.
D. redirects client connections across control nodes.
Correct Answer
A. distributes processing across compute nodes.
Explanation
Microsoft Learn > Azure > Synapse Analytics > Dedicated SQL pool (formerly SQL DW) architecture in Azure Synapse Analytics
DP-900 Question 143
Exam Question
You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
The data model is a __________.
Answer Area:
- transactional model
- star schema
- snowflake schema
Customer is a __________ table.
Answer Area:
- fact
- dimension
- bridge
Correct Answer
<box 1>: star schema
<box 2>: dimension
Explanation
<box 1>: star schema
In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables. The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.
Example:
Incorrect Answers:
The data in the question is not normalized.
The snowflake schema is a variation of the star schema, featuring normalization of dimension tables.
Example:
Note: A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.[citation needed]. “Snowflaking” is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.
<box 2>: dimension
The star schema consists of one or more fact tables referencing any number of dimension tables.
Reference
- Microsoft Learn > Azure > Synapse Analytics > Design tables using dedicated SQL pool in Azure Synapse Analytics
- Star schema
- Snowflake schema
- Data models within Azure Analysis Services and Power BI
DP-900 Question 144
Exam Question
You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
Customer is __________.
Answer Area for __________:
- a nested array
- a nested object
- a root object
Address is __________.
Answer Area:
- a nested array
- a nested object
- a root object
Social media is __________.
Answer Area:
- a nested array
- a nested object
- a root object
Correct Answer
<box 1>: a root object
<box 2>: a nested object
<box 3>: a nested array
Reference
DP-900 Question 145
Exam Question
Match the types of analytics that can be used to answer the business questions. Each analytics type may be used once, more than once, or not at all.
Analytics Types:
- Cognitive
- Diagnostic
- Descriptive
- Predictive
- Prescriptive
Business Questions:
- Why did sales increase last month?
- How do I allocate my budget to buy different inventory items?
- Which people are mentioned in a company’s business documents?
Correct Answer
Diagnostic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items?
Descriptive: Which people are mentioned in a company’s business documents?
Explanation
Diagnostic: Why did sales increase last month?
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.
Prescriptive: How do I allocate my budget to buy different inventory items?
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Incorrect Answer:
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Descriptive: Which people are mentioned in a company’s business documents?
Generally speaking, data analytics comes in four types:
- Descriptive, to answer the question: What’s happening?
- Diagnostic, to answer the question: Why’s happening?
- Predictive, to answer the question: What will happen?
- Prescriptive, to answer the question: What actions should we take?
Reference
Describe, diagnose, and predict with IoT Analytics
DP-900 Question 146
Exam Question
Match the types of analytics that can be used to answer the business questions. Each analytics type may be used once, more than once, or not at all.
Analytics Types:
- Cognitive
- Diagnostic
- Descriptive
- Predictive
- Prescriptive
Business Questions:
- Why did sales increase last month?
- How do I allocate my budget to buy different inventory items?
- Which people are mentioned in a company’s business documents?
Correct Answer
Diagnostic: Why did sales increase last month?
Prescriptive: How do I allocate my budget to buy different inventory items?
Descriptive: Which people are mentioned in a company’s business documents?
Explanation
Diagnostic: Why did sales increase last month?
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.
Prescriptive: How do I allocate my budget to buy different inventory items?
Prescriptive analytics is a combination of data, mathematical models, and various business rules to infer actions to influence future desired outcomes.
Incorrect Answer:
Predictive analytics, broadly speaking, is a category of business intelligence that uses descriptive and predictive variables from the past to analyze and identify the likelihood of an unknown future outcome
Descriptive: Which people are mentioned in a company’s business documents?
Generally speaking, data analytics comes in four types:
- Descriptive, to answer the question: What’s happening?
- Diagnostic, to answer the question: Why’s happening?
- Predictive, to answer the question: What will happen?
- Prescriptive, to answer the question: What actions should we take?
Reference
Describe, diagnose, and predict with IoT Analytics
DP-900 Question 147
Exam Question
To complete the sentence, select the appropriate option in the answer area.
Transcribing audio files is an example of __________ analytics.
Answer Area:
A. cognitive
B. descriptive
C. predictive
D. prescriptive
Correct Answer
A. cognitive
Explanation
DP-900 Question 148
Exam Question
To complete the sentence, select the appropriate option in the answer area.
In batch processing, __________.
Answer Area:
A. data is always inserted one row at a time.
B. data is processed in real-time.
C. latency is expected.
D. processing can only execute serially.
Correct Answer
C. latency is expected.
DP-900 Question 149
Exam Question
To complete the sentence, select the appropriate option in the answer area.
An extract, transform, and load (ETL) process requires __________.
Answer Area:
A. a matching schema in the data source and the data target.
B. a target data store powerful enough to transform data.
C. data that is fully processed before being loaded to the target data store.
D. that the data target be a relational database.
Correct Answer
C. data that is fully processed before being loaded to the target data store.
Explanation
Extract, transform, and load (ETL) is a data pipeline used to collect data from various sources, transform the data according to business rules, and load it into a destination data store.
Reference
Microsoft Learn > Azure > Architecture > Data Architecture Guide > Extract, transform, and load (ETL)
DP-900 Question 150
Exam Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Statement 1: Normalization involves eliminating relationships between database tables.
Statement 2: Normalizing a database reduces data redundancy.
Statement 3: Normalization improves data integrity.
Correct Answer
Statement 1: Normalization involves eliminating relationships between database tables: No
Statement 2: Normalizing a database reduces data redundancy: Yes
Statement 3: Normalization improves data integrity: Yes