70-473 Practice Questions

Your company has a data warehouse that contains a database named DB1. You plan to implement data encryption for DB1. You need to configure DB1 to meet the following requirements: -...

You plan to create a data warehouse in Microsoft Azure for development purposes. The data warehouse must not exceed 10 terabytes (TB) in size. You must minimize costs for the envir...

You have 10 Microsoft Azure SQL databases. One of the databases is named DB1. You need to ensure that only a specific IP address can be used to access DB1. The solution must affect...

Your company has a Microsoft Azure MySQL database that is used by an Azure Web App. The logical server that hosts the database contains other databases. You move the database to an...

Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed. An application named App1 uses the data stored in SQL server. The Service leve...

You have a failover cluster deployed to Microsoft Azure virtual machines. You plan to deploy a new Microsoft SQL instance to the cluster. The instance will host one database that h...

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

You have a Microsoft Azure Infrastructure as a Service (IaaS) environment that contains a 3-TB data warehouse. You need to recommend a solution to improve the read performance of t...

Your company registers the domain name of contoso.com. You plan to deploy two web servers, two application servers, and two Microsoft SQL server instances on Microsoft Azure virtua...

You implement Microsoft Azure ExpressRoute. You need to ensure that if the ExpressRoute connection is unavailable, you can manage the resources in Azure over a secure connection. W...

You recently implemented a Microsoft Azure SQL data warehouse. You discover that during peak hours, the data warehouse takes longer than expected to generate reports. You need to r...

You need to deploy a new Microsoft Azure SQL database that must meet the following requirements: * Will be available it a single Azure region becomes unavailable * Will be able to...

You have a Microsoft Azure SQL database named DB1. You need to monitor DB1 to identity all regressed queries. Which command should you use?

You need to create a Microsoft Azure Resource manager template. Which file format should you use?

You have Microsoft Azure SQL database named DB1. You plan to monitor the resource utilization of DB1. You need to review the following resource utilization: * Average compute * Ave...

You need to configure a runbook to execute when a Microsoft Azure SQL database uses more than 80 percent of the Database Throughput Unit (DTU) resources. What should you configure...

You have an application named App1 that uses a Microsoft Azure SQL database. Some users report that they receive messages similar to the following error message. "Transaction (Proc...

You are evaluating the migration of an on-premises Microsoft SQL server database to a Microsoft Azure SQL database. You need to identity the minimum service tier required to host t...

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 plan to migrate an on-premises Microsoft SQL Server database to a virtual machine hosted in Microsoft Azure. You need to ensure that each user of the database has a unique logi...

Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You...

You need to provision a new Microsoft Azure Database for PostgreSQL server database. Which two actions should you perform to create the database? Each correct answer presents a com...

You have an application named Appl that connects to a Microsoft Azure SQL database named AppDBl. Appl uses columnstore indexes as part of the database schema. You plan to deploy an...

You have a server named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 contains a database named DB1. You need to ensure that a user named User1 can query dynamic manageme...

Your company has an application that uses several Microsoft Azure SQL databases. New databases are added regularly as customers sign up for new services. Databases are removed regu...

Your company has a Microsoft Azure SQL database named OBI. You create an alert in DB1. You need to ensure that an Azure PowerShell script named alerts.psl runs when the alert is tr...

You have a Microsoft Azure virtual machine that has Microsoft SQL Server installed. The virtual machine contains five databases. You need to identify whether the performance of que...

You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine. You need to identify the most recent wait type for all of the currently running querie...

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

Your Microsoft Azure environment contains an elastic pool that has 2,000 eDTUs. The current available storage for the pool is 500 GB. At 10:00 each morning, the databases in the po...

Your company identifies a stored procedure that runs slowly. You review the execution plan for the stored procedure, and you discover the properties of a Clustered Index Scan opera...

You have a Microsoft Azure SQL database. Users report that queries to the database take longer than expected to complete. You need to identify the amount of CPU resources that the...

Your environment contains several Microsoft Azure SQL databases. You need to prevent inbound connections from the Internet to the databases when CPU utilization exceeds 90 percent....

Your environment contains several Microsoft Azure SQL databases. You need to execute Transact-SQL-based maintenance steps automatically against the databases. The execution must oc...

You are designing the database for a new application. The application will have 7,500 users located in New York and 2,500 users located in Paris. Users of the application will load...

You have a Microsoft Azure SQL database. You need to provide a copy of the database to an auditor. What should you do?

You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed. SQL1 has a critical database that contains online transaction data. The database...

You have an Azure SQL Database elastic database pool that contains two databases named database1 and database2. Users of database1 report poor performance during peak business hour...

You plan to migrate an on-premises database to Microsoft Azure. The planned deployment will include an Always On Failover Cluster Instance of Microsoft SQL Server. You need to impl...

You need to recommend a high-availability solution in Microsoft Azure that meets the following requirements: - Must host a distribution database. - Must be stored in the East US re...

You plan to deploy a highly available Microsoft SQL Server solution in Microsoft Azure to two virtual machines. Each virtual machine contains an OS disk and four data disks. You pl...

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