Free Data Engineering on Microsoft Azure (DP-203) MCQ Questions and Answers — 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?
- Azure SQL Database single database
- Azure SQL Database Managed Instance (Correct answer)
- Azure Cosmos DB
- Azure SQL Data Warehouse
Correct answer: Azure SQL Database Managed Instance
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.
<br>
Which windowing feature ought you to pick?
- Tumbling (Correct answer)
- Session
- Hopping
- Sliding
Correct answer: Tumbling
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?
- Azure SQL Data Warehouse
- Azure Cosmos DB
- Azure Data Lake Storage Gen2 (Correct answer)
- Azure SQL Database
Correct answer: Azure Data Lake Storage Gen2
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?
- Azure SQL database
- Azure Blob storage (Correct answer)
- Azure Media Services
- Azure Table storage
Correct answer: Azure Blob storage
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. <br>
<br>
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. <br>
<br>
Which consistency setting ought to be applied to the Health Interface?
- Bounded Staleness
- Session
- Strong (Correct answer)
- Consistent Prefix
Correct answer: Strong
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.
Question 6: You are creating an application that will use a virtual machine from Azure. An Azure SQL database will be accessed by the virtual machine. There won't be any Internet access to the database. You must suggest a way to grant the necessary degree of database access. <br>
What should the recommendation contain?
- Add a virtual network to the Azure SQL server that hosts the database. (Correct answer)
- Add an application gateway to the virtual network that contains the Azure virtual machine.
- Deploy an On-premises data gateway.
- Add a virtual network gateway to the virtual network that contains the Azure virtual machine.
Correct answer: Add a virtual network to the Azure SQL server that hosts the database.
To allow an Azure virtual machine to access an Azure SQL database without exposing the database to the internet, you should add a virtual network to the Azure SQL server that hosts the database. This involves configuring a Virtual Network (VNet) service endpoint or a Private Endpoint for the Azure SQL server. By doing so, traffic between the VM's subnet and the SQL server remains within the Azure backbone network, ensuring secure and private access without traversing the public internet.
Question 7: A corporation is using Azure SQL Database Managed Instance to create a mission-critical line of business app. A disaster recovery plan needs to be created for the solution. When the Azure SQL Database service in the primary region is completely or partially lost, you must make sure the database automatically recovers. <br>
What ought to you suggest?
- Active geo-replication
- Azure SQL Data Sync
- Failover-group (Correct answer)
- SQL Replication
Correct answer: Failover-group
For a mission-critical line of business app using Azure SQL Database Managed Instance, a failover group (Auto-failover group) is the recommended solution for automatic disaster recovery. Failover groups enable automatic failover of a group of databases to a secondary region in the event of a primary region outage. This ensures business continuity and automatic recovery, meeting the requirement for the database to automatically recover when the primary region experiences a service loss.
