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 single database

Answer

Azure Cosmos DB

Answer

Azure SQL Data Warehouse

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

Session

Answer

Hopping

Answer

Sliding

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 SQL Data Warehouse

Answer

Azure Cosmos DB

Answer

Azure SQL Database

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 SQL database

Answer

Azure Media Services

Answer

Azure Table storage

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

Bounded Staleness

Answer

Session

Answer

Consistent Prefix

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.
What should the recommendation contain?

Accepted Answer

Add a virtual network to the Azure SQL server that hosts the database.

Answer

Add an application gateway to the virtual network that contains the Azure virtual machine.

Answer

Deploy an On-premises data gateway.

Answer

Add a virtual network gateway to the virtual network that contains the Azure virtual machine.

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.
What ought to you suggest?

Accepted Answer

Failover-group

Answer

Active geo-replication

Answer

Azure SQL Data Sync

Answer

SQL Replication