Question 1

A large e-commerce company wants to decouple their order processing system from their inventory system. Which Azure service is BEST suited for this use case to ensure reliable message delivery between the two systems?

Options :

A : Azure Blob Storage

B : Azure Event Grid

C : Azure Service Bus

D : Azure SignalR Service

Answer: C

Question 2

You have an Azure Data Lake Storage account that contains 1,000 10-MB CSV files and an Azure Synapse Analytics dedicated SQL pool named sql1. You need to load the files to sql1. The solution must meet the following requirements:

Maximize data load performance.

Eliminate the need to define external tables before the data loads.

What should you use?

Options :

A : the copy statement

B : PolyBase

C : BCP

D : the sqlBulkcopy object

Answer: B

Question 3

You need to recommend how to setup the data store for hosting the SQL database in Azure. Which of the following would you recommend?

Options :

A :

An Azure SQL database elastic pool

B : A Virtual machine running a SQL server

C : A fixed-size DTU based Azure SQL database

D : A vCore-based Azure SQL Database

Answer: D

Question 4

You have an on-premises Microsoft SQL Server 2016 database named DB1. You have an Azure subscription. You need to migrate DB1 to an Azure SQL database by using the Azure SQL Migration extension for Azure Data Studio. What should you do first?

Options :

A : Configure a Site-to-Site (S2S) VPN connection.

B : Define the schema for the Azure SQL database.

C : Create a user-assigned managed identity.

D : Upgrade DB1.

Answer: A

Question 5

Which of the following Azure services can assist an organization in maintaining and managing compliance across their Azure resources? (Choose two.)

Options :

A : Azure Blueprints

B : Azure Monitor

C : Azure Policy

D : Azure Traffic Manager

Answer: A,C