Microsoft DP-200 Exam Practice Test Instant Access

Question 1

You have an Azure Storage account named storage1 that is configured as shown in the following exhibit.

You need to ensure that all calls to an Azure Storage REST API operation on storage1 are made over HTTPS.

What should you do?

ASet Secure transfer required to Enabled.

BSet Allow Blob public access to Disabled.

CFor the Blob service, create a shared access signature (SAS) that allows HTTPS only.

DSet Minimum TLS version to Version 1.2.

Answer : A

You can configure your storage account to accept requests from secure connections only by setting the Secure transfer required property for the storage account. When you require secure transfer, any requests originating from an insecure connection are rejected. Microsoft recommends that you always require secure transfer for all of your storage accounts.

When secure transfer is required, a call to an Azure Storage REST API operation must be made over HTTPS. Any request made over HTTP is rejected.

https://docs.microsoft.com/en-us/azure/storage/common/storage-require-secure-transfer

Question 2

You have a data warehouse in Azure Synapse Analytics.

You need to ensure c rest.

What should you enable?

ATransparent Data Encryption (TDE)

BSecure transfer required

CAlways Encrypted for all columns

DAdvanced Data Security for this database

Answer : A

Question 3

You have an Azure subscription that contains the resources shown in the following table.

All the resources have the default encryption settings.

AEnable Azure Storage encryption for storageaccount1.

BEnable Transparent Data Encryption (TDE) for synapsedb1.

CEnable encryption at rest for cosmosdb1.

DEnable Azure Storage encryption for storageaccount2.

Answer : D

Question 4

You have an Azure subscription that contains the following resources:

* An Azure Cosmos DB SQL API account

* An Azure key vault named vault1 that contains an encryption key named key1.

You need to ensure that all the content stored in Azure Cosmos DB is encrypted by using key1. What should you do first?

ADisable soft delete on vault 1.

BEnable geo-redundancy for the Azure Cosmos DB account.

CCreate a new Azure Cosmos DB account.

DCreate a managed identity.

Answer : D

Question 5

You are monitoring an Azure Stream Analytics job.

The Backlogged Input Events count has been 20 for the last hour.

You need to reduce the Backlogged Input Events count.

What should you do?

AAdd an Azure Storage account to the job

BIncrease the streaming units for the job

CStop the job

DDrop late arriving events from the job

Answer : B

General symptoms of the job hitting system resource limits include:

If the backlog event metric keeps increasing, it's an indicator that the system resource is constrained (either because of output sink throttling, or high CPU).

Note: Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn't able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job: adjust Streaming Units.

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-scale-jobs

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring

Question 6

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10277521

You plan to create large data sets on db2.

You need to ensure that missing indexes are created automatically by Azure in db2. The solution must apply ONLY to db2.

To complete this task, sign in to the Azure portal.

AExplanation:
1. To enable automatic tuning on Azure SQL Database logical server, navigate to the server in Azure portal and then select Automatic tuning in the menu.

2. Select database db2
3. Click the Apply button

Answer : A

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable

Question 7

Use the following login credentials as needed:

Azure Username: xxxxx

Azure Password: xxxxx

The following information is for technical support purposes only:

Lab Instance: 10277521

You need to generate an email notification to admin@contoso.com if the available storage in an Azure Cosmos DB database named cosmos10277521 is less than 100,000,000 bytes.

To complete this task, sign in to the Azure portal.

AExplanation:
1. In the Azure portal, click All services, click Azure Cosmos DB, and then click the cosmos10277521 Azure Cosmos DB account.
2. In the resource menu, click Alert Rules to open the Alert rules page.

3. In the Alert rules page, click Add alert.

4. In the Add an alert rule page, specify:
Metric: Available storage
Condition: Less than
Threshold: 100,000,000 bytes

Answer : A

https://docs.microsoft.com/en-us/azure/cosmos-db/monitor-accounts

Microsoft DP-200 Implementing an Azure Data Solution Exam Practice Test