01. A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices. The company must be able to monitor the devices in real-time.
You need to design the solution. What should you recommend?
a) Azure Data Factory instance using Azure Portal
b) Azure Analysis Services using Microsoft Visual Studio
c) Azure Stream Analytics Edge application using Microsoft Visual Studio
d) Azure Data Factory instance using Microsoft Visual Studio
02. Reference Scenario: click here
Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?
a) Azure Data Lake Storage Gen2
b) Azure Cosmos DB
c) Azure SQL Database
d) Azure SQL Data Warehouse
A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages.
You need to recommend the redundancy type for the solution. What should you recommend?
a) Read-access geo-redundant storage
b) Locally-redundant storage
c) Geo-redundant storage
d) Zone-redundant storage
04. You are designing a real-time processing solution by using Stream Analytics. You want to count the number of weather reports that are received per time zone every minute. You need to choose the appropriate windowing function.
Which windowing function should you choose?
a) Session
b) Sliding
c) Hopping
d) Tumbling
05. You need to design the storage for the visual monitoring system. Which storage solution should you recommend?
a) Azure Blob storage
b) Azure Table storage
c) Azure SQL database
d) Azure Media Services
06. You need to design the unauthorized data usage detection system. What Azure service should you include in the design?
a) Azure Analysis Services
b) Azure SQL Data Warehouse
c) Azure Databricks
d) Azure Data Factory
07. You are designing a big data streaming solution. You need to choose the most appropriate resource for different scenarios. Which Azure resource should you choose?
To answer, drag the appropriate resource to each scenario. A resource may be used once, more than once, or not at all.
a) SQL Data Warehouse
Stream Analytics
b) SQL Data Warehouse
Databricks
c) Stream Analytics
Data Lake
d) loT Hub
Data Factory
08. You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Databricks and PolyBase in Azure Synapse Analytics.
You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the files can be queried quickly and that the data type information is retained.
What should you recommend?
a) Avro
b) CSV
c) Parquet
d) JSON
09. An in-house team is developing a new application. The design document specifies that data should be represented using nodes and relationships in graph structures. Individual data elements are relatively small.
You need to recommend an appropriate data storage solution. Which solution should you recommend?
a) Azure Storage Blobs
b) Cosmos DB
c) Azure Data Lake Store
d) HBase in HDInsight
10. You need to design the solution for the government planning department. Which services should you include in the design?
a) Azure Synapse Analytics and Elastic Queries
b) Azure SQL Database and Polybase
c) Azure Synapse Analytics and Polybase
d) Azure SQL Database and Elastic Queries
The purpose of this Sample Question Set is to provide you with information about the Microsoft Designing an Azure Data Solution exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the DP-201 certification test. To get familiar with real exam environment, we suggest you try our Sample Microsoft Designing an Azure Data Solution 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 Engineer Associate certification exam.