70-473 Practice Questions

Your company has two offices 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 p...

You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine. The application experiences performance issues, which you suspect are relate...

You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises. If the network fails, you need to ensure...

You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group. You are planning a backup solution for the database. Backups will run on a secondary r...

You have a report that runs against a Microsoft Azure SQL database. The report takes more time to return results than expected. You add an index to a table in the database. You nee...

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 Yo...

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the...

You need to recommend a backup solution for the ListTest database. What should you include in the recommendation?

You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?

You are evaluating whether an Azure SQL Database elastic database pool suits your workload and usage patterns. What are two possible ways to identify the elastic database transacti...

You need to recommend a solution to migrate the Listings database to the cloud. What should you recommend?

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04. You are designing the data warehouse....

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04. You are evaluating the use of active g...

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 solu...

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 ensure that the performanc...

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 tell the research project...

You are evaluating moving the data from WebData1 to an Azure SQL database. You need to recommend a solution to generate the consolidated report for billing. The solution must meet...

You are planning the consolidation of the databases from Host1. You need to identify which methods to use to back up the data after the consolidation completes. What are two possib...

You need to recommend a disaster recovery solution for the CRM application that meets the business requirements. What should you recommend?

You are evaluating whether to replace CRM-B with an Azure virtual machine. You need to identify the required virtual machine service tier to replace CRM. The solution must meet the...

You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template. You plan to deploy a PHP-based app in an Azure web app. The web app will use a...

You plan to implement a Microsoft Azure SQL database. You need to create and manage the new database on a new server. Which three cmdlets should you use? Each correct answer presen...

You have a Microsoft Azure SQL data warehouse. During peak usage, you discover that the data warehouse fails to meet performance expectations. You need to provide additional resour...

You have several SQL Server instances on Microsoft Azure virtual machines. Periodically, one of the virtual machines runs more slowly than expected. The issue typically persists fo...

You have a Microsoft SQL Server instance on a Microsoft Azure virtual machine. The members of an Active Directory group named HelpDesk can log in to the SQL Server instance. You ne...

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 hou...

You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine. One of the databases on the virtual machine supports a highly active Online Transaction Processin...

You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service...

You have a Microsoft SQL Server 2014 instance on a Microsoft Azure virtual machine. You need to ensure that all SQL Server audits are written to the Windows Security log. Which two...

You have a Microsoft Azure SQL database that is used for reporting. You discover that some reports complete more quickly than other reports, even though the reports retrieve approx...

You have a Microsoft Azure SQL database. You need to ensure that you can use the Always Encrypted feature for the database. Which two components should you configure? Each correct...

You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses the Premium service tier. Users of the database are located in Los Angeles, New York,...

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...

You are implementing a database on Azure SQL Database. The database will be used by a website hosted in Azure. The database has the following requirements: - Latency between the ap...

You are a database administrator for a retail e-commerce web application solution. Your databases for this solution are all stored in the Azure SQL Database service. You learn that...

You need to design a security strategy to support the planned changes for the customer databases, The solution must meet the security requirements. Which two security roles should...

You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings. Which disaster...

You need to recommend a database strategy to support the planned new customers. The solution must minimize costs. What should you recommend?

Relecloud recently implemented the planned changes. you plan to add a new customer named Fabrikam, Inc. You need to ensure that the administrators at Fabrikam can access their data...

You need to recommend a solution to meet the network requirement. What should you recommend?

You need to recommend a solution to meet the reporting requirements of App3. What should you include in the recommendation?

What should you use to schedule the nightly jobs to meet the technical requirements?

You need to implement a solution to meet the technical requirements for the encryption of the data in Appl. Which two features should you enable? Each correct answer presents pan o...

Which database platform should App3 use?

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 q...

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 q...

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 q...

You have a Microsoft Azure SQL database named DB1 and a copy of DB1 named DB1Test. You use DB1Test to test the deployment of major updates to the database. You discover that DB1Tes...

You manage a large Microsoft Azure SQL database. The database contains data that changes several thousand times each day. You need to ensure that the performance of the database st...

Your company has a Microsoft SQL Server database hosted on a Microsoft Azure virtual machine. You create several reports that display data from the database. Users report that the...