ExamDumpster

Free DP-900 sample questions

Each free DP-900 sample question below shows the correct answer with an explanation. Together they cover data types and workloads, Azure SQL and Cosmos DB, and Power BI reports. Use them to see where you stand before you book Azure Data Fundamentals.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

**Case Study:** **Company Background:** Contoso Pharmaceuticals is a global research company that conducts large-scale clinical trials. Each trial generates massive amounts of data from various sources, including IoT sensors monitoring patient vitals, structured case report forms (CRFs) from clinics, and unstructured notes from researchers. The data volume can reach several terabytes per day during active trials. **Current Situation:** The company's on-premises infrastructure is struggling to keep up with the data ingestion and processing demands. Analysts report that it takes days to prepare data for analysis, significantly delaying insights. They need a cloud solution that can handle both real-time data streams from sensors and large batches of files uploaded daily from clinics. **Requirements:** 1. The solution must support both streaming and batch data ingestion. 2. A centralized repository is needed to store all raw data, regardless of structure, for long-term archival and future analysis. 3. A powerful analytics platform is required to process and transform the raw data into a structured format suitable for querying and reporting by data scientists and analysts. 4. The solution must be scalable and cost-effective. Which Azure architecture best meets Contoso's requirements?

Question 2Choose one

A data analyst needs to create a visualization in Power BI to show the relationship between two numerical variables: product price and units sold. The goal is to identify patterns, trends, and outliers in the data. Which type of visualization is most suitable for this purpose?

Question 3Choose one

The primary purpose of a clustered index in a relational database table is to ______.

Question 4Choose one

Which type of data processing deals with data as it is generated, typically with very low latency requirements?

Question 5Choose one

Microsoft Fabric is a unified analytics platform that combines multiple data services into a single, integrated environment. Which of the following is the foundational, tenant-wide data lake solution within Microsoft Fabric that is based on an open architecture?

Question 6Choose one

A financial services company needs to store critical transaction archives for a minimum of seven years to comply with regulatory requirements. The data will be accessed very rarely, but must be retrievable within a few hours if required by an audit. Which Azure Blob Storage access tier offers the lowest storage cost and is most appropriate for this scenario?

Question 7Choose one

A database object that provides a virtual table based on the result-set of a SQL statement is known as what?

Question 8Choose one

True or False: Azure Synapse Analytics is a service that is exclusively used for relational data warehousing and does not support big data analytics or data lake exploration.

Question 9Choose 2

Which of the following are characteristics of unstructured data? (Select TWO)

Question 10Choose one

A developer needs to choose an API for Azure Cosmos DB to migrate an existing application that uses a MongoDB database. To minimize code changes, which Cosmos DB API should be selected?

10 more free samples are waiting

Create a free account to unlock the whole DP-900 sample bank, or get full access to all 252 practice questions in the simulator.

Create account