Online Access Free AZ-304 Practice Test

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2012 R2 instances. The instances host databases that have the following characteristics:
The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
Stored procedures are implemented by using CLR.
You plan to move all the data from SQL Server to Azure.
You need to recommend an Azure service to host the databases. The solution must meet the following requirements:
Whenever possible, minimize management overhead for the migrated databases.
Minimize the number of database changes required to facilitate the migration.
Ensure that users can authenticate by using their Active Directory credentials.
What should you include in the recommendation?

• A.Azure SQL Database elastic pools
• B.Azure SQL Database single databases
• C.SQL Server 2016 on Azure virtual machines
• D.Azure SQL Database Managed Instance

You have an Azure subscription that contains an Azure SQL database named DB1.
Several queries that query the data in DB1 take a long time to execute.
You need to recommend a solution to identify the queries that take the longest to execute.
What should you include in the recommendation?

• A.SQL Database Advisor
• B.Azure Monitor
• C.Query Performance Insight
• D.Performance Recommendations

You need to recommend a notification solution for the IT Support distribution group.
What should you include in the recommendation?

• A.a SendGrid account with advanced reporting
• B.Azure AD Connect Health
• C.Azure Network Watcher
• D.an action group

You architect a solution that calculates 3D geometry from height-map data.
You have the following requirements:
Perform calculations in Azure.
Each node must communicate data to every other node.
Maximize the number of nodes to calculate multiple scenes as fast as possible.
Require the least amount of effort to implement.
You need to recommend a solution.
Which two actions should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Create a render farm that uses Azure Batch.
• B.Create a render farm that uses virtual machine (VM) scale sets.
• C.Create a render farm that uses virtual machines (VMs).
• D.Enable parallel task execution on compute nodes.
• E.Enable parallel file systems on Azure.

Note: This question is part of 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 an on-premises Active Directory Domain Services (AD DS) domain and an established Azure Active Directory (Azure AD) environment.
Your company would like users to be automatically signed in to cloud apps when they are on their corporate desktops that are connected to the corporate network.
You need to enable single sign-on (SSO) for company users.
Solution: Install and configure an on-premises Active Directory Federation Services (AD FS) server with a trust established between the AD FS server and Azure AD.
Does the solution meet the goal?

• A.Yes
• B.No