Exact 70-473 Dumps Questions 2021

NEW QUESTION 1
Your company has two offices. The offices are located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft SQL Server database that is hosted on a Microsoft Azure virtual machine. Currently, only the users in the London office use the database.
You need to create a new firewall rule to provide the users in the New York office with access to the database. The solution must protect the database from being accessed by users on the public Internet.
What should you do?

• A. Modify the endpoint from the Azure portal.
• B. Use the sp_set_database_firewall_rule stored procedure.
• C. Disable the Windows Firewall on the Azure virtual machine.
• D. Run the New-AzureSqlDatabaseServerFirewallRule Azure PowerShell cmdlet.
• E. Use the Set Firewall Rule REST API.

Answer: A

Explanation: This Microsoft SQL Server database is hosted on a Microsoft Azure virtual machine. Therefore, remote access will be provided via the endpoint rather than a database level firewall rule.

NEW QUESTION 2
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 a Microsoft Azure Database for MySQL Server named SQLDB1. Four database administrators manage SQLDB1.
You need to prevent any administrator from deleting the server that hosts SQLDB1.
Solution: You create a delete lock on the database resource in Azure. Does this meet the goal?

• A. Yes
• B. No

Answer: B

NEW QUESTION 3
NO: 157 DRAG DROP
You are monitoring a Microsoft Azure SQL database. You need to view which queries users are running against the database currently.
Which statement should you use? To answer, drag the appropriate elements to the correct locations. Each element 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.

Answer:

Explanation:

NEW QUESTION 4
You have an organizational data mart that contains 3.5 TB of uncompressed data.
The size of the data is expected to grow 2 annually. Reporting is performed only during business hours. You plan to move the data to the cloud.
You need to design a cloud architecture for the data mart. The solution must minimize costs and administrative overhead.
What is the best design to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

• A. a Microsoft Azure SQL data warehouse
• B. a Microsoft SQL Server virtual machine
• C. a Microsoft Azure HDInsight cluster
• D. a Microsoft Azure SQL database

Answer: A

Explanation: References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-data-warehouse-overview-what-is/

NEW QUESTION 5
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the
solution.

• A. Transaction Management
• B. Stored Procedure
• C. Plain SQL
• D. Login
• E. Failed Connections

Answer: ABD

NEW QUESTION 6
You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic reports during business hours only. All reports will be generated by using Microsoft Excel.
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest possible read performance.
Which data platform should you recommend?

• A. Microsoft Azure SQL Data Warehouse
• B. Microsoft Azure Cosmos DB
• C. Microsoft Azure SQL Database
• D. Microsoft Azure Data Lake

Answer: D

NEW QUESTION 7
You plan to deploy two Microsoft Azure virtual machines that will run Microsoft SQL Server.
You need to ensure that users can continue to access the data on the SQL servers during Azure planned maintenance events.
Which three components should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Traffic Manager
• B. an Always On availability group
• C. a virtual network service endpoint
• D. an availability set
• E. an internal load balancer

Answer: BDE

Explanation: References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-alwa

NEW QUESTION 8
Your company's data center contains two databases named DB1 and DB2.
DB1 contains 500 MB of data. DB2 contains 400 GB of data that is read-only. Both databases contain sensitive data.
Each database regularly has more than 1,000 concurrent connections.
You need to migrate the databases to Microsoft Azure SQL Database. The solution must minimize costs. Which tier and service level should you choose for each database? To answer, select the appropriate options in the answer area.

Answer:

Explanation: References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#single-da

NEW QUESTION 9
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

NEW QUESTION 10
You need to implement the monitoring solution for the Listings database.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation:

NEW QUESTION 11
You plan to create a database named DB1.
You need to ensure that all the data in DB1 is encrypted when the database is at rest.
Which four actions should you perform in sequence after you create DB1? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer:

Explanation: References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=

NEW QUESTION 12
Your organization contains several Microsoft Azure SQL databases.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases. Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Threat detection
• B. Query Performance Insight
• C. Management Data Warehouse
• D. Auditing
• E. Azure Resource Health

Answer: AD

Explanation: References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-threat-detection

NEW QUESTION 13
You have a Microsoft Azure virtual machine that hosts a Microsoft SQL Server database instance. Users report that during peak workloads, the database is slower than expected.
You query sys.dm_os_waiting_tasks and you discover that there are a high number of PAGEIOLATCH waits. You need to receive an alert if the storage on the Azure virtual machine is throttled.
What should you use?

• A. a SQL Server Agent alert
• B. Microsoft System Center alerts for DeviceRaidPort0 in the system event log
• C. Performance Monitor alerts
• D. Azure portal alerts on the storage pool
• E. Azure portal alerts on the virtual machine

Answer: CE

Explanation: References:
https://blogs.msdn.microsoft.com/mast/2021/09/12/how-to-monitor-and-alert-potential-disk-and-vm-level-io-thr

NEW QUESTION 14
A customer plans to monitor the performance of a Microsoft Azure SQL database.
You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU) percentage. Which three metrics should you identify? Each correct answer presents part of the solution.

• A. Log IO percentage
• B. Data IO percentage
• C. CPU percentage
• D. Blocked by firewall
• E. Database size percentage
• F. Total database size

Answer: ABC

Explanation: References:
http://dtucalculator.azurewebsites.net/

NEW QUESTION 15
Your company has a database that contains a column of private customer data.
You need to recommend a solution to encrypt the data in the column. The solution must meet the following requirements:
• System administrators must be able to index the column.
• System administrators must be prevented from reading the data in the column.
• All the keys used in the solution must be stored in a highly available and secure location. What should you recommend? To answer, select the appropriate options in the answer area.

Answer:

Explanation:

NEW QUESTION 16
You need to migrate DB2 to Azure.
Which utility should you use for each task? To answer, drag the appropriate utilities to the correct tasks. Each utility may be used once, more than once, or not at all. You made need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation: Box 1: mysqldump
Use common utilities and tools such as MySQL Workbench, mysqldump, Toad, or Navicat to remotely connect and restore data into Azure Database for MySQL.
Box 2: azcopy
AzCopy is a command-line tool for copying data to or from Azure Blob storage, Azure Files, and Azure Table storage, by using simple commands. The commands are designed for optimal performance. You can copy data between a file system and a storage account, or between storage accounts.
App2 is developed by using third-party open source code that is updated frequently. The database for App2 is named DB2. App2 only supports MySQL.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-migrate-import-export
https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy-migrate-on-premises-data?tabs=win

NEW QUESTION 17
You have a Microsoft Azure SQL database.
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database. You need to examine the system utilization trends over time.
Which dynamic management view should you query?

• A. sys.dm_exec_query_stats
• B. sys.events
• C. sys.resource_stats
• D. sys.dm_db_missing_index_details

Answer: C