[18-Oct-2018 Update] Exam 70-764 VCE Dumps and 70-764 PDF Dumps from PassLeader

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

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

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.    Activity Monitor
B.    sp_who3 stored procedure
C.    Object Explorer in SQL Server Management Studio (SSMS)
D.    SQL Server Data Collector
E.    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.    Cluster Shared Volumes
B.    Microsoft Azure Blob storage
C.    Always On availability group
D.    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?

A.    Set the value of the Database Read-Only property to True.
B.    Run the system stored procedure sp_updatestats.
C.    Set the value of the Auto Create Incremental Statistics property to True.
D.    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.    UPDATE STATISTICS WITH RESAMPLE
B.    UPDATE STATISTICS WITH FULLSCAN
C.    UPDATE STATISTICS WITH SAMPLE 10 PERCENT
D.    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.    Always On availability groups
B.    database mirroring
C.    transactional replication
D.    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.    Enable SQL Server Audit.
B.    Use Extended Events.
C.    Use a logon trigger.
D.    Create a SQL Server profile trace disable c2 audit tracing.
E.    Enable SQL Server Query Store.

Answer: DE

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?

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


Get the newest PassLeader 70-764 VCE dumps here: https://www.passleader.com/70-764.html (388 Q&As Dumps)

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