You are evaluating the role assignments.
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: Yes
DBAGroup1 is member of the Contributor role.
The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.
Box 2: No
Box 3: Yes
DBAGroup2 is member of the SQL DB Contributor role.
The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.
Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database named DB 1 in the General Purpose service tier.
You need to monitor DB 1 by using SQL Insights.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1 = Azure Monitor Agent
Box 2 = An Azure SQL database
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

Comment: *

Name: *

Email: *

Verification: *

You have a database named db1.
The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

Correct Answer:

1 - Shrink db1.
2 - Remove db1 from the availability group.
3 - Back up the transaction log file.
4 - Add db1 back to the availability group.

Comment: *

Name: *

Email: *

Verification: *

Which windowing function should you use to perform the streaming aggregation of the sales data?

• A.Sliding
• B.Hopping
• C.Session
• D.Tumbling

Correct Answer: D

Scenario: The sales data, including the documents in JSON format, must be gathered as it arrives and analyzed online by using Azure Stream Analytics. The analytics process will perform aggregations that must be done continuously, without gaps, and without overlapping.
Tumbling window functions are used to segment a data stream into distinct time segments and perform a function against them, such as the example below. The key differentiators of a Tumbling window are that they repeat, do not overlap, and an event cannot belong to more than one tumbling window.

Reference:
https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/stream-analytics/stream-analytics-window- functions.md

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and App2.
You need to limit the number of IOPs that App2 queries generate on SQL1.
Which two actions should you perform on SQL1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Enable query optimizer fixes.
• B.Enable Resource Governor.
• C.Enable parameter sniffing.
• D.Create a workload group.
• E.Configure In-memory OLTP.
• F.Run the Database Engine Tuning Advisor.
• G.Reduce the Max Degree of Parallelism value.

Comment: *

Name: *

Email: *

Verification: *