ExamGecko
Home Home / Microsoft / AZ-305

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

Question list
Search
Search

List of questions

Search

Related questions











You are designing an app that will use Azure Cosmos DB to collate sales data from multiple countries. You need to recommend an API for the app. The solution must meet the following requirements:

• Support SQL queries.

• Support geo-replication.

• Store and access data relationally.

Which API should you recommend?

A.
PostgreSQL
A.
PostgreSQL
Answers
B.
NoSQL
B.
NoSQL
Answers
C.
Apache Cassandra
C.
Apache Cassandra
Answers
D.
MongoDB
D.
MongoDB
Answers
Suggested answer: A

HOTSPOT

You have an Azure AD tenant that contains a management group named MG1. You have the Azure subscriptions shown in the following table.

The subscriptions contain the resource groups shown in the following table.

The subscription contains the Azure AD security groups shown in the following table.

The subscription contains the user accounts shown in the following table.

You perform the following actions:

• Assign User3 the Contributor role for Sub1.

• Assign Group1 the Virtual Machine Contributor role for MG1.

• Assign Group3 the Contributor role for the Tenant Root Group.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Question 192
Correct answer: Question 192

HOTSPOT

You are designing an app that will be hosted on Azure virtual machines that run Ubuntu. The app will use a third-party email service to send email messages to users. The third-party email service requires that the app authenticate by using an API key.

You need to recommend an Azure Key Vault solution for storing and accessing the API key. The solution must minimize administrative effort. What should you recommend using to store and access the key? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Question 193
Correct answer: Question 193

Your company deploys several virtual machines on-premises and to Azure. ExpressRoute is deployed and configured for on-premises to Azure connectivity. Several virtual machines exhibit network connectivity issues.

You need to analyze the network traffic to identify whether packets are being allowed or denied from the Azure virtual machines to the on-premises virtual machines. Solution: Use Azure Advisor.

Does this meet the goal?

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

DRAG DROP

You have two app registrations named App1 and App2 in Azure AD. App1 supports role-based access control (RBAC) and includes a role named Writer.

You need to ensure that when App2 authenticates to access App1, the tokens issued by Azure AD include the Writer role claim.

Which blade should you use to modify each app registration? To answer, drag the appropriate blades to the correct app registrations. Each blade 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 195
Correct answer: Question 195

You have an Azure subscription that contains 10 web apps. The apps are integrated with Azure AD and are accessed by users on different project teams.

The users frequently move between projects.

You need to recommend an access management solution for the web apps. The solution must meet the following requirements:

• The users must only have access to the app of the project to which they are assigned currently.

• Project managers must verify which users have access to their project s app and remove users that are no longer assigned to their project.

• Once every 30 days, the project managers must be prompted automatically to verify which users are assigned to the projects.

What should you include in the recommendation?

A.
Microsoft Defender for Identity
A.
Microsoft Defender for Identity
Answers
B.
Azure AD Identity Governance
B.
Azure AD Identity Governance
Answers
C.
Microsoft Entra Permissions Management
C.
Microsoft Entra Permissions Management
Answers
D.
Azure AD Identity Protection
D.
Azure AD Identity Protection
Answers
Suggested answer: B

HOTSPOT

You have an Azure subscription. The subscription contains an Azure SQL managed instance that stores employee details, including social security numbers and phone numbers.

You need to configure the managed instance to meet the following requirements:

• The helpdesk team must see only the last four digits of an employee's phone number.

• Cloud administrators must be prevented from seeing the employee’s social security numbers.

What should you enable tor each column in the managed instance? To answer select the appropriate options in the answer area.

NOTE; Each correct selection is worth one point

Question 197
Correct answer: Question 197

You have an on-premises Microsoft SQL Server 2008 instance that hosts a 50-GB database.

You need to migrate the database to an Azure SQL managed instance. The solution must minimize downtime.

What should you use?

A.
Azure Migrate
A.
Azure Migrate
Answers
B.
WANdisco LiveData Platform for Azure
B.
WANdisco LiveData Platform for Azure
Answers
C.
Azure Data Studio
C.
Azure Data Studio
Answers
D.
SQL Server Management Studio (SSMS)
D.
SQL Server Management Studio (SSMS)
Answers
Suggested answer: C

HOTSPOT

You have an Azure subscription that contains 50 Azure SQL databases.

You create an Azure Resource Manager (ARM) template named. Template1 that enables Transparent Data Encryption (TDE).

You need to create an Azure Policy definition named Policy1 that will use Template1 to enable IDE for any noncompliant Azure SQL databases.

How should you configure Policy 1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 199
Correct answer: Question 199

OTSPOT

You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1.

You have an Azure subscription that contains a virtual machine named VM1VM1 runs Linux and contains a SQL Server 2019 instance.

You need to migrate DB1 to VMI. The solution must minimize downtime on DBI. What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 200
Correct answer: Question 200
Total 299 questions
Go to page: of 30