Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
Access 70-765 Dumps Premium Version
(268 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 86/108
You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.
You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.
You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process.
Which Transact-SQL batch should you use?
ALTER INDEX IDX_AccountTransaction_AccountCode ON
You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.
You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process.
Which Transact-SQL batch should you use?
ALTER INDEX IDX_AccountTransaction_AccountCode ON
Correct Answer: A
Explanation/Reference:
Explanation:
Reorganize: This option is more lightweight compared to rebuild. It runs through the leaf level of the index, and as it goes it fixes physical ordering of pages and also compacts pages to apply any previously set fillfactor settings. This operation is always online, and if you cancel it then it's able to just stop where it is (it doesn't have a giant operation to rollback).
References: https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Explanation:
Reorganize: This option is more lightweight compared to rebuild. It runs through the leaf level of the index, and as it goes it fixes physical ordering of pages and also compacts pages to apply any previously set fillfactor settings. This operation is always online, and if you cancel it then it's able to just stop where it is (it doesn't have a giant operation to rollback).
References: https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
- Question List (108q)
- Question 1: You have a database named DB1 that contains a table named Ta...
- Question 2: You administer a Microsoft SQL Server 2012 database. You con...
- Question 3: Note: This question is part of a series of questions that pr...
- Question 4: Note: This question is part of a series of questions that pr...
- Question 5: You are the database administrator for your company. Your co...
- Question 6: You plan to deploy Microsoft SQL Server on a Microsoft Azure...
- Question 7: You have the databases configured as shown in the following ...
- Question 8: Note: This question is part of a series of questions that pr...
- Question 9: Note: This question is part of a series of questions that pr...
- Question 10: You create a new Microsoft Azure subscription. You need to c...
- Question 11: Note: This question is part of a series of questions that pr...
- Question 12: You administer a Microsoft SQL Server 2012 database instance...
- Question 13: You plan to deploy an AlwaysOn failover cluster in Microsoft...
- Question 14: You have a database named DB1. You discover that DB1 is corr...
- Question 15: Note: This question is part of a series of questions that pr...
- Question 16: Note: This question is part of a series of questions that pr...
- Question 17: You plan to create an AlwaysOn availability group that will ...
- Question 18: Note: This question is part of a series of questions that pr...
- Question 19: Note: This question is part of a series of questions that pr...
- Question 20: You have an on-premises SQL Server database named DB1 that c...
- Question 21: You plan to deploy an on-premises SQL Server 2014 database t...
- Question 22: You need to create an Elastic Database job to rebuild indexe...
- Question 23: A company has an on-premises Microsoft SQL Server 2017 infra...
- Question 24: Note: This question is part of a series of questions that pr...
- Question 25: You have a Microsoft Azure SQL database in the US West regio...
- Question 26: You manage a Microsoft SQL Server environment in a Microsoft...
- Question 27: You have Microsoft SQL Server on a Microsoft Azure Virtual m...
- Question 28: User report that a query takes a long time to execute. The q...
- Question 29: You administer a Microsoft SQL Server 2012 database named Co...
- Question 30: You administer a Microsoft SQL Server 2012 instance named SQ...
- Question 31: You administer a Microsoft SQL Server 2012 Enterprise Editio...
- Question 32: You manage an on-premises, multi-tier application that has t...
- Question 33: You administer a Microsoft SQL Server database named Sales. ...
- Question 34: Note: This question is part of a series of questions that pr...
- Question 35: Note: This question is part of a series of questions that pr...
- Question 36: Note: This question is part of a series of questions that pr...
- Question 37: You have Microsoft SQL server on a Microsoft Azure virtual m...
- Question 38: You administer a Microsoft SQL Server 2012 database. You hav...
- Question 39: Note: This question is part of a series of questions that pr...
- Question 40: You are the administrator for a SQL Server 2016 instance tha...
- Question 41: Note: This question is part of a series of questions that pr...
- Question 42: You have Microsoft SQL Server on a DS-series Microsoft Azure...
- Question 43: You deploy a new Microsoft Azure SQL Database instance to su...
- Question 44: Note: This question is part of a series of questions that pr...
- Question 45: You plan to install Microsoft SQL Server 2012 for a web host...
- Question 46: You administer a Windows Azure SQL Database database named O...
- Question 47: You plan to deploy Microsoft SQL Server on a Microsoft Azure...
- Question 48: You have a database named DB1 that uses simple recovery mode...
- Question 49: Note: This question is part of a series of questions that pr...
- Question 50: Note: This question is part of a series of questions that pr...
- Question 51: Note: This question is part of a series of questions that pr...
- Question 52: You are the database administrator in your company. You plan...
- Question 53: Note: This question is part of a series of questions that pr...
- Question 54: Note: This question is part of a series of questions that pr...
- Question 55: You administer a Microsoft SQL Server 2012 instance that has...
- Question 56: Note: This question is part of a series of questions that us...
- Question 57: Note: This question is part of a series of questions that pr...
- Question 58: You administer a Windows 2008 server hosting an instance of ...
- Question 59: You administer a Microsoft SQL Server 2012 server. You plan ...
- Question 60: Note: This question is part of a series of questions that pr...
- Question 61: You have Microsoft SQL Server on a Microsoft Azure virtual m...
- Question 62: You have an on-premises Microsoft SQL server that has a data...
- Question 63: You have a SQL Server 2016 database named DB1. You plan to i...
- Question 64: Note: This question is part of a series of questions that pr...
- Question 65: You administer a Microsoft SQL Server 2012 instance. The ins...
- Question 66: You have Microsoft SQL Server on a Microsoft Azure virtual m...
- Question 67: Note: This question is part of a series of questions that pr...
- Question 68: You are migrating an on-premises Microsoft SQL Server instan...
- Question 69: You have a server named Serverl that is hosted in an Azure v...
- Question 70: A company hosts a default installation of Microsoft SQL Serv...
- Question 71: Note: This question is part of a series of questions that pr...
- Question 72: You manage a Microsoft SQL Server instance named SQL1 that h...
- Question 73: Note: This question is part of a series of questions that pr...
- Question 74: You administer a Microsoft SQL Server 2012 instance that has...
- Question 75: Note: This question is part of a series of questions that pr...
- Question 76: You create an availability group that has replicas named HA/...
- Question 77: A company has an on-premises Microsoft SQL Server 2014 envir...
- Question 78: You manage an on-premises Microsoft SQL server that has a da...
- Question 79: Note: This question is part of a series of questions that pr...
- Question 80: You have a single-server on-premises Microsoft SQL Server de...
- Question 81: You are developing customized Microsoft Azure Resource Group...
- Question 82: You use a Microsoft SQL Server 2012 database that contains t...
- Question 83: You have a database named DB1that contains a table named Tab...
- Question 84: Note: This question is part of a series of questions that pr...
- Question 85: You administer a Microsoft SQL Server 2012 database that con...
- Question 86: You administer a Microsoft SQL Server 2012 database that con...
- Question 87: You have an on-premises server that runs Windows Server 2012...
- Question 88: You have Microsoft SQL Server on a Microsoft Azure Virtual m...
- Question 89: You administer a Microsoft SQL Server 2012 database named Co...
- Question 90: You administer a Microsoft SQL Server 2012 database. The dat...
- Question 91: A company plans to run Microsoft SQL Server on Linux-based s...
- Question 92: You have an on-premises Microsoft SQL server that has a data...
- Question 93: You administer all the deployments of Microsoft SQL Server 2...
- Question 94: Note: This question is part of a series of questions that pr...
- Question 95: You administer a Microsoft SQL Server 2012 server. One of th...
- Question 96: You are deploying a Microsoft SQL Server database that will ...
- Question 97: A company runs Microsoft SQL Server 2017 in an on-premises e...
- Question 98: You have a database named DB1 that is 3 TB. DB1 contains a f...
- Question 99: You plan to migrate on-premises Microsoft SQL Server databas...
- Question 100: You administer a Microsoft SQL Server database. You need to ...
- Question 101: You have a Microsoft Azure SQL Database instance named Sales...
- Question 102: You use Microsoft Azure Resource Manager to deploy two new M...
- Question 103: You administer a Microsoft SQL Server 2012 environment. One ...
- Question 104: You administer a Microsoft SQL Server 2012 database named Or...
- Question 105: You have a server named server1-contoso.database.windows.net...
- Question 106: Note: This question is part of a series of questions that us...
- Question 107: You have Microsoft SQL Server on a Microsoft Azure virtual m...
- Question 108: Note: This question is part of a series of questions that pr...
