ExamGecko
Home Home / Microsoft / AZ-305

Microsoft AZ-305 Practice Test - Questions Answers, Page 6

Question list
Search
Search

List of questions

Search

Related questions











You plan to deploy an Azure SQL database that will store Personally Identifiable Information (Pll). You need to ensure that only privileged users can view the Pll. What should you include in the solution?

A.
Transparent Data Encryption (TDE)
A.
Transparent Data Encryption (TDE)
Answers
B.
Data Discovery & Classification
B.
Data Discovery & Classification
Answers
C.
dynamic data masking
C.
dynamic data masking
Answers
D.
role-based access control (RBAC)
D.
role-based access control (RBAC)
Answers
Suggested answer: C

You have the resources shown in the following table.

CDB1 hosts a container that stores continuously updated operational data.

You are designing a solution that will use AS! to analyze the operational data daily.

You need to recommend a solution to analyze the data without affecting the performance of the operational data store. What should you include in the recommendation?

A.
Azure Cosmos DB change feed
A.
Azure Cosmos DB change feed
Answers
B.
Azure Data Factory with Azure Cosmos DB and Azure Synapse Analytics connectors
B.
Azure Data Factory with Azure Cosmos DB and Azure Synapse Analytics connectors
Answers
C.
Azure Synapse Analytics with PolyBase data loading
C.
Azure Synapse Analytics with PolyBase data loading
Answers
D.
Azure Synapse Link for Azure Cosmos DB
D.
Azure Synapse Link for Azure Cosmos DB
Answers
Suggested answer: D

You store web access logs data in Azure Blob storage.

You plan to generate monthly reports from the access logs.

You need to recommend an automated process to upload the data to Azure SQL Database every month.

What should you include in the recommendation?

A.
Azure Data Factory
A.
Azure Data Factory
Answers
B.
Data Migration Assistant
B.
Data Migration Assistant
Answers
C.
Microsoft SQL Server Migration Assistant (SSMA)
C.
Microsoft SQL Server Migration Assistant (SSMA)
Answers
D.
AzCopy
D.
AzCopy
Answers
Suggested answer: A

Explanation:

Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database.

Reference:

https://docs.microsoft.com/en-gb/azure/data-factory/introduction

HOTSPOT

You plan to deploy Azure Databricks to support a machine learning application. Data engineers will mount an Azure Data Lake Storage account to the Databricks file system. Permissions to folders are granted directly to the data engineers. You need to recommend a design for the planned Databrick deployment. The solution must meet the following requirements:

Ensure that the data engineers can only access folders to which they have permissions. Minimize development effort. Minimize costs.

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


Question 54
Correct answer: Question 54

Explanation:

Box 1: Standard

Choose Standard to minimize costs.

Box 2: Credential passthrough

Athenticate automatically to Azure Data Lake Storage Gen1 (ADLS Gen1) and Azure Data Lake Storage Gen2 (ADLS Gen2) from Azure Databricks clusters using the same Azure Active Directory (Azure AD) identity that you use to log into Azure Databricks. When you enable Azure Data Lake Storage credential passthrough for your cluster, commands that you run on that cluster can read and write data in Azure Data Lake Storage without requiring you to configure service principal credentials for access to storage.

Reference: https://docs.microsoft.com/en-us/azure/databricks/security/credential-passthrough/adls-passthrough

HOTSPOT

You plan to deploy an Azure web app named App1 that will use Azure Active Directory (Azure AD) authentication. App1 will be accessed from the internet by the users at your company. All the users have computers that run Windows 10 and are joined to Azure AD. You need to recommend a solution to ensure that the users can connect to App1 without being prompted for authentication and can access App1 only from company-owned computers. 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.


Question 55
Correct answer: Question 55

Explanation:

Box 1: An Azure AD app registration

Azure active directory (AD) provides cloud based directory and identity management services.You can use azure AD to manage users of your application and authenticate access to your applications using azure active directory. You register your application with Azure active directory tenant.

Box 2: A conditional access policy

Conditional Access policies at their simplest are if-then statements, if a user wants to access a resource, then they must complete an action. By using Conditional Access policies, you can apply the right access controls when needed to keep your organization secure and stay out of your user's way when not needed.

Reference:

https://codingcanvas.com/using-azure-active-directory-authentication-in-your-web-application/ https://docs.microsoft.com/enus/azure/active-directory/conditional-access/overview

DRAG DROP

You have an Azure subscription. The subscription contains Azure virtual machines that run Windows Server 2016 and Linux. You need to use Azure Monitor to design an alerting strategy for security-related events.

Which Azure Monitor Logs tables should you query? To answer, drag the appropriate tables to the correct log types. Each table may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.


Question 56
Correct answer: Question 56

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-monitor/platform/data-sources-windows-events https://docs.microsoft.com/enus/azure/azure-monitor/agents/data-sources-syslog

DRAG DROP

Your on-premises network contains a server named Server1 that runs an ASP.NET application named App1. You have a hybrid deployment of Azure Active Directory (Azure AD).

You need to recommend a solution to ensure that users sign in by using their Azure AD account and Azure Multi-Factor Authentication (MFA) when they connect to App1 from the internet. Which three features should you recommend be deployed and configured in sequence? To answer, move the appropriate features from the list of features to the answer area and arrange them in the correct order.


Question 57
Correct answer: Question 57

HOTSPOT

You need to design a storage solution for an app that will store large amounts of frequently used data. The solution must meet the following requirements:

Maximize data throughput.

Prevent the modification of data for one year.

Minimize latency for read and write operations.

Which Azure Storage account type and storage service should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Question 58
Correct answer: Question 58

Explanation:

Box 1: BlockBlobStorage

Block Blob is a premium storage account type for block blobs and append blobs. Recommended for scenarios with high transactions rates, or scenarios that use smaller objects or require consistently low storage latency. Box 2: Blob

The Archive tier is an offline tier for storing blob data that is rarely accessed. The Archive tier offers the lowest storage costs, but higher data retrieval costs and latency compared to the online tiers (Hot and Cool). Data must remain in the Archive tier for at least 180 days or be subject to an early deletion charge.

Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/archive-blob

HOTSPOT

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

You plan to implement two new apps that have the requirements shown in the following table.

Which storage accounts should you recommend using for each app? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Question 59
Correct answer: Question 59

Explanation:

Box 1: Storage1 and storage3 only

Azure Blob Storage lifecycle management offers a rich, rule-based policy for GPv2 and blob storage accounts. Storage 2 does not support access tiers. Box 2: Storage1 and storage4 only

FileStorage storage accounts allow you to deploy Azure file shares on premium/solid-state disk-based (SSD-based) hardware.

Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts https://docs.microsoft.com/jajp/azure/storage/common/storage-account-overview

HOTSPOT

You have an on-premises database that you plan to migrate to Azure.

You need to design the database architecture to meet the following requirements:

Support scaling up and down.

Support geo-redundant backups.

Support a database of up to 75 TB.

Be optimized for online transaction processing (OLTP).

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


Question 60
Correct answer: Question 60

Explanation:

Box 1: Azure SQL Database Azure SQL Database:

Database size always depends on the underlying service tiers (e.g. Basic, Business Critical, Hyperscale). It supports databases of up to 100 TB with Hyperscale service tier model. Active geo-replication is a feature that lets you to create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary databases are also known as geo-secondaries, or geo-replicas. Azure SQL Database and SQL Managed Instance enable you to dynamically add more resources to your database with minimal downtime. Box 2: Hyperscale Incorrect Answers:

SQL Server on Azure VM: geo-replication not supported.

Azure Synapse Analytics is not optimized for online transaction processing (OLTP).

Azure SQL Managed Instance max database size is up to currently available instance size (depending on the number of vCores). Max instance storage size (reserved) - 2 TB for 4 vCores

- 8 TB for 8 vCores - 16 TB for other sizes

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview https://medium.com/awesome-azure/azure-difference-between-azure-sql-database-and-sql-server-on-vm-comparison-azuresql-vs-sql-server-vm-cf02578a1188

Total 299 questions
Go to page: of 30