[29-Aug-2018 Update] Exam 70-473 VCE Dumps and 70-473 PDF Dumps from PassLeader

Valid 70-473 Dumps shared by PassLeader for Helping Passing 70-473 Exam! PassLeader now offer the newest 70-473 VCE dumps and 70-473 PDF dumps, the PassLeader 70-473 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader 70-473 dumps with VCE and PDF here: https://www.passleader.com/70-473.html (98 Q&As Dumps –> 135 Q&As Dumps)

BTW, DOWNLOAD part of PassLeader 70-473 dumps from Cloud Storage: https://drive.google.com/open?id=0B-ob6L_QjGLpMUdyRGNlS01WMjA

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 stays consistent when the data changes. What should you do?

A.    Update the statistics of all the tables in the database.
B.    Clear the procedure cache of the database.
C.    Run a consistency check on the tables in the database.
D.    Enable Extended Events for the server that contains the database.

Answer: C

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 reports are slow to display data. You create an index. You need to identify whether the performance of the reports significantly improves. Which tool should you use?

A.    SQL Server Profiler
B.    Query Store
C.    Database Engine Tuning Advisor
D.    Live Query Statistics

Answer: D

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 only DB1. What should you use?

A.    the sp_set_database_firewall_rule statement
B.    the New-AzureSqlDatabaseServerFirewallRule cmdlet
C.    the Azure portal to add an endpoint
D.    the Set-AzureSqlDtatabaseServerFirewallRule cmdlet

Answer: B

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 another Azure tenant. You need to ensure that the Web App can access the database. What should you do?

A.    Modify the SSL settings for the database server.
B.    Add an Azure virtual network gateway.
C.    Create a server-level firewall rule.
D.    Create a database-level firewall rule.

Answer: C

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 level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail. You need to implement a solution that provides disaster recovery for App1. In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed. What should you implement next?

A.    Merge Replication
B.    AlwaysOn Failover Cluster Instances
C.    AlwaysOn Availability Groups
D.    Log Shipping

Answer: D

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 has 10 file groups. You provision 10 disks for the instance. You need to recommend a storage solution that always provides the fastest possible reads for the database. What should you include in the recommendation?

A.    dynamic disks that use striping
B.    one file group per disk
C.    a storage space
D.    dynamic disks that use mirroring

Answer: C

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

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 the database. The solution must maintain data integrity. Which task should you include in the recommendation?

A.    Enable read caching.
B.    Move the transaction logs to the temporary drive.
C.    Enable read/write caching.
D.    Set the interleave size to 64 KB.

Answer: C

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 virtual machines. All of the virtual machines will be located on the same Azure virtual network. The SQL Server instances will be in an AlwaysOn availability group. You need to ensure that the web servers and the application servers can access the availability group listener by using a fully qualified domain name (FQDN) from the contoso.com domain. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

A.    Register a public DNS service on the Azure virtual network.
B.    Add a subnet to the Azure virtual network.
C.    Deploy a domain controller and join the virtual machines to the domain.
D.    Register a DNS server on the Azure virtual network.
E.    Use the Azure provided name resolution service.
F.    Deploy a DNS server.

Answer: ACF

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. Which two actions should perform? Each correct answer presents part of the solution. (Choose two.)

A.    Create an Azure virtual network.
B.    Enable a point-to-site VPN on the gateway.
C.    Install the Azure VPN client.
D.    Create a certificate.
E.    Create a private IP address.

Answer: DE

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 reduce the amount of time it takes to generate the reports. What should you do from the Azure portal?

A.    Increase the number of Database Throughput Units (DTUs).
B.    Add storage to the data warehouse.
C.    Increase the number of Data Warehouse Units (DWUs).

Answer: A

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 fail over to another Azure region automatically
Which two configuration tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

A.    Add the database to a failover group.
B.    Add the database to a database pool.
C.    Configure the database connection string to point to the endpoint of the read-write listener.
D.    Add the database to an AlwaysOn availability group that uses synchronous replication.
E.    Configure the database connection string to point to the endpoint of the primary replica.

Answer: AD

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

A.    XML
B.    text
C.    JSON
D.    binary

Answer: C


Get the newest PassLeader 70-473 VCE dumps here: https://www.passleader.com/70-473.html (98 Q&As Dumps –> 135 Q&As Dumps)

And, DOWNLOAD the newest PassLeader 70-473 PDF dumps from Cloud Storage for free: https://drive.google.com/open?id=0B-ob6L_QjGLpMUdyRGNlS01WMjA