This page was exported from Braindump2go Free Exam Dumps with PDF and VCE Collection [ https://www.mcitpdump.com ] Export date:Fri Nov 22 6:44:02 2024 / +0000 GMT ___________________________________________________ Title: [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.html2.|2018 Latest 70-764 Exam Questions & Answers Download:https://drive.google.com/drive/folders/0B75b5xYLjSSNdlF6dzFQVE9kUjA?usp=sharingQUESTION 369Note: 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 resourcesWhat should you use?A. Activity MonitorB. sp_who3 stored procedureC. Object Explorer in SQL Server Management Studio (SSMS)D. SQL Server Data CollectorE. SQL Server Data Tools (SSDT)Answer: CQUESTION 370You 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 VolumesB. Microsoft Azure Blob storageC. Always On availability groupD. Stretch DatabaseAnswer: BQUESTION 371You 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: DQUESTION 372You 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 RESAMPLEB. UPDATE STATISTICS WITH FULLSCANC. UPDATE STATISTICS WITH SAMPLE 10 PERCENTD. UPDATE STATISTICS WITH NORECOMPUTEAnswer: CQUESTION 373You 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 groupsB. database mirroringC. transactional replicationD. log shippingAnswer: BQUESTION 374You 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: DEQUESTION 375Note: 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. YesB. NoAnswer: AQUESTION 376Note: 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. YesB. NOAnswer: BQUESTION 377Note: 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 instancesYou 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. YesB. NoAnswer: BQUESTION 378Note: 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. YesB. NoAnswer: BQUESTION 379Note: 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. YesB. NoAnswer: AQUESTION 380Note: 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. YesB. NoAnswer: B!!!RECOMMEND!!!1.|2018 Latest 70-764 Exam Dumps (VCE & PDF) 388Q&As Download:https://www.braindump2go.com/70-764.html2.|2018 Latest 70-764 Study Guide Video: YouTube Video: YouTube.com/watch?v=LI0KLVa-Qjg --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2018-10-19 08:39:59 Post date GMT: 2018-10-19 08:39:59 Post modified date: 2018-10-19 08:39:59 Post modified date GMT: 2018-10-19 08:39:59 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com