Microsoft Updated AZ-305 Exam Questions and Answers by seb

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and an Azure Synapse Analytics workspace named Workspace1. The account1 account contains a container named Container1 that has the analytical store enabled.

You need to recommend a solution that will process the data stored in Container1 in near-real-time (NRT) and output the results to a data warehouse in Workspace1 by using a runtime engine in the workspace. The solution must minimize data movement.

Which pool in Workspace! should you use?

You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process.

You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements:

Provide the ability to recover in the event of a regional outage.

Support a recovery time objective (RTO) of 15 minutes.

Support a recovery point objective (RPO) of 24 hours.

Support automated recovery.

Minimize costs.

What should you include in the recommendation?

Your company, named Contoso, Ltd., has an Azure subscription that contains the following resources:

• An Azure Synapse Analytics workspace named contosoworkspacel

• An Azure Data Lake Storage account named contosolakel

• An Azure SQL database named contososql1

The product data of Contoso is copied from contososqM to contosolakel.

Contoso has a partner company named Fabrikam Inc. Fabrikam has an Azure subscription that contains the following resources:

• A virtual machine named FabrikamVMI that runs Microsoft SQL Server 2019

• An Azure Storage account named fabrikamsal

Contoso plans to upload the research data on FabrikamVMI to contosolakel. During the upload, the research data must be transformed to the data formats used by Contoso.

The data in contosolakel will be analyzed by using contosoworkspacel.

You need to recommend a solution that meets the following requirements:

• Upload and transform the FabrikamVMI research data.

• Provide Fabrikam with restricted access to snapshots of the data in contosoworkspace1.

What should you recommend for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription named Subscription1 that is linked to a hybrid Azure Active Directory (Azure AD) tenant.

You have an on-premises datacenter that does NOT have a VPN connection to Subscription1. The datacenter contains a computer named Server1 that has Microsoft SQL Server 2016 installed. Server1 is prevented from accessing the internet.

An Azure logic app named LogicApp1 requires write access to a database on Server1.

You need to recommend a solution to provide LogicApp1 with the ability to access Server1.

What should you recommend deploying on-premises and in Azure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.