Microsoft Azure Data Fundamentals291 questions across 30 pages are complete and free, with no account or card.
291 questions in this bank
Free access · progress saved on this device
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 all. NOTE: Each correct match is worth one point.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
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.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
The answer is correct. Explanation from ChatGPT Attribute - Get separated into individual columns In a database, an attribute typically refers to a column in a table, which is where individual data elements of an entity are stored. Entities - Get separated into individual tables Entities in a database are typically represented as tables. Each table represents a specific type of object or concept within the system. Foreign Keys - Link two related entities A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. It is used to establish and enforce a link between the data in two tables. Primary keys are the unique identifier for each record in a table. Schema refers to the organization or structure of a database, including its tables, views, relationships, and other elements.
Source: Adapted from community discussion — gravitycat24
HOTSPOT - Select the answer that correctly completes the sentence.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
To create a dashboard, you can use only the Power BI service. The Desktop app is to create visualizations and build reports, not dashboards. And the mobile app is just to view the dash not create.
Source: Adapted from community discussion — 199c280
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.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
From ChatGPT so "take it a pinch of salt " : Data engineers identify data governance rules. Answer: No Explanation: Identifying data governance rules is typically the responsibility of data stewards or data governance teams, not data engineers. However, data engineers may implement these rules in the systems they develop. Data engineers create data ingestion pipelines. Answer: Yes Explanation: Data engineers are responsible for designing, building, and managing data ingestion pipelines to move data from various sources to storage or processing systems.
Source: Adapted from community discussion — AccountHatz
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.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
You have an Azure SQL database that contains tables for customers and orders. You need to create a query that will return the orders placed by each customer. Which two Transact-SOL statements should you include in the query? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Answer: CD
Structured data where each row represents a single data entity uses which type of schema?
Answer: B
HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
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: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Source: Adapted from community discussion — TiTe123
HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area:
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Generally speaking, data analytics comes in four types: 1. Descriptive, to answer the question: What's happening? 2. Diagnostic, to answer the question: Why's happening? 3. Predictive, to answer the question: What will happen? 4. Prescriptive, to answer the question: What actions should we take? Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/
Source: Adapted from community discussion — Roy_zuniga
HOTSPOT - Select the answer that correctly completes the sentence.
This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.
Answer: See figure below
Correct Answer One common workflow in Power BI begins by connecting to data sources in Power BI Desktop and building a report.
Source: Adapted from community discussion — subhayu.biswas12
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 201. 291 questions available.
Version 1.0.0. How we source questions
