70-764 Exam Dumps | You administer a Microsoft SQL Server 2016 Enterprise Edition server that uses 64 cores. You discover

<< Prev Question Next Question >>

Question 37/238

You administer a Microsoft SQL Server 2016 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?

A. Processor affinity

B. Lightweight pooling

C. Max worker threads

D. I/O affinity

Question List (238q): Question 1: Note: This question is part of a series of questions that us...; Question 2: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 3: You work as a Database Administrator (DBA) for a company nam...; Question 4: You install Microsoft SQL Server 2016 on a new server. After...; Question 5: Note: This question is part of a series of questions that us...; Question 6: Note: This question is part of a series of questions that pr...; Question 7: You work as a Developer at ABC.com. All databases are hosted...; Question 8: You administer a Microsoft SQL Server 2016 database instance...; Question 9: Note: This question is part of a series of questions that pr...; Question 10: You need to address the requirements for disc usage monitori...; Question 11: You plan to install a Microsoft SQL Server 2016 instance. Th...; Question 12: You administer a Microsoft SQL Server 2016 database named Or...; Question 13: You administer a single server that contains a Microsoft SQL...; Question 14: You create an availability group that has replicas named HA/...; Question 15: You are using dynamic management views to monitor an SQL Ser...; Question 16: You have a SQL Server instance on a server named Server1. Yo...; Question 17: Note: This question is part of a series of questions that pr...; Question 18: You administer a Microsoft SQL Server 2016 database named Co...; Question 19: Overview You are a database administrator for a company name...; Question 20: Overview You are a database administrator for a company name...; Question 21: Overview You are a database administrator for a company name...; Question 22: Note: This question is part of a series of questions that pr...; Question 23: You want to reproduce the same SQL Server 2016 installation ...; Question 24: You have a database hosted on SQL Server 2012 R2. The databa...; Question 25: You administer a Microsoft SQL Server 2016 environment. One ...; Question 26: You have a database that stores information for a shipping c...; Question 27: Note: This question is part of a series of questions that pr...; Question 28: Note: This question is part of a series of questions that pr...; Question 29: You have a server named Server1 that has 2 processors. You p...; Question 30: Note: This question is part of a series of questions that pr...; Question 31: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 32: You have a database named DB1. Users report that a database ...; Question 33: General Overview You are the Senior Database Administrator (...; Question 34: Note: This question is part of a series of questions that us...; Question 35: Note: This question is part of a series of questions that us...; Question 36: You administer a Microsoft SQL Server 2016 server. One of th...; Question 37: You administer a Microsoft SQL Server 2016 Enterprise Editio...; Question 38: You have a SQL Server 2014 instance named SQL1. SQL1 creates...; Question 39: You work as a Database Administrator (DBA) for a company nam...; Question 40: You plan to install Microsoft SQL Server 2016 for a web host...; Question 41: You work as a Database Administrator (DBA) for a company nam...; Question 42: You administer a Microsoft SQL Server 2016 database named Co...; Question 43: You need to grant access to an OLTP database regardless of t...; Question 44: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 45: A company has an on-premises Microsoft SQL Server environmen...; Question 46: You need to move a database in between servers. You need to ...; Question 47: Overview Application Overview Contoso, Ltd., is the develope...; Question 48: You administer a Microsoft SQL Server 2016 database that has...; Question 49: You are troubleshooting an application that runs a query. Th...; Question 50: You have a customer who has several SQL Server 2012 database...; Question 51: You administer a Microsoft SQL Server 2016 server. You plan ...; Question 52: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 53: You manage database servers in a high security environment. ...; Question 54: Overview You are a database administrator for a company name...; Question 55: Note: This question is part of a series of questions that us...; Question 56: Note: This question is part of a series of questions that pr...; Question 57: Note: This question is part of a series of questions that us...; Question 58: You administer a Microsoft SQL Server 2016 default instance....; Question 59: You are creating a database that will store usernames and cr...; Question 60: You need to recommend a solution to meet the recovery requir...; Question 61: You administer a Microsoft SQL Server 2016 database. You hav...; Question 62: Overview You are a database administrator for a company name...; Question 63: You work as a Database Administrator (DBA) for a company nam...; Question 64: You have four databases that are accessed by using an Online...; Question 65: You create a stored procedure that retrieves all of the rows...; Question 66: You install a Microsoft SQL Server 2016 instance. The instan...; Question 67: You administer a Microsoft SQL Server 2016 server. When tran...; Question 68: You create an availability group named HaContoso that has re...; Question 69: You administer a Microsoft SQL Server 2016 database named Co...; Question 70: Overview Application Overview Contoso, Ltd., is the develope...; Question 71: You have a SQL Server 2014 environment That contains 20 serv...; Question 72: You have a SQL Server 2012 database named DB1. You have a ba...; Question 73: You administer a Microsoft SQL Server 2016 database instance...; Question 74: You are a database administrator for a Microsoft SQL Server ...; Question 75: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 76: You manage a SQL Server 2014 instance that contains a databa...; Question 77: Note: This question is part of a series of questions that us...; Question 78: Which feature should you enable and configure so session req...; Question 79: You work as a Database Administrator (DBA) for a company nam...; Question 80: Note: This question is part of a series of questions that us...; Question 81: You administer several Microsoft SQL Server 2016 database se...; Question 82: You are the administrator of a Microsoft SQL Server 2016 ser...; Question 83: Note: This question is part of a series of questions that pr...; Question 84: You administer a Microsoft SQL Server 2016 instance. You nee...; Question 85: You deploy a SQL Server instance named SQLProd that uses SQL...; Question 86: You administer all the deployments of Microsoft SQL Server 2...; Question 87: You manage a Microsoft SQL Server environment. You plan to e...; Question 88: You work as a Database Administrator (DBA) at ABC.com. All d...; Question 89: General Overview You are the Senior Database Administrator (...; Question 90: You have a database named DB1 that is configured to use the ...; Question 91: You administer all the deployments of Microsoft SQL Server 2...; Question 92: Note: This question is part of a series of questions that pr...; Question 93: You administer a Microsoft SQL Server 2016 server that hosts...; Question 94: Overview You are a database administrator for a company name...; Question 95: Note: This question is part of a series of questions that us...; Question 96: You are building a stored procedure for a SQL Azure database...; Question 97: Which feature should you enable and configure so session req...; Question 98: You work as a Database Administrator (DBA) for a company nam...; Question 99: You administer a Microsoft SQL Server 2016 failover cluster....; Question 100: You administer a Microsoft SQL Server 2016 database that con...; Question 101: You administer a Microsoft SQL Server 2016 database. The dat...; Question 102: You administer two instances of Microsoft SQL Server 2016. Y...; Question 103: You are troubleshooting an application that runs a query. Th...; Question 104: You work as a Database Administrator (DBA) for a company nam...; Question 105: Note: This question is part of a series of questions that pr...; Question 106: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 107: Note: This question is part of a series of questions that pr...; Question 108: You administer a Windows Azure SQL Database database named H...; Question 109: You have a query that is used by a reporting dashboard. User...; Question 110: You administer a Microsoft SQL Server 2016 database named Co...; Question 111: You have two databases named DB1 and DB2 that are located on...; Question 112: Note: This question is part of a series of questions that pr...; Question 113: Note: This question is part of a series of questions that us...; Question 114: Note: This question is part of a series of questions that us...; Question 115: You administer a Microsoft SQL Server 2016 database named Co...; Question 116: You use SQL Server 2014 to maintain the data used by applica...; Question 117: Overview You are a database administrator for a company name...; Question 118: You are the administrator for a SQL Server 2014 instance tha...; Question 119: You plan to integrate an on-premises Microsoft SQL Server en...; Question 120: You are the new database administrator for a SQL Server 2014...; Question 121: Your company has offices in Seattle and Montreal. The networ...; Question 122: You have two SQL Server instances named SQLDev and SQLProd t...; Question 123: You have an SQL Server 2014 server named SQL1. You are desig...; Question 124: You administer a Microsoft SQL Server 2016 instance that has...; Question 125: You administer a Microsoft SQL Server 2016 instance. You dis...; Question 126: General Overview You are the Senior Database Administrator (...; Question 127: You are designing a Windows Azure SQL Database for an order ...; Question 128: General Overview You are the Senior Database Administrator (...; Question 129: You administer all the deployments of Microsoft SQL Server 2...; Question 130: Overview Application Overview Contoso, Ltd., is the develope...; Question 131: You deploy a database by using SQL Server 2012. The database...; Question 132: You use SQL Azure to store data used by an e-commerce applic...; Question 133: You are a database administrator at Contoso, Ltd. You are pr...; Question 134: General Overview You are the Senior Database Administrator (...; Question 135: You administer all the deployments of Microsoft SQL Server 2...; Question 136: Note: This question is part of a series of questions that pr...; Question 137: Overview Application Overview Contoso, Ltd., is the develope...; Question 138: Note: This question is part of a series of questions that us...; Question 139: Note: This question is part of a series of questions that pr...; Question 140: You administer a Microsoft SQL Server 2016 database named Co...; Question 141: You are planning on deploying a server that will be dedicate...; Question 142: Note: This question is part of a series of questions that pr...; Question 143: You need to address the Sales Director's requirements regard...; Question 144: You are designing a SQL Server database for an order fulfill...; Question 145: General Overview You are the Senior Database Administrator (...; Question 146: You administer a Microsoft SQL Server 2016 server that hosts...; Question 147: You are a database administrator for a Microsoft SQL Server ...; Question 148: You administer a Microsoft SQL Server 2016 instance. The ins...; Question 149: General Overview You are the Senior Database Administrator (...; Question 150: Overview Application Overview Contoso, Ltd., is the develope...; Question 151: Note: This question is part of a series of questions that us...; Question 152: You use a contained database named ContosoDb within a domain...; Question 153: You administer a Microsoft SQL Server 2016 database that con...; Question 154: You manage a Microsoft SQL Server environment. You plan to c...; Question 155: You work as a Database Administrator (DBA) at ABC.com. You a...; Question 156: You are migrating a database named Orders to a new server th...; Question 157: You administer a Microsoft SQL Server 2016 database. You nee...; Question 158: You administer a Microsoft SQL Server 2016 database named Co...; Question 159: You are creating an application that will connect to the Age...; Question 160: You administer a Microsoft SQL Server database named Sales. ...; Question 161: General Overview You are the Senior Database Administrator (...; Question 162: You work as a Developer at ABC.com. All databases are hosted...; Question 163: You administer a Microsoft SQL Server 2016 instance that has...; Question 164: Note: This question is part of a series of questions that pr...; Question 165: Note: This question is part of a series of questions that pr...; Question 166: You have a database named DB1. You plan to create a stored p...; Question 167: You administer a Microsoft SQL Server 2016 database that inc...; Question 168: Note: This question is part of a series of questions that pr...; Question 169: You administer a Microsoft SQL Server 2016 database. The dat...; Question 170: You administer a Microsoft SQL Server 2016 database. Users r...; Question 171: You are designing a database named DB1. Changes will be depl...; Question 172: You want to simulate read, write, checkpoint, backup, sort, ...; Question 173: You have a SQL Server 2014 environment That includes four se...; Question 175: Note: This question is part of a series of questions that us...; Question 176: You plan to create a database. The database will be used by ...; Question 177: You have a server named Server1 that has 16 processors. You ...; Question 178: You administer a Microsoft SQL Server 2016 server that hosts...; Question 179: You are designing a monitoring application for a new SQL Ser...; Question 180: You administer a Microsoft SQL Server 2016 database. You pro...; Question 181: Your company has offices in Seattle and Montreal. The networ...; Question 182: Your company has a SQL Azure subscription. You implement a d...; Question 183: You administer a Microsoft SQL Server 2016 server. The MSSQL...; Question 184: You work as a Database Administrator (DBA) for a company nam...; Question 185: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 186: You are the lead database administrator (DBA) of a Microsoft...; Question 187: You have two SQL Server 2012 instances named SQLDev and SQLP...; Question 188: Note: This question is part of a series of questions that us...; Question 189: You administer a Microsoft SQL Server 2016 database. Users r...; Question 190: Note: This question is part of a series of questions that pr...; Question 191: You manage a Microsoft SQL Server environment. You plan to e...; Question 192: You have a database named DB1 that contains two tables. You ...; Question 193: Note: This question is part of a series of questions that us...; Question 194: You need to validate rows before they are added to a table e...; Question 195: You administer a Windows Azure SQL Database database named I...; Question 196: Note: This question is part of a series of questions that pr...; Question 197: You need to ensure that a stored procedure fails if an INSER...; Question 198: Overview You are a database administrator for a company name...; Question 199: You have a server that has SQL Server 2014 installed. The se...; Question 200: You have a database that stores information for a shipping c...; Question 201: You administer a Microsoft SQL Server 2016 database that inc...; Question 202: You administer a Microsoft SQL Server 2016 server that has S...; Question 203: You administer a Microsoft SQL Server 2016 database. You wan...; Question 204: You have 10 Microsoft SQL Server 2016 servers. You deploy a ...; Question 205: Note: This question is part of a series of questions that us...; Question 206: Note: This question is part of a series of questions that us...; Question 207: Note: This question is part of a series of questions that us...; Question 208: Overview You are a database administrator for a company name...; Question 209: You have a database named DB1 that stores more than 700 giga...; Question 210: Note: This question is part of a series of questions that us...; Question 211: You administer a Microsoft SQL Server 2016 instance. After a...; Question 212: Overview You are a database administrator for a company name...; Question 213: You administer a SQL Server 2016 database instance. You need...; Question 214: Your company stored customer data, including credit card num...; Question 215: Note: This question is part of a series of questions that pr...; Question 216: You work as a Database Administrator (DBA) for a company nam...; Question 217: You plan to create a database. The database will be used by ...; Question 218: Note: This question is part of a series of questions that us...; Question 219: You administer a Microsoft SQL Server 2016 database that has...; Question 220: You are implementing a SQL Server 2016 five-node failover cl...; Question 221: General Overview You are the Senior Database Administrator (...; Question 222: You have configured Resource Governor with three resource po...; Question 223: You administer two Microsoft SQL Server 2016 servers named P...; Question 224: You administer a Microsoft SQL Server 2012 instance. You nee...; Question 225: You administer a Microsoft SQL Server 2016 instance that con...; Question 226: You work as a Database Administrator (DBA) for a company nam...; Question 227: Background Corporate Information Fabrikam, Inc. is a retaile...; Question 228: You administer a SQL Server 2014 instance. Users report that...; Question 229: You deploy a database by using SQL Server 2014. The database...; Question 230: You administer two Microsoft SQL Server 2012 servers. Each s...; Question 231: Note: This question is part of a series of questions that pr...; Question 232: Your network contains an Active Directory domain that has tw...; Question 233: You have a SQL Server 2012 database named DB1. You plan to i...; Question 234: You plan to migrate the db to azure. You verify that all obj...; Question 235: You are creating a database that will store usernames and pa...; Question 236: Overview Application Overview Contoso, Ltd., is the develope...; Question 237: You administer a single server that contains a Microsoft SQL...; Question 238: A Microsoft SQL Server database named DB1 has two filegroups...

Question 37/238

LEAVE A REPLY

Download PDF File