You have to deploy an Azure SQL database named db1 for your company. The databases must meet the following security requirements When IT help desk supervisors query a database table named customers, they must be able to see the full number of each credit card When IT help desk operators query a database table named customers, they must only see the last four digits of each credit card number A column named Credit Card rating in the customers table must never appear in plain text in the database system. Only client applications must be able to decrypt the information that is stored in this column Which of the following can be implemented for the Credit Card rating column security requirement?

Azure Advanced Threat Protection

You have an Azure Active Directory (Azure AD) tenant that syncs with an on-premises Active Directory domain. Your company has a line-of-business (LOB) application that was developed internally.You need to implement. SAML single sign-on (SSO) and enforce multi-factor authentication (MFA) when users attempt to access the application from an unknown location. Which two features should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Azure AD enterprise applications

Azure AD Privileged Identity Management (PIM)

You ate designing an Azure governance solution.All Azure resources must be easily identifiable based on the following operational information environment, owner, department and cost center You need 10 ensure that you can use the operational information when you generate reports for the Azure resources.What should you include in the solution?

an Azure policy that enforces tagging rules

Azure Active Directory (Azure AD) administrative units

an Azure data catalog that uses the Azure REST API as a data source

an Azure policy that enforces tagging rules

an Azure management group that uses parent groups to create a hierarchy

You plan to automate the deployment of resources to Azure subscriptions.What is a difference between using Azure Blueprints and Azure Resource Manager (ARM) templates?

Blueprints remain connected to the deployed resources.

ARM templates remain connected to the deployed resources.

Only ARM templates can contain policy definitions.

Blueprints remain connected to the deployed resources.

Only Blueprints can contain policy definitions.

A company named Contoso, Ltd. has an Azure Active Directory (Azure AD) tenant that is integrated with Microsoft Office 365 and an Azure subscription. Contoso has an on-premises identity infrastructure. The infrastructure includes servers that run Active Directory Domain Services (AD DS), and Azure AD Connect Contoso has a partnership with a company named Fabrikam, Inc. Fabrikam has an Active Directory forest and an Office 365 tenant. Fabrikam has the same on-premises identity infrastructure as Contoso. A team of 10 developers from Fabrikam will work on an Azure solution that will be hosted in the Azure subscription of Contoso. The developers must be added to the Contributor role for a resource in the Contoso subscription. You need to recommend a solution to ensure that Contoso can assign the role to the 10 Fabrikam developers. The solution must ensure that the Fabrikam developers use their existing credentials to access resources. What should you recommend?

Configure a forest trust between the on-premises Active Directory forests of Contoso and Fabrikam.

Configure an organization relationship between the Office 365 tenants of Fabrikam and Contoso.

In the Azure AD tenant of Contoso, use MIM to create guest accounts for the Fabrikam developers.

Configure an AD FS relying party trust between the fabrikam and Contoso AD FS infrastructures.

You are designing a microservices architecture that will support a web application.The solution must meet the following requirements:Allow independent upgrades to each microserviceDeploy the solution on-premises and to AzureSet policies for performing automatic repairs to the microservicesSupport low-latency and hyper-scale operationsYou need to recommend a technology.What should you recommend?

Azure Virtual Machine Scale Set

You have an Azure subscription.Your on-premises network contains a file server named Server1. Server 1 stores 5 TB of company files that are accessed rarely. You plan to copy the files to Azure Storage.You need to implement a storage solution for the files that meets the following requirements:• The files must be available within 24 hours of being requested.• Storage costs must be minimized.Which two possible storage solutions achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Create a general-purpose v2 storage account that is configured for the Hot default access tier.Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

Create an Azure Blob storage account that is configured for the Cool default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

Create a general-purpose v1 storage account. Create a blob container and copy the files to the blob container.

Create a general-purpose v2 storage account that is configured for the Hot default access tier.Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

Create a general-purpose v1 storage account. Create a file share in the storage account and copy the files to the file share.

Create a general-purpose v2 storage account that is configured for the Cool default access tier. Create a file share in the storage account and copy the files to the file share.

Create an Azure Blob storage account that is configured for the Cool default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

You have 100 Microsoft SQL Server integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations. You plan to migrate the 10 on-premises databases to Azure SQL Database You need to recommend a solution to host the SSlS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.What should you include in the recommendation?

SQL Server Migration Assistant (SSMA)

Microsoft AZ-305 Practice Test 3 - Free Online Exam Prep & Questions

HOTSPOT

You have an Azure subscription that contains 300 Azure virtual machines that run Windows Server 2016. You need to centrally monitor all warning events in the System logs of the virtual machines.

What should you include in the solutions? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Become a Premium Member for full access

Unlock Premium Member

Microsoft AZ-305 Practice Test 3

Question

Microsoft AZ-305 Practice Tests

Practice Tests