Free Data Engineering on Microsoft Azure (DP-203) MCQ Questions and Answers

Question 1

Multiple on-premises Microsoft SQL Server databases are managed by a corporation. By employing a Microsoft SQL Server backup procedure, you must transfer the databases to Microsoft Azure. Which data technology ought to be employed?

Accepted Answer

Azure SQL Database Managed Instance

Answer

Azure SQL Database Managed Instance is the most suitable data technology for transferring multiple on-premises Microsoft SQL Server databases using a SQL Server backup procedure. Managed Instance offers near 100% compatibility with the latest on-premises SQL Server database engine, including support for native backup/restore operations (e.g., via URL to Azure Blob Storage). This high compatibility simplifies the migration of existing SQL Server workloads, especially those relying on specific SQL Server features not available in Azure SQL Database single databases.

Question 2

Using stream analytics, you are creating a real-time processing system. The amount of weather reports that are received each time zone per minute should be counted. You must select the proper windowing function.
Which windowing feature ought you to pick?

Accepted Answer

Tumbling

Answer

To count the amount of weather reports received each time zone per minute using Stream Analytics, the Tumbling window function is the appropriate choice. Tumbling windows are fixed-size, non-overlapping, and contiguous time intervals. They are perfect for segmenting a data stream into distinct, sequential blocks of time (e.g., one-minute intervals) and performing aggregations like counts within each block, ensuring each event is counted exactly once within its specific time window.

Question 3

Which Azure service would you suggest for the analytical data storage so that the business analysts and data scientists may swiftly run ad hoc queries?

Accepted Answer

Azure Data Lake Storage Gen2

Answer

Azure Data Lake Storage Gen2 is the recommended Azure service for analytical data storage to enable business analysts and data scientists to swiftly run ad hoc queries. It is a highly scalable and cost-effective data lake solution built on Azure Blob Storage, optimized for big data analytics workloads. Its hierarchical namespace and integration with services like Azure Synapse Analytics and Azure Databricks allow users to query vast amounts of structured, semi-structured, and unstructured data directly and efficiently.

Question 4

The storage for the visual monitoring system needs to be planned. Which storage option ought to you suggest?

Accepted Answer

Azure Blob storage

Answer

Azure Blob storage is the most suitable storage option for a visual monitoring system. Visual monitoring systems typically generate large volumes of unstructured data, such as images and video files. Azure Blob storage is optimized for storing massive amounts of unstructured object data, offering high scalability, durability, and cost-effectiveness. It provides various access tiers to manage costs based on access frequency, making it ideal for storing and retrieving visual media.

Question 5

Health Interface, a crucial ADatum application, receives hospital messages about patient care and status updates. Each hospital's enterprise relationship management (ERM) system uses a VPN to send the communications in batches. The columns and formats of the data sent from each hospital may differ.

Currently, the data is sent to Health Interface via a customized C# application. The application makes use of out-of-date libraries, hence a new solution needs to be created.

Which consistency setting ought to be applied to the Health Interface?

Accepted Answer

Strong

Answer

For a 'crucial application' like Health Interface dealing with 'patient care and status updates,' 'Strong' consistency is the appropriate setting. Strong consistency guarantees that all reads return the most recently written data, ensuring that data is always up-to-date across all replicas. This is paramount for applications where data accuracy and the immediate absence of stale reads are non-negotiable requirements, even if it might slightly impact latency compared to weaker consistency models.

Microsoft Azure Security Engineer Certification Practice Test

Microsoft Azure Security Engineer Certification Practice Test

Free Data Engineering on Microsoft Azure (DP-203) MCQ Questions and Answers