Microsoft Azure Data Fundamentals (DP-900) Certification Sample Questions

Azure Data Fundamentals Dumps, DP-900 Dumps, DP-900 PDF, Azure Data Fundamentals VCE, Microsoft DP-900 VCE, Microsoft Azure Data Fundamentals PDFThe purpose of this Sample Question Set is to provide you with information about the Microsoft Azure Data Fundamentals exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-900 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Azure Data Fundamentals Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual Microsoft Certified - Azure Data Fundamentals certification exam.

These sample questions are simple and basic questions that represent likeness to the real Microsoft DP-900 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium Microsoft Azure Data Fundamentals Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

Microsoft DP-900 Sample Questions:

01. Which replication option in Azure Blob Storage provides the highest durability by replicating data to a second region?
a) Locally Redundant Storage (LRS)
b) Zone-Redundant Storage (ZRS)
c) Geo-Zone-Redundant Storage (GZRS)
d) Premium Storage
 
02. Which three statements accurately describe the properties of a table in a relational database?
Each correct answer presents a complete solution. Select all answers that apply.
a) A table can have a primary key build on multiple columns.
b) A table can have only one foreign key.
c) All columns must contain values.
d) Each row in a table has the same number of columns.
e) Each column must have a datatype.
 
03. In which scenario would batch processing be more appropriate than streaming data processing?
a) Monitoring sensor data in a nuclear power plant
b) Processing end-of-day financial reports
c) Live social media sentiment analysis
d) Real-time fraud detection in banking transactions
 
04. Which three services can be used to ingest data for stream processing?
Each correct answer presents a complete solution. Select all answers that apply.
a) Azure Functions
b) Azure Event Hubs
c) Azure SQL Database
d) Azure IoT Hub
e) Azure Data Lake Storage
 
05. What feature does Azure Cosmos DB provide to automatically distribute data globally?
a) Global Distributor
b) Geo-Replication
c) Multi-Region Writes
d) Global Partitioning
 
06. Which service allows you to perform on-demand analysis of large volumes of data from text logs, websites and IoT devices by using a common querying language for all the data sources?
a) Azure Data Explorer
b) Azure Data Lake Storage Gen2
c) Azure Stream Analytics
d) Azure Cosmos DB
 
07. You need to share a report that you created in Microsoft Power BI Desktop with other users. What should you do first?
a) Create a workspace.
b) Publish the report to the Power BI service.
c) Open the report in a web browser.
d) Create an app.
 
08. Which two types of applications are used in transactional systems?
Each correct answer presents a complete solution. Select all answers that apply.
a) reports presenting OLAP measures
b) reports presenting business metrics
c) line-of-business (LOB) applications
d) live applications
 
09. For an application that requires a single database in Azure SQL Database that scales automatically and bills for the amount of compute per second, , you would likely choose:
a) Azure SQL Database with serverless compute tier
b) Azure Cosmos DB with provisioned throughput
c) SQL Server on Azure Virtual Machines with Premium SSD
d) Azure SQL Managed Instance
 
10. When using Apache Spark for processing data as it is ingested, which feature would you likely be utilizing?
a) Spark SQL
b) Spark Batch Processing
c) Spark Machine Learning
d) Spark Structured Streaming

Answers:

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

Note: For any error in Microsoft Certified - Azure Data Fundamentals (DP-900) certification exam sample questions, please update us by writing an email on feedback@edusum.com.

Rating: 4.7 / 5 (621 votes)