FREE Data Engineering on Microsoft Azure (DP-203) MCQ Questions and Answers
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?
By utilizing Azure SQL Database Managed Instance, you can leverage the benefits of a managed service while migrating your on-premises Microsoft SQL Server databases to the Azure cloud. It provides a seamless transition with minimal impact on your existing applications and allows you to take advantage of Azure's scalability, availability, and security features.
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.
What ought to you suggest?
To ensure automatic recovery in the event of a full or partial loss of the Azure SQL Database service in the primary region, the recommended solution is to implement a failover group for the Azure SQL Database Managed Instance.
Failover groups provide a built-in high availability and disaster recovery mechanism for Azure SQL Database Managed Instance. They allow you to configure a secondary region where a synchronized copy of the database is maintained.
The storage for the visual monitoring system needs to be planned. Which storage option ought to you suggest?
For the storage of a visual monitoring system, Azure Blob storage is a recommended solution.
Azure Blob Storage is a scalable and cost-effective storage service that is ideal for storing large amounts of unstructured data, such as images, videos, and other media files. It provides several features that make it suitable for a visual monitoring system.
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?
For the Health Interface application, considering its critical nature and the requirement for a new solution, a strong level of security should be implemented to ensure data confidentiality, integrity, and availability.
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.
What should the recommendation contain?
By including the recommendation to add a virtual network to the Azure SQL server, you establish a private network environment and limit access to the database only from the virtual machine within the same network. This configuration provides a secure and controlled access model, ensuring that the database is not directly accessible from the internet while allowing the necessary connectivity between the virtual machine and the database.
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?
For counting the number of weather reports received per time zone every minute in a real-time processing solution using Stream Analytics, the appropriate windowing function to choose would be the "Tumbling" windowing function.
Tumbling windows are fixed-size, non-overlapping windows that divide the input stream into distinct time intervals. In this case, you want to count the number of weather reports per time zone every minute. By using a Tumbling window of one minute, you ensure that the stream is partitioned into non-overlapping intervals of one minute each.
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?
For an analytical data store in Azure that enables business analysts and data scientists to execute ad hoc queries quickly, Azure Data Lake Storage Gen2 is a recommended service.
Azure Data Lake Storage Gen2 combines the scalability and cost-effectiveness of Azure Blob Storage with the rich analytics capabilities of Azure Data Lake. It offers several features that make it well-suited for analytical workloads.