You deploy several Azure SQL Database instances.
You plan to configure the Diagnostics settings on the databases as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

In the exhibit, the SQLInsights data is configured to be stored in Azure Log Analytics for 90 days. However, the question is asking for the "maximum" amount of time that the data can be stored which is 730 days.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure blueprint named BP1.
The properties of BP1 are shown in the Properties exhibit. (Click the tab.)

The basic configuration of the blueprint is shown in the Basics exhibit. (Click the Basics tab.)

The artifacts attached to BP1 are shown in the Artifacts exhibit. (Click the Artifacts tab.)

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Box 1: No
BP1 is in draft mode.
When a blueprint is first created, it's considered to be in Draft mode. When it's ready to be assigned, it needs to be Published.
Box 2: No
The BP1 artifacts include one Policy assignment and a Resource group, but no Role assignments.
Note: Blueprints are a declarative way to orchestrate the deployment of various resource templates and other artifacts such as:
Role Assignments
Policy Assignments
Azure Resource Manager templates (ARM templates)
Resource Groups
Box 3: Yes
Yes, the BP1 artifacts include a Resource group.
Reference:
https://docs.microsoft.com/en-us/azure/governance/blueprints/overview

Comment: *

Name: *

Email: *

Verification: *

You need to recommend a solution for the collection of security logs the middle tier of the payment processing system.
What should you include in the recommendation?

• A.Azure Notification Hubs
• B.the Azure Diagnostics agent
• C.Azure Event Hubs
• D.the Azure Log Analytics agent

Comment: *

Name: *

Email: *

Verification: *

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2.
You plan to migrate DB1 and DB2 to Azure.
You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:
* Support server-side transactions across DB1 and DB2.
* Minimize administrative effort to update the solution.
What should you recommend?

• A.two SQL Server databases on an Azure virtual machine
• B.two Azure SQL databases on different Azure SQL Database servers
• C.two Azure SQL databases in an elastic pool
• D.two Azure SQL databases on the same Azure SQL Database managed instance

Comment: *

Name: *

Email: *

Verification: *

You are designing a virtual machine that will run Microsoft SQL Server and will contain two data disks. The first data disk will store log files, and the second data disk will store dat a. Both disks are P40 managed disks.
You need to recommend a caching policy for each disk. The policy must provide the best overall performance for the virtual machine.
Which caching policy should you recommend for each disk? To answer, drag the appropriate policies to the correct disks. Each policy may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

1 - None
2 - ReadOnly
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance

Comment: *

Name: *

Email: *

Verification: *