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
A bar chart showing year-to-date sales by region is an example of which type of analytics?
Answer: C
C (descriptive) is the correct answer . If it were "diagnostic", the question would be "WHY have the sales been this number".
Source: Adapted from community discussion — aneta7x
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. 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
Reference: https://www.precisely.com/blog/big-data/big-data-101-batch-stream-processing
Source: Adapted from community discussion — maci_popo
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics. What should you use?
Answer: C
Hybrid Transactional and Analytical Processing (HTAP) is a technique for near real time analytics without a complex ETL solution. In Azure Synapse Analytics, HTAP is supported through Azure Synapse Link. https://learn.microsoft.com/en-us/training/paths/work-with-hybrid-transactional-analytical-processing-solutions/#:~:text=Hybrid%20Transactional%20and%20Analytical%20Processing%20(HTAP)%20is%20a%20technique%20for,Data%20Engineering%20on%20Microsoft%20Azure.
Source: Adapted from community discussion — Stuurwiel1
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?
Answer: A
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a
You have the following two tables of customer data.
Which type of data do the tables contain?
Answer: A
Come on now. Tables, columns and rows? This is step one of Data Fundamentals. Please change this answer to A because it's structured data. Shocking.
Source: Adapted from community discussion — TomGray1989
HOTSPOT - Select the answer that correctly completes the sentence. 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
Answer should be A: https://learn.microsoft.com/en-us/azure/cosmos-db/gremlin/introduction Azure Cosmos DB for Apache Gremlin is a graph database service that can be used to store massive graphs with billions of vertices and edges. You can query the graphs with millisecond latency and evolve the graph structure easily.
Source: Adapted from community discussion — boppp
Which statement is an example of Data Manipulation Language (DML)?
Answer: C
A. Incorrect. REVOKE is a Data Control Language (DCL) command used to remove user permissions. B. Incorrect. DISABLE is an administrative command used to disable features, such as triggers, and is not part of DML. C. Correct. INSERT is a Data Manipulation Language (DML) command used to add new rows of data into a table. D. Incorrect. GRANT is a Data Control Language (DCL) command used to provide user permissions. DML commands are used to modify data in a database, and INSERT is one of the key DML commands, along with UPDATE, DELETE, and SELECT.
Source: Adapted from community discussion — man5484
Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?
Answer: B
Change feed https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-change-feed Change feed support is well-suited for scenarios that process data based on objects that have changed. For example, applications can: - Update a secondary index, synchronize with a cache, search-engine, or any other content-management scenarios.
Source: Adapted from community discussion — jellybiscuit
You have an on-premises Microsoft SQL Server database. You need to migrate the database to the cloud. The solution must meet the following requirements: * Minimize maintenance effort. * Support the Database Mail and Service Broker features. What should you include in the solution?
Answer: C
Which two features distinguish Delta Lake from Azure Data Lake Storage? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Answer: BD
The correct answers are: B. schema enforcement D. transactional consistency Explanation: Delta Lake is an open-source storage layer that brings advanced features to big data workloads. It distinguishes itself from Azure Data Lake Storage with the following: Schema Enforcement (B) Delta Lake enforces schemas to ensure that data written to the table adheres to the defined schema, preventing corrupt or invalid data from being added. Transactional Consistency (D) Delta Lake provides ACID (Atomicity, Consistency, Isolation, Durability) transactions, enabling reliable updates and deletes while maintaining consistency in big data workloads.
Source: Adapted from community discussion — Bin_Hashim
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-900 practice, question 81. 291 questions available.
Version 1.0.0. How we source questions