Microsoft DP-900 Exam Questions

Exam Name: Microsoft Azure Data Fundamentals

Exam Code: DP-900

Related Certification(s): Microsoft Azure Certification

Certification Provider: Microsoft

Actual Exam Duration: 45 Minutes

Number of DP-900 Practice Questions: 306 (updated: )

Microsoft Recommended Focus Areas for the DP-900 Exam:
Topic 1: Describe core data concepts
In this topic, aspiring Microsoft data engineers explore fundamental ways to represent data, such as structured, semi-structured, and unstructured formats. Additionally, the topic explains various data storage options, emphasizing file, database, and object storage. It also details common data workloads, including transactional, analytical, and streaming workloads. Lastly, the roles and responsibilities for managing data workloads, such as administrators, engineers, and analysts, are clarified.
Topic 2: Identify considerations for relational data on Azure
This topic provides aspiring Microsoft data engineers with a clear understanding of relational data concepts, including schemas, tables, keys, and normalization. It further explores relational Azure data services such as Azure SQL Database and Azure Database for MySQL, highlighting their use cases and capabilities.
Topic 3: Describe considerations for working with non-relational data on Azure
Aspiring Microsoft data engineers gain insight into Azure’s non-relational data capabilities in this topic. It discusses Azure Storage options, including Blob Storage, Table Storage, and Queue Storage, suitable for diverse scenarios. Additionally, the features and strengths of Azure Cosmos DB, such as global distribution and multi-model support, are outlined.
Topic 4: Describe an analytics workload
This topic introduces aspiring Microsoft data engineers to the components of large-scale analytics, such as data ingestion, transformation, and querying. It also discusses real-time data analytics considerations, including low-latency processing with Azure Stream Analytics. Finally, data visualization with Microsoft Power BI, focusing on interactive dashboards and reports, is covered.
Free Microsoft DP-900 Exam Actual Questions
Note: Microsoft DP-900 Premium Questions were last updated on

Q1. You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business. You need to create a canvas app that allows team members to update the status of their tasks. What should you use?

Q2. A company uses Microsoft 365. SharePoint Online and Dynamics 365 Sales. You need to recommend tools to build a solution that meets the following requirements: * Synchronize data daily (rom an external Microsoft SQL Server instance. * Send a report automatically to specific company executives. * Ensure that opportunities over a specified amount are approved by a sales manager. Which two tools of components should you recommend? Each correct answer presents a pan of the solution NOTE: Each correct selection is worth one point.

Q3. A company is creating a canvas app to track and analyze customer visits to their retail stores. Data about customer visits is stored on-premises at each retail store location. The app must display data about customer visits when users launch the app. You need to ensure that the data is available for consumption by the app. Which tool should you use?

Q4. Which of the following is a valid electrical safety precaution when working on a computer or display with exposed, potentially energized parts?

Q5. Your company has an on premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app. You need to establish a secure connection between the database and the app. What should you use?