70-473 Practice Questions
96 real 70-473 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #76
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: -...
- Question #77
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...
- Question #78
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...
- Question #79
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...
- Question #80
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...
- Question #81
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...
- Question #82
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...
- Question #83
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...
- Question #84
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...
- Question #87
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...
- Question #89
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...
- Question #91
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...
- Question #92
You have a Microsoft Azure SQL database named DB1. You need to monitor DB1 to identity all regressed queries. Which command should you use?
- Question #93
You need to create a Microsoft Azure Resource manager template. Which file format should you use?
- Question #95
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...
- Question #96
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...
- Question #97
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...
- Question #98
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...
- Question #99
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...
- Question #100
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...
- Question #101
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...
- Question #102
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...
- Question #103
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...
- Question #104
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...
- Question #105
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...
- Question #106
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...
- Question #107
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...
- Question #108
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...
- Question #109
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...
- Question #110
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...
- Question #111
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...
- Question #112
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...
- Question #113
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...
- Question #114
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...
- Question #115
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....
- Question #116
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...
- Question #117
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...
- Question #118
You have a Microsoft Azure SQL database. You need to provide a copy of the database to an auditor. What should you do?
- Question #119
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...
- Question #120
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...
- Question #121
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...
- Question #122
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...
- Question #123
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...
- Question #133
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...
- Question #134
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...
- Question #135
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...