DP-200 무료 덤프문제 온라인 액세스

Use the following login credentials as needed:
Azure Username: xxxxx
Azure Password: xxxxx
The following information is for technical support purposes only:
Lab Instance: 10543936

Your company's compliance policy states that administrators must be able to review a list of the database object changes that occurred in an Azure SQL database named db2 during the last 100 days.
You need to modify your Azure environment to meet the compliance policy requirements.
To complete this task, sign in to the Azure portal.

정답:

Set up auditing for your database
The following section describes the configuration of auditing using the Azure portal.
1. Go to the Azure portal.
2. Navigate to Auditing under the Security heading in your SQL database db2/server pane

3. If you prefer to enable auditing on the database level, switch Auditing to ON.

Note: By default the audit database data retention period is set to 100 days.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval. The output will be sent to a Delta Lake table.
Which output mode should you use?

• A.append
• B.update
• C.complete

You need to configure a disaster recovery solution for SALESDB to meet the technical requirements.
What should you configure in the backup policy?

• A.a point-in-time restore
• B.geo-replication
• C.weekly long-term retention backups that are retained for three weeks
• D.failover groups

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.

정답:

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
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automatic-tuning-enable

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?

• A.Enable geo-redundancy for the Azure Cosmos DB account.
• B.Create a managed identity.
• C.Create a new Azure Cosmos DB account.
• D.Disable soft delete on vault 1.