Practice Free AZ-305 Exam Online Questions
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?
- A . Always Encrypted
- B . Azure Advanced Threat Protection
- C . Transparent Data Encryption
- D . Dynamic Data Masking
HOTSPOT
You plan to develop a new app that will store business critical data.
The app must meet the following requirements:
✑ Prevent new data from being modified for one year.
✑ Minimize read latency.
✑ Maximize data resiliency.
You need to recommend a storage solution for the app.
What should you recommend? To answer, select the appropriate options in the answer area.
Your company develops Azure applications.
You need to recommend a solution for the deployment of Azure subscriptions.
The solution must meet the following requirements:
What should you include in the recommendation?
- A . Provision resource groups.
- B . Support deployments across all Azure regions.
- C . Create custom role-based access control (RBAC) roles.
- D . Provide consistent virtual machine and virtual network configurations.
You need to design a solution that will execute custom C# code in response to an event routed to Azure Event Grid.
The solution must meet the following requirements:
✑ The executed code must be able to access the private IP address of a Microsoft SQL Server instance that runs on an Azure virtual machine.
Costs must be minimized.
What should you include in the solution?
- A . Azure Logic Apps in the integrated service environment
- B . Azure Functions in the Dedicated plan and the Basic Azure App Service plan
- C . Azure Logic Apps in the Consumption plan
- D . Azure Functions in the Consumption plan
HOTSPOT
You are developing a multi-tier app named App1 that will be hosted on Azure virtual machines. The peak utilization periods for App1 will be from 8 AM to 9 AM and 4 PM to 5 PM on weekdays.
You need to deploy the infrastructure for App1.
The solution must meet the following requirements:
• Support virtual machines deployed to four availability zones across two Azure regions.
• Minimize costs by accumulating CPU credits during periods of low utilization.
What is the minimum number of virtual networks you should deploy, and which virtual machine size should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You have an Azure App Service web app that uses a system-assigned managed identity.
You need to recommend a solution to store their settings of the web app as secrets in an Azure key vault.
The solution must meet the following requirements:
• Minimize changes to the app code,
• Use the principle of least privilege.
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager (ARM) resource deployments in your Azure subscription. The solution must minimize development effort.
What should you include in the recommendation?
- A . Azure Arc
- B . Azure Activity Log
- C . Azure Monitor metrics
- D . Application Insights
You have a business-critical app named Appl that is hosted in an Azure Kubernetes Service (AKS) cluster.
You need to recommend a configuration solution for the cluster.
The solution must meet the following requirements:
• Maintain availability during planned datacenter maintenance events.
• Support dynamic scaling in response to workload demands.
• Minimize downtime if a datacenter fails.
What should you recommend?
- A . an AKS cluster deployed to a single availability zone
- B . an AKS cluster with availability zones enabled
- C . an AKS cluster that has nodes deployed to different Azure regions
- D . an AKS cluster with multiple node pools deployed to a single availability zone
HOTSPOT
You plan to develop two apps that will be hosted in Azure.
The apps must meet the monitoring requirements shown in the following table.
What should you include in the recommendation for each app? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.
Your company has 50 business units across the globe. The business units operate from 08:00 AM to 06:00 PM from Monday to Friday in their local time zone. Transactions are only processed during business hours.
You have an Azure subscription.
You plan to deploy an app named App1 that will manage the transactions for the business units.
App1 will use a separate Azure SQL database for each business unit.
You need to recommend an Azure SQL Database configuration for App1.
The solution must meet the following requirements:
• Support Azure Hybrid Benefit licensing.
• Minimize costs.
What should you recommend?
- A . a vCore purchasing model and multiple single database instances
- B . a DTU purchasing model and multiple single database instances
- C . a vCore purchasing model and multiple database instances in an elastic pool
- D . a DTU purchasing model and multiple database instances in an elastic pool