10 Sample Questions for Microsoft Azure Data Fundamentals DP-900 certification exam

Introduction

Hello Readers! Have you completed the Microsoft Azure Data fundamentals DP-900 course? It is time to hone your exam skills by reviewing some sample questions that may appear for the certification exam.

After reading this article, you can answer more and more questions, review the TestPrep material available and appear for the exam, and grab your certificate quickly. A comprehensive study guide to help you with your Microsoft Azure Data Fundamentals DP-900 certification preparation is available to get you started.

After learning the course material, answer the below sample questions, and test your knowledge. The correct answers are available at the end of this article.

Here goes the Quiz:

1. What of the following is an example of a streaming dataset.
   a. Data from sensors and devices
   b. List of employees working for a company
   c. Sales data for the past month
2. Which of the following tools is a visualization and reporting tool?
   a. SQL Server Management Studio
   b. Power BI
   c. SQL
3. Which one of the following statements is a characteristic of a relational database?
   a. All data must be stored as character strings
   b. Different rows in the same table can contain different columns
4. Which of the following statements is true about SQL Server running on a virtual machine?
   a. You must install and maintain the software for the database management system yourself, but backups are automated
   b. Software installation and maintenance are automated, but you must do your own backups
   c. You are responsible for all software installation and maintenance, and performing backups
5. When should you use a block blob, and when should you use a page blob?
   a. Use a block blob for unstructured data that requires random access to perform reads and writes. Use a page blob for discrete objects that rarely change
   b. Use a block blob for active data stored using the Hot data access tier, and a page blob for data stored using the Cool or Archive data access tiers.
   c. Use a page block for blobs that require random read and write access. Use a block blob for discrete objects that change infrequently.
6. What is a security principal?
   a. A named collection of permissions that can be granted to a service, such as the ability to use the service to read, write, and delete data. In Azure, examples include Owner and Contributor
   b. An object that represents a user, group, service, or managed identity that is requesting access to Azure resources.
   c. A set of resources managed by a service to which you can grant access.
7. What is the primary difference between a data lake and a data warehouse?
   a. A data lake contains structured information, but a data warehouse holds raw business data
   b. A data lake holds raw data, but a data warehouse holds structured information
   c. Data stored in a data lake is dynamic, but the information stored in a data warehouse is static
8. When might you use PolyBase?
   a. To ingest streaming data using Azure Databricks
   b. To query data from external data sources from Azure Synapse Analytics
   c. To orchestrate activities in Azure Data Factory
9. Which of the components of Azure Synapse Analytics allows you to train AI models using AzureML?
   a. Synapse Pipelines
   b. Synapse Spark
   c. Synapse Studio
10. What is the common flow of activity in Power BI?
    a. Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards in the service and Power BI mobile.
    b. Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service
    c. Bring data into Power BI mobile, create a report, then share it to Power BI Desktop
    d. Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop

Check the right answers here:

1. c.
   Explanation: Sensor and device feeds are examples of streaming datasets as they are published continuously.
2. b.
   Explanation: Power BI is a standard tool for creating rich graphical dashboards and reports
3. c.
   Explanation: Each row in a table contains the data for a single entity in that table
4. c.
   Explanation: With SQL Server running on a virtual machine, you’re responsible for patching and backing up
5. c.
   Explanation: Use a page block for blobs that require random read and write access. Use a block blob for discrete objects that change infrequently
6. a.
   Explanation: Azure authentication uses security principles to help determine whether a request to access service should be granted
7. b.
   Explanation: A data warehousing solution converts the raw data in a data lake into meaningful business information in a data warehouse
8. b.
   Explanation: To query data from external data sources from Azure Synapse Analytics
9. b.
   Explanation: You would use a notebook to ingest and shape data, and then use SparkML and AzureML to train models with it
10. a.
    Explanation: The Power BI service lets you view and interact with reports and dashboards but doesn’t let you shape data

Did you score above 70%? If not then go through the study material again and test your knowledge with TestPrep material.

Disclaimer: These questions are NOT appearing in the certification exam. I personally or CloudThat do not have any official tie-up with Microsoft regarding the certification or the kind of questions asked. These are my best guesses for the kind of questions to expect with Microsoft in general and with the examination.

Enroll for the Microsoft Azure Data Fundamentals DP-900 course and grab your Microsoft Badge soon.

Check out my previous blog “8 Easy Steps to prepare for Microsoft Azure Data Fundamentals DP-900 Certification Exam”

Feel free to drop any questions in the comment box, I would love to address them.

I hope you enjoyed the article. Best of luck!