ExamGecko
Home Home / Microsoft / AZ-305

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

Question list
Search
Search

List of questions

Search

Related questions











You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2. You plan to migrate DB1 and DB2 to Azure.

You need to recommend an Azure solution to host DB1 and DB2. The solution must meet the following requirements:

• Support server-side transactions across DB1 and DB2.

• Minimize administrative effort to update the solution.

What should you recommend?

A.
two SQL Server databases on an Azure virtual machine
A.
two SQL Server databases on an Azure virtual machine
Answers
B.
two Azure SQL databases on different Azure SQL Database servers
B.
two Azure SQL databases on different Azure SQL Database servers
Answers
C.
two Azure SQL databases in an elastic pool
C.
two Azure SQL databases in an elastic pool
Answers
D.
two Azure SQL databases on the same Azure SQL Database managed instance
D.
two Azure SQL databases on the same Azure SQL Database managed instance
Answers
Suggested answer: D

Explanation:

When both the database management system and client are under the same ownership (e.g. when SQL Server is deployed to a virtual machine), transactions are available and the lock duration can be controlled. Reference: https:// docs.particular.net/nservicebus/azure/understanding-transactionalityin- azure

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. Your company has deployed several virtual machines (VMs) on-premises and to Azure. Azure ExpressRoute has been deployed and configured for on-premises to Azure connectivity. Several VMs are exhibiting network connectivity issues.

You need to analyze the network traffic to determine whether packets are being allowed or denied to the VMs. Solution: Use the Azure Traffic Analytics solution in Azure Log Analytics to analyze the network traffic. Does the solution meet the goal?

A.
Yes
A.
Yes
Answers
B.
No
B.
No
Answers
Suggested answer: B

Explanation:

Instead use Azure Network Watcher to run IP flow verify to analyze the network traffic.

Reference:

https://docs.microsoft.com/en-us/azure/network-watcher/network-watcher-monitoring-overview

https://docs.microsoft.com/en-us/azure/network-watcher/network-watcher-ip-flow-verify-overview

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Storage account that contains two 1-GB data files named File1 and File2. The data files are set to use the archive access tier. You need to ensure that File1 is accessible immediately when a retrieval request is initiated.

Solution: For File1, you set Access tier to Cool.

Does this meet the goal?

A.
Yes
A.
Yes
Answers
B.
No
B.
No
Answers
Suggested answer: A

Explanation:

The data in the cool tier is "considered / intended to be stored for 30 days". But this is not a must. You can store data indefinitely in the cool tier. The mentioned reference (see below) even gives an example of large scientific or otherwise large data which is stored for long duration in the cool tier. https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers?tabs=azure-portal

You plan to deploy 10 applications to Azure. The applications will be deployed to two Azure Kubernetes Service (AKS) clusters. Each cluster will be deployed to a separate Azure region. The application deployment must meet the following requirements:

• Ensure that the applications remain available if a single AKS cluster fails.

• Ensure that the connection traffic over the internet is encrypted by using SSL without having to configure SSL on each container. Which service should you include in the recommendation?

A.
AKS ingress controller
A.
AKS ingress controller
Answers
B.
Azure Traffic Manager
B.
Azure Traffic Manager
Answers
C.
Azure Front Door
C.
Azure Front Door
Answers
D.
Azure Load Balancer
D.
Azure Load Balancer
Answers
Suggested answer: C

Explanation:

"Azure Front Door, which focuses on global load-balancing and site acceleration, and Azure CDN Standard, which offers static content caching and acceleration. The new Azure Front Door brings together security with CDN technology for a cloud-based CDN with threat protection and additional capabilities. "

You have an Azure Data Lake Storage account that contains 1,000 10-MB CSV files and an Azure Synapse Analytics dedicated SQL pool named sql1. You need to load the files to sql1. The solution must meet the following requirements:

Maximize data load performance.

Eliminate the need to define external tables before the data loads.

What should you use?

A.
the copy statement
A.
the copy statement
Answers
B.
PolyBase
B.
PolyBase
Answers
C.
BCP
C.
BCP
Answers
D.
the sqlBulkcopy object
D.
the sqlBulkcopy object
Answers
Suggested answer: B

You plan to deploy an Azure Databricks Data Science & Engineering workspace and ingest data into the workspace. Where should you persist the ingested data?

A.
Azure Files
A.
Azure Files
Answers
B.
Azure Data Lake
B.
Azure Data Lake
Answers
C.
Azure SQL Database
C.
Azure SQL Database
Answers
D.
Azure Cosmos DB
D.
Azure Cosmos DB
Answers
Suggested answer: B

Explanation:

The Azure Databricks Data Science & Engineering data lands in a data lake for long term persisted storage, in Azure Blob Storage or Azure Data Lake Storage.

Reference:

https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks-ws

You plan to migrate data to Azure.

The IT department at your company identifies the following requirements:

The storage must support 1 PB of data.

The data must be stored in blob storage.

The storage must support three levels of subfolders.

The storage must support access control lists (ACLs).

You need to meet the requirements.

What should you use?

A.
a premium storage account that is configured for block blobs
A.
a premium storage account that is configured for block blobs
Answers
B.
a general purpose v2 storage account that has hierarchical namespace enabled
B.
a general purpose v2 storage account that has hierarchical namespace enabled
Answers
C.
a premium storage account that is configured for page blobs
C.
a premium storage account that is configured for page blobs
Answers
D.
a premium storage account that is configured for files shares and supports large file shares
D.
a premium storage account that is configured for files shares and supports large file shares
Answers
Suggested answer: B

Explanation:

Microsoft recommends that you use a GPv2 storage account for most scenarios. It supports up to 5 PB, and blob storage including Data Lake storage. Note: A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.

Reference:

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview

https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You are designing an Azure solution for a company that has four departments. Each department will deploy several Azure app services and Azure SQL databases. You need to recommend a solution to report the costs for each department to deploy the app services and the databases. The solution must provide a consolidated view for cost reporting that displays cost broken down by department. Solution: Create a separate resource group for each department. Place the resources for each department in its respective resource group. Does this meet the goal?

A.
Yes
A.
Yes
Answers
B.
No
B.
No
Answers
Suggested answer: B

Explanation:

Instead create a resources group for each resource type. Assign tags to each resource group.

Note: Tags enable you to retrieve related resources from different resource groups. This approach is helpful when you need to organize resources for billing or management.

Reference:

https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-using-tags

You are designing a solution that will include containerized applications running in an Azure Kubernetes Service (AKS) cluster. You need to recommend a load balancing solution for HTTPS traffic. The solution must meet thefollowing requirements:

Automatically configure load balancing rules as the applications are deployed to the cluster.

Support Azure Web Application Firewall (WAF).

Support cookie-based affinity.

Support URL routing.

What should you include the recommendation?

A.
an NGINX ingress controller
A.
an NGINX ingress controller
Answers
B.
Application Gateway Ingress Controller (AGIC)
B.
Application Gateway Ingress Controller (AGIC)
Answers
C.
an HTTP application routing ingress controller
C.
an HTTP application routing ingress controller
Answers
D.
the Kubernetes load balancer service
D.
the Kubernetes load balancer service
Answers
Suggested answer: B

Explanation:

Much like the most popular Kubernetes Ingress Controllers, the Application Gateway Ingress Controller provides several features, leveraging Azure’s native Application Gateway L7 load balancer. To name a few:

URL routing

Cookie-based affinity

Secure Sockets Layer (SSL) termination

End-to-end SSL

Support for public, private, and hybrid web sites

Integrated support of Azure web application firewall

Application Gateway redirection support isn't limited to HTTP to HTTPS redirection alone. This is ageneric redirection mechanism, so you can redirect from and to any port you define using rules. Italso supports redirection to an external site as well.

Reference:

https://docs.microsoft.com/en-us/azure/application-gateway/features

You have an application named App1. App1 generates log files that must be archived for five years.

The log files must be readable by App1 but must not be modified.

Which storage solution should you recommend for archiving?

A.
Ingest the log files into an Azure Log Analytics workspace
A.
Ingest the log files into an Azure Log Analytics workspace
Answers
B.
Use an Azure Blob storage account and a time-based retention policy
B.
Use an Azure Blob storage account and a time-based retention policy
Answers
C.
Use an Azure Blob storage account configured to use the Archive access tier
C.
Use an Azure Blob storage account configured to use the Archive access tier
Answers
D.
Use an Azure file share that has access control enabled
D.
Use an Azure file share that has access control enabled
Answers
Suggested answer: B

Explanation:

Immutable storage for Azure Blob storage enables users to store business-critical data objects in a WORM (Write Once, Read Many) state. Immutable storage supports:

Time-based retention policy support: Users can set policies to store data for a specified interval. When a time-based retention policy is set, blobs can be created and read, but not modified or deleted. After the retention period has expired, blobs can be deleted but not overwritten.

Reference:

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

Total 299 questions
Go to page: of 30