Free DP-900 Practice Test – 20 Questions with Explanations

A retail company stores support tickets as JSON documents from multiple systems. Some tickets include nested device details and optional warranty fields, while others include only basic customer information.
Which characteristics indicate that the data is semi-structured? (Select TWO.)

A company is building a cloud-native order entry system on Azure. The database must support common relational objects such as tables, views, stored procedures, and keys without the team managing operating systems or database engine installation.
Which Azure service is the best fit?

A logistics company wants to analyze events in motion so it can detect delays, aggregate telemetry in near real time, and trigger downstream actions quickly. The team is choosing Microsoft services used for real-time stream processing rather than raw storage or traditional relational workloads.
Which TWO services best fit this requirement? (Select TWO.)

A finance team wants to distribute a curated set of analytics content to regional managers. The managers should receive a packaged experience rather than opening each item separately.

Which Power BI item should the team publish to meet the requirement?

A sales application stores customers and orders in separate relational tables. The design team wants each order to point to the customer who placed it while still keeping a separate unique identifier for the order itself.

Which column is acting as the foreign key in this design?

A retail company exports daily sales data for finance users and also keeps a copy optimized for large-scale analytics. The team wants one common text-based file format for simple tabular exchange and one common analytics-oriented format for efficient column reads.
Which two file formats best meet the requirement? (Select TWO.)

A delivery company receives device events throughout the day and wants a curated analytics dataset for dashboards. The team needs a high-level flow from raw ingestion through final reporting.
Steps
1. Query the prepared data and build dashboards.
2. Ingest raw event data from the source.
3. Validate and transform the incoming data.
4. Load the prepared data into an analytical store.
What is the correct order?

A gaming company stores player session data for users in multiple regions. The application must respond with very low latency during sudden traffic spikes and continue scaling horizontally as usage grows worldwide.
Which Azure service is the best fit?

A human resources system uses several common objects inside an Azure SQL Database. The support team is reviewing object names and descriptions so they can correctly identify which object is being referenced in documentation.

Which row identifies a view object?

An online retailer collects clickstream events continuously and receives product reference files once each night. The analytics team wants to choose ingestion and processing patterns that match both the source behavior and the reporting needs.
Which TWO considerations should guide the design? (Select TWO.)

A company’s production SQL database has become slower as transaction volume has grown, and leadership wants assurance that the database can be recovered after accidental data loss. The team is deciding which tasks should be handled by the database administrator rather than by analytics or pipeline teams.
Which TWO activities are core database administrator responsibilities? (Select TWO.)

A company wants to replace an on-premises network share with a fully managed cloud service. Windows and Linux clients must be able to mount the same style of service by using SMB or NFS, depending on workload needs.
Which Azure service should the company choose?

A report author is building a sales semantic model in Power BI for analysis by date, product, and customer. The author wants the model to stay fundamentals-aligned, support clean filtering behavior, and calculate totals correctly as users slice the report.
Which TWO design choices best align with strong Power BI data model fundamentals? (Select TWO.)

A team is redesigning an order-entry database that currently repeats customer details in every order row. They want to normalize the schema so customer data is stored once and still linked correctly to each order.
Steps
1. Replace repeated customer text in Orders with CustomerID
2. Identify customer attributes repeated in the Orders table
3. Create a Customers table with CustomerID as the primary key
4. Move the customer attributes into the Customers table
What is the correct order?

A data platform team is comparing Microsoft cloud services for a new analytics solution. They want to distinguish core service characteristics from common misconceptions before choosing the right platform components.
Which TWO statements are correct? (Select TWO.)

A company is moving an existing SQL Server-based application to Azure with as few application changes as possible. The team wants a managed platform service, but they still need strong SQL Server compatibility at the instance level rather than the simpler single-database PaaS model.
Which Azure service is the best fit?

A learner is reviewing Azure Table storage terms and capabilities. Some pairings are correct, while others intentionally mix Table storage with relational or file-storage ideas.
Which THREE pairings are mismatched? (Select THREE.)

A retail company is reviewing several workload patterns before designing a reporting platform. The team wants the one that best matches historical analysis, aggregation, and read-heavy access.

Which workload most clearly matches an analytical workload?

A reporting team is reviewing several SQL clause descriptions before building a sales query. Some pairings are accurate, while others confuse filtering, sorting, grouping, and table combination.
Which THREE pairings are mismatched? (Select THREE.)

A BI team is reviewing three Power BI reports that use different connection approaches. They need to identify which description correctly distinguishes Import, DirectQuery, and live connection at a high level without mixing the modes together.

Which row most accurately describes the three connectivity modes at a high level?