Microsoft AZ-200 - Questions & Answers
Free preview · every answer includes a full explanation
Product page: https://prepkeys.com/az-200.html
You need to ensure that the SecurityPin security requirements are met.
Solution: Enable Always Encrypted for the SecurityPin column using a certificate based on a trusted certificate authority. Update the Getting Started document with instruction to ensure that the certificate is installed on user machines.
Does the solution meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You need to ensure that the SecurityPin security requirements are met.
Solution: Enable Always Encrypted for the SecurityPin column using a certificate contained in Azure Key Vault and grant the WebAppIdentity service principal access to the certificate.
Does the solution meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the
series contains a unique solution. Determine whether the solution meets the stated goals.
You need to ensure that the SecurityPin security requirements are met.
Solution; Using the Azure Portal, add Data Masking to the SecurityPin column, and exclude the dbo user.
Add a SQL security policy with a filter predicate based on the user identity.
Does the solution meet the goal?
You need to construct the link to the summary report for the email that is sent to users.
What should you do?
You need to resolve the log capacity issue.
What should you do?
You need to ensure the security policies are met.
What code do you add at line CS07?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You connect to Azure by using a workstation that has a slow internet connection. You have two Azure file shares. You plan to transfer a series of large files from another container. The workstation does no1 have sufficient disk space to store the files.
You define the following variables in Azure PowerShell:

You need to simultaneously transfer the large files as efficiently as possible.
Solution: Write a C# application that implements the Azure Storage API method CloudFile.StartCopy to transfer files to the destination container.
Does the solution meet the goal?
You connect to Azure by using a workstation that has a slow internet connection. You have two Azure file shares. You plan to transfer a series of large files from one container to another container. The workstation does not have sufficient disk space to store the files.
You define the following variables in Azure PowerShell:

You need to simultaneously transfer the large files as efficiently as possible.
Solution: Run the following Azure PowerShell command: AzCopy /Source:$sourceServer /Dest:$Dest5erver /SourceKey:JsourceKey /DestKey:$destkey / S Does the solution meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You connect to Azure by using a workstation that has a slow internet connection. You have two Azure file shares. You plan to transfer a series of large files from one container to another container. The workstation does not have sufficient disk space to store the files.
You define the following variables in Azure PowerShell:

You need to simultaneously transfer the large files as efficiently as possible.
Solution: Write a C# application that uses the Azure .NET API method CloudFile.StartCopyAsync to transfer files to the destination container.
Does the solution meet the goal?
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have the following resource group:

Developers must connect to Dev$erver onry through DevWorkstatioan. To maintain security, DevServer must not accept connections from the internet.
You need to create a private connection between the DevWortcstation and DevServer.
Solution: Configure an IP address on each subnet within the same address space.
Does the solution meet the goal?



