[UPDATED] Microsoft DP-900 Certification: Syllabus, Questions and Exam Details

MICROSOFT DP-900 CERTIFICATION: SYLLABUS, QUESTIONS AND EXAM DETAILS Microsoft DP-900 Exam

EDUSUM.COM Get complete detail on DP-900 exam guide to crack Microsoft Azure Data Fundamentals. You can collect all information on DP-900 tutorial, practice test, books, study material, exam questions, and syllabus. Firm your knowledge on Microsoft Azure Data Fundamentals and get ready to crack DP900 certification. Explore all information on DP-900 exam with number of questions, passing percentage and time duration to complete test.

WWW.EDUSUM.COM

PDF

Introduction to Microsoft Certified Azure Data Fundamentals Exam The Microsoft DP-900 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Azure Data Fundamentals certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. This study guide for the Microsoft Azure Data Fundamentals will help guide you through the study process for your certification.

DP-900 Microsoft Azure Data Fundamentals Exam Summary ● Exam Name: Microsoft Azure Data Fundamentals ● Exam Code: DP-900 ● Exam Price: $99 (USD)

DP-900: Microsoft Azure Data Fundamentals

1

WWW.EDUSUM.COM

● ● ● ● ● ● ●

PDF

Duration: 60 mins Number of Questions: 40-60 Passing Score: 700 / 1000 Books / Training: DP-900T00-A: Microsoft Azure Data Fundamentals Schedule Exam: Pearson VUE Sample Questions: Microsoft Azure Data Fundamentals Sample Questions Recommended Practice: Microsoft DP-900 Certification Practice Exam

Exam Syllabus: DP-900 Microsoft Certified Azure Data Fundamentals Topic

Details

Describe core data concepts (25-30%) - Describe features of structured data Describe ways to represent - Describe features of semi-structured data - Describe features of unstructured data Identify options for data - Describe common formats for data files storage - Describe types of databases Describe common data - Describe features of transactional workloads workloads - Describe features of analytical workloads Identify roles and - Describe responsibilities for database administrators responsibilities for data - Describe responsibilities for data engineers workloads - Describe responsibilities for data analysts

Identify considerations for relational data on Azure (20-25%)

Describe relational concepts

Describe relational Azure data services

- Identify features of relational data - Describe normalization and why it is used - Identify common structured query language (SQL) statements - Identify common database objects - Describe the Azure SQL family of products including Azure SQL Database, Azure SQL - Managed Instance, and SQL Server on Azure Virtual Machines - Identify Azure database services for open-source database systems

DP-900: Microsoft Azure Data Fundamentals

2

WWW.EDUSUM.COM

Topic

PDF

Details

Describe considerations for working with non-relational data on Azure (1520%) Describe capabilities of Azure storage

- Describe Azure Blob storage - Describe Azure File storage - Describe Azure Table storage

Describe capabilities and - Identify use cases for Azure Cosmos DB features of Azure Cosmos - Describe Azure Cosmos DB APIs DB

Describe an analytics workload on Azure (25-30%) - Describe considerations for data ingestion and processing Describe common - Describe options for analytical data stores elements of large-scale - Describe Azure services for data warehousing, including analytics Azure Synapse Analytics, Azure Databricks, Azure HDInsight, and Azure Data Factory - Describe the difference between batch and streaming data Describe consideration for - Describe technologies for real-time analytics including real-time data analytics Azure Stream Analytics, Azure Synapse Data Explorer, and Spark structured streaming - Identify capabilities of Power BI Describe data visualization - Describe features of data models in Power BI in Microsoft Power BI - Identify appropriate visualizations for data

Microsoft DP-900 Certification Sample Questions and Answers To make you familiar with Microsoft Azure Data Fundamentals (DP-900) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Azure Data Fundamentals DP-900 Certification to test your understanding of the Microsoft DP-900 process with a real Microsoft certification exam environment.

DP-900: Microsoft Azure Data Fundamentals

3

WWW.EDUSUM.COM

PDF

DP-900 Microsoft Azure Data Fundamentals Sample Questions:01. You design a data ingestion and transformation solution by using Azure Data Factory service. You need to get data from an Azure SQL database. Which two resources should you use?

Each correct answer presents part of the solution. a) Linked service b) Copy data activity c) Dataset d) Azure Databricks notebook 02. Which two Azure data services support Apache Spark clusters?

Each correct answer presents a complete solution. a) Azure Synapse Analytics b) Azure Cosmos DB c) Azure Databricks d) Azure Data Factory 03. Which Azure Data Factory component should you use to represent data that you want to ingest for processing? a) Linked services b) Datasets c) Pipelines d) Notebooks 04. For which reason should you deploy a data warehouse? a) Record daily sales transactions. b) Perform sales trend analyses c) Print sales orders. d) Search status of sales orders.

05. You need to use JavaScript Object Notation (JSON) files to provision Azure storage. What should you use? a) Azure portal b) Azure command-line interface (CLI) c) Azure PowerShell d) Azure Resource Manager (ARM) templates

DP-900: Microsoft Azure Data Fundamentals

4

WWW.EDUSUM.COM

PDF

06. Select the answer that correctly completes the sentence. You need to process data that is generated continuously and near real-time responses are required.

You should use _________. a) batch processing b) scheduled data processing c) buffering and processing d) streaming data processing 07. What are three characteristics of non-relational data?

Each correct answer presents a complete solution. a) Forced schema on data structures b) Flexible storage of ingested data c) Entities are self-describing d) Entities may have different fields e) Each row has the exact same columns 08. You need to create a graph database. Which Azure data service should you use? a) Azure Table b) Azure Cosmos DB c) Azure Blob d) Azure File 09. Select the answer that correctly completes the sentence. Objects in which things about data should be captured and stored are called: ____________. a) tables b) entities c) rows d) columns 10. You are designing reports by using Microsoft Power BI. For which three scenarios can you create Power BI reports as paginated reports?

Each correct answer presents a complete solution. a) a report that has a table visual with an ability to print all the data in the table b) a report that has a table visual with an ability to see all the data in the table c) a report with a repeatable header and footer d) a report that is formatted to fit well on a printed page e) a report that uses only Power BI visuals

DP-900: Microsoft Azure Data Fundamentals

5

WWW.EDUSUM.COM

PDF

Answers:Answer 01:- a, b Answer 02:- a, c Answer 03:- b Answer 04:- a Answer 05:- d Answer 06:- d Answer 07:- a, b, c Answer 08:- b Answer 09:- b Answer 10:- a, c, d

DP-900: Microsoft Azure Data Fundamentals

6