You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?

• A.automatic tuning
• B.Azure Advisor
• C.Azure Monitor
• D.Query Performance Insight

Comment: *

Name: *

Email: *

Verification: *

Your on-premises network contains a file server named Server1 that stores 500 GB of data.
You need to use Azure Data Factory to copy the data from Server1 to Azure Storage.
You add a new data factory.
What should you do next? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Install a self-hosted integration runtime
The Integration Runtime is a customer-managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments.
Box 2: Create a pipeline
With ADF, existing data processing services can be composed into data pipelines that are highly available and managed in the cloud. These data pipelines can be scheduled to ingest, prepare, transform, analyze, and publish data, and ADF manages and orchestrates the complex data and processing dependencies References:
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-sql-azure-adf

Comment: *

Name: *

Email: *

Verification: *

You need to recommend a notification solution for the IT Support distribution group.
What should you include in the recommendation?

• A.Azure Network Watcher
• B.an action group
• C.a SendGrid account with advanced reporting
• D.Azure AD Connect Health

Comment: *

Name: *

Email: *

Verification: *

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

You create an Azure SQL database named DB1 that is hosted in the East US region.
To DB1, you add a diagnostic setting named Settings1. Settings1 archives SQLInsights to storage1 and sends SQLInsights to Workspace1.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selections is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have an Azure subscription that contains a custom application named Application1. Application1 was developed by an external company named Fabrikam, Ltd. Developers at Fabrikam were assigned role-based access control (RBAC) permissions to the Application1 components. All users are licensed for the Microsoft
365 E5 plan.
You need to recommend a solution to verify whether the Fabrikam developers still require permissions to Application1. The solution must meet the following requirements:
* To the manager of the developers, send a monthly email message that lists the access permissions to Application1.
* If the manager does not verify an access permission, automatically revoke that permission.
* Minimize development effort.
What should you recommend?

• A.In Azure Active Directory (AD) Privileged Identity Management, create a custom role assignment for the Application1 resources.
• B.Create an Azure Automation runbook that runs the Get-AzureADUserAppRoleAssignment cmdlet.
• C.In Azure Active Directory (Azure AD), create an access review of Application1.
• D.Create an Azure Automation runbook that runs the Get-AzRoleAssignment cmdlet.

Comment: *

Name: *

Email: *

Verification: *