[70-764 Dumps]Braindump2go 70-764 Exam Dumps 388Q Free Offer[Q369-Q380]

2018-10-19 Braindump2go 70-764 Exam Dumps with PDF and VCE New Updated Today! Folloiwng are some new 70-764 Real Exam Questions:

1.|2018 Latest 70-764 Exam Dumps (VCE & PDF) 388Q&As Download:

https://www.braindump2go.com/70-764.html

2.|2018 Latest 70-764 Exam Questions & Answers Download:

QUESTION 369
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the scries. Each question is independent of the other questions in this scries. Information and details provided in a question apply only to that question.
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

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

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

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

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

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.
NOPTE: Each correct selection is worth one point.

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

QUESTION 375
Note: This question is part of a series of question that present the same scenario. Each question in the series contains I unique solution that might meet the stated goals Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it As a result, these questions will not appear in the review screen.
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:

For each database that you identify, you run the following Transact SQL statement:

Does the solution meet the goal?

A. Yes
B. No

Answer: A

QUESTION 376
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 question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
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:

For each database that you identify, you run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. NO

Answer: B

QUESTION 377
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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.
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:

For each database that you identify, you run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. No

Answer: B

QUESTION 378
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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.
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

QUESTION 379
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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.
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

QUESTION 380
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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen.
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

1.|2018 Latest 70-764 Exam Dumps (VCE & PDF) 388Q&As Download:

https://www.braindump2go.com/70-764.html

2.|2018 Latest 70-764 Study Guide Video: