New VCE and PDF Exam Dumps from PassLeader
➢ Vendor: Microsoft ➢ Exam Code: 70-764 ➢ Exam Name: Administering a SQL Database Infrastructure ➢ New Questions (Oct/2018) Visit PassLeader and Download Full Version 70-764 Exam Dumps NEW QUESTION 369 You are examining information about users, sessions, and processes in an on-premises Microsoft SQL Server 2016 Standard Edition server. You need to identify waits for resources and return only the following information: - A list of all databases on the SQL Server instance, along with information about the database files, their paths, and names. - A list of the queries recently executed that use most of memory, disk, and network resources. What should you use? A. B. C. D. E.
Activity Monitor sp_who3 stored procedure Object Explorer in SQL Server Management Studio (SSMS) SQL Server Data Collector SQL Server Data Tools (SSDT)
Answer: C NEW QUESTION 370 You plan to implement a fault tolerance solution for a Microsoft SQL Server database. The solution must provide failover storage on the local network. You need to ensure that the solution can route traffic to failover storage by using SMB 3.0. Which storage option should you use? A. B. C. D.
Cluster Shared Volumes Microsoft Azure Blob storage Always On availability group Stretch Database
Answer: B NEW QUESTION 371 You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistics updates are disabled. Users report that some Microsoft SQL Server Reporting Service (SSRS) queries take a long time to run. You determine that the issue is caused by stale statistics for Index1. You need to update the statistics for the index. What should you do? 70-764 Exam Dumps
70-764 Exam Questions
70-764 PDF Dumps
https://www.passleader.com/70-764.html
70-764 VCE Dumps
New VCE and PDF Exam Dumps from PassLeader A. B. C. D.
Set the value of the Database Read-Only property to True. Run the system stored procedure sp_updatestats. Set the value of the Auto Create Incremental Statistics property to True. Run the UPDATE STATISTICS command with the COLUMNS option.
Answer: D NEW QUESTION 372 You have a table that has grown in the past six months. A user reports that queries against the table take a long time to complete. You need to update the statistics for the table in the least amount of time without disabling automatic statistics updates. Which Transact-SQL statement should you run? A. B. C. D.
UPDATE STATISTICS WITH RESAMPLE UPDATE STATISTICS WITH FULLSCAN UPDATE STATISTICS WITH SAMPLE 10 PERCENT UPDATE STATISTICS WITH NORECOMPUTE
Answer: C NEW QUESTION 373 You have five servers that run Microsoft SQL Server, Each server hosts multiple databases. You plan to implement fault tolerance. You need lo implement a fault tolerance solution that meets the following requirements: - Each database must use a separate fault tolerance configuration. - The solution must support three or more copies of each database. - Failover of database must be automatic. What should you do use? A. B. C. D.
Always On availability groups database mirroring transactional replication log shipping
Answer: B NEW QUESTION 374 You have a Microsoft SQL Server instance that has database named DBI. The database is used purposes,. You plan to capture all queries for a specific table and save the data as a text file. You need to ensure that queries are captured and that a failure to capture a query will shut the SQL Server instance. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.) A. B. C. D. E.
Enable SQL Server Audit. Use Extended Events. Use a logon trigger. Create a SQL Server profile trace disable c2 audit tracing. Enable SQL Server Query Store.
Answer: DE 70-764 Exam Dumps
70-764 Exam Questions
70-764 PDF Dumps
https://www.passleader.com/70-764.html
70-764 VCE Dumps
New VCE and PDF Exam Dumps from PassLeader NEW QUESTION 375 Your company has several Microsoft SQL Saver instance. Each instance hosts many database. You observe I/O corruption on some of the instance. You need to perform the following actions: - Identify databases where the PAGE verity option is not set. - Configure full page protection for the identified databases. Solution: You run the following Transact-SQL statement: SELECT NAME, page_verify_option_desc FROM master.sys.databases WHERE page_verify_option_desc != ‘CHECKSUM’ GO For each database that you identify, you run the following Transact SQL statement: ALTER DATABASE <database_name> SET PAGE_VERIFT CHECKSUM Does the solution meet the goal? A. Yes B. No Answer: A NEW QUESTION 376 Your company has several Microsoft SOI Server instances. Each instance hosts many databases. You observe I/O corruption on some of the instances. You need to perform the following actions: - Identify databases where the PAGE VERIFY option is not set. - Configure full page protection for the identified databases. Solution: You run the following Transact-SQL statement: SELECT NAME, page_verify_option_desc FROM master.sys.databases WHERE page_verify_option_desc != ‘TORN_PAGE_DETECTION’ GO For each database that you identify, you run the following Transact-SQL statement: ALTER DATABASE <database_name> SET PAGE_VERIFT TORN_PAGE_DETECTION Does the solution meet the goal? A. Yes B. No Answer: B NEW QUESTION 377 Your company has several Microsoft SQL Server instances, Each instance hosts many databases. You observe I/O corruption on some of the instances. You need to perform the following actions: - Identify databases where the PAGE VERIFY option is not set - Configure full page protection for the identified databases. Solution: You run the following Transact-SQL statement: SELECT NAME, page_verify_option_desc FROM master.sys.databases WHERE page_verify_option_desc = ‘NONE’ GO For each database that you identify, you run the following Transact-SQL statement: ALTER DATABASE <database_name> SET PAGE_VERIFT TORN_PAGE_DETECTION Does the solution meet the goal? 70-764 Exam Dumps
70-764 Exam Questions
70-764 PDF Dumps
https://www.passleader.com/70-764.html
70-764 VCE Dumps
New VCE and PDF Exam Dumps from PassLeader A. Yes B. No Answer: B NEW QUESTION 378 You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process. Solution: You configure log shipping to backup and restore by using shared folder. Does this meet the goal? A. Yes B. No Answer: B NEW QUESTION 379 You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process. Solution: You enable compression for the transaction log backups. Does this meet the goal? A. Yes B. No Answer: A NEW QUESTION 380 You have a database named DB1 that is 640 GB and is updated frequently. You enabled log shipping for DB1 and configure backup and restore to occur every 30 minutes. You discover that the disks on the data server are almost full. You need to reduce the amount of disk space used by the log shipping process. Solution: You increase the frequency of the transaction log backups to every 10 minutes. Does this meet the goal? A. Yes B. No Answer: B NEW QUESTION 381 ......
Visit PassLeader and Download Full Version 70-764 Exam Dumps
70-764 Exam Dumps
70-764 Exam Questions
70-764 PDF Dumps
https://www.passleader.com/70-764.html
70-764 VCE Dumps