- Home
- Microsoft
- Administering Microsoft SQL Server 2012/2014 Databases
- Microsoft.70-462.v2018-10-08.q183
- Question 102
Valid 70-462 Dumps shared by ExamDiscuss.com for Helping Passing 70-462 Exam! ExamDiscuss.com now offer the newest 70-462 exam dumps, the ExamDiscuss.com 70-462 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-462 dumps with Test Engine here:
Access 70-462 Dumps Premium Version
(305 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 102/183
You are a database administrator for a Microsoft SQL Server database named AdventureWorks2012.
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
Production transactions should be minimally affected.
The secondary server should allow reporting queries to be performed.
If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
A:
B:
C:
D:
You create an Availability Group defined by the following schema. (Line numbers are included for reference only.)
You need to implement an AlwaysOnAvailablity Group that will meet the following conditions:
Production transactions should be minimally affected.
The secondary server should allow reporting queries to be performed.
If the primary server goes offline, the secondary server should not automatically take over.
Which Transact-SQL statement should you insert at line 06?
A:
B:
C:
D:
Correct Answer: C
Explanation/Reference:
Explanation:
How correctly configure AlwaysOn readable secondary replica:
1. Add Application Intent in the connection string by adding: ;ApplicationIntent=ReadOnly
2. ALLOW_CONNECTIONS property of the secondary replica is READ_ONLY.
3. The READ_ONLY_ROUTING_URL for each replica is set. The TCP port is a port number that is used by the Database Engine of the SQL Server instance alteravailabilitygroupmyGroupName modifyreplicaon'myMachine1instanceName1'with (secondary_role(read_only_routing_url='tcp://myMachine1:1433'))
References: https://msdn.microsoft.com/en-us/library/hh213002.aspx
https://blogs.technet.microsoft.com/mdegre/2013/03/20/how-configure-correctly-alwayson-readable- secondary-replica-for-applicationintent/
Explanation:
How correctly configure AlwaysOn readable secondary replica:
1. Add Application Intent in the connection string by adding: ;ApplicationIntent=ReadOnly
2. ALLOW_CONNECTIONS property of the secondary replica is READ_ONLY.
3. The READ_ONLY_ROUTING_URL for each replica is set. The TCP port is a port number that is used by the Database Engine of the SQL Server instance alteravailabilitygroupmyGroupName modifyreplicaon'myMachine1instanceName1'with (secondary_role(read_only_routing_url='tcp://myMachine1:1433'))
References: https://msdn.microsoft.com/en-us/library/hh213002.aspx
https://blogs.technet.microsoft.com/mdegre/2013/03/20/how-configure-correctly-alwayson-readable- secondary-replica-for-applicationintent/
- Question List (183q)
- Question 1: You administer a Microsoft SQL Server database that includes...
- Question 2: Which of the following transaction safety setting in SQL Ser...
- Question 3: Which of the following statements will set the maximum amoun...
- Question 4: Which of the following statements will create an index calle...
- Question 5: Which of the following permissions must a user have in order...
- Question 6: You administer a Microsoft SQL Server 2012 database. You hav...
- Question 7: You administer a Microsoft SQL Server 2012 Enterprise Editio...
- Question 8: Which of the following is NOT a database role that you can a...
- Question 9: You administer a Microsoft SQL Server instance. The instance...
- Question 10: If you are restoring and recovering a database, which of the...
- Question 11: Which feature should you enable and configure so session req...
- Question 12: Note: This question is part of a series of questions that us...
- Question 13: You administer a Microsoft SQL Server 2012 instance named SQ...
- Question 14: You use Microsoft SQL Server 2012 to write code for a transa...
- Question 15: You administer a Microsoft SQL Server failover cluster. You ...
- Question 16: You administer a Microsoft SQL Server failover cluster that ...
- Question 17: You create an availability group that has replicas named HA/...
- Question 18: Every SQL Server 2012 database must have a datafile and whic...
- Question 19: You are implementing a SQL Server five-node failover cluster...
- Question 20: Which of the following SQL Server 2012 indexes is ordered in...
- Question 21: You are the data steward for a Business Intelligence project...
- Question 22: You administer a Microsoft SQL Server 2012 Enterprise Editio...
- Question 23: You have an index called Employee_IDX on the table Employees...
- Question 24: You administer a Microsoft SQL Server 2012 environment. One ...
- Question 25: Which of the following SQL Server 2012 features generates nu...
- Question 26: You administer a Microsoft SQL Server 2012 database. The dat...
- Question 27: Note: This question is part of a series of questions that us...
- Question 28: You administer a Microsoft SQL Server database instance. You...
- Question 29: You have a SQL Server instance that uses database roles. The...
- Question 30: Which of the following is the default port for an SQL Server...
- Question 31: You administer a Microsoft SQL Server database. You need to ...
- Question 32: Note: This question is part of a series of questions that us...
- Question 33: You have a SQL Server database named DB1. You plan to load 1...
- Question 34: You administer a Microsoft Azure SQL Database database named...
- Question 35: You administer a Microsoft Azure SQL Database database named...
- Question 36: You administer a SQL Server 2012 database instance. You need...
- Question 37: You administer a Microsoft SQL Server database server. When ...
- Question 38: You administer all the deployments of Microsoft SQL Server 2...
- Question 39: You want to simulate read, write, checkpoint, backup, sort, ...
- Question 40: Which of the following is a valid data source which you can ...
- Question 41: You use a contained database named ContosoDb within a domain...
- Question 42: You administer a Microsoft SQL Server 2012 database named Co...
- Question 43: Which of the following files keeps track of all transactions...
- Question 44: Which of the following is a disaster recovery solution offer...
- Question 45: On which of the following operating systems can you deploy t...
- Question 46: Which of the following is NOT a potential Cluster resource w...
- Question 47: You administer a Microsoft SQL Server 2012 database named Co...
- Question 48: You are creating a SQL Server Master Data Services (MDS) mod...
- Question 49: Which of the following SQL Server 2012 tools coordinates tra...
- Question 50: You administer a Microsoft SQL Server server. You plan to de...
- Question 51: You administer a SQL Server 2012 server that contains a data...
- Question 52: You administer a Microsoft SQL Server 2012 database that con...
- Question 53: Which of the following recovery models must be in use for po...
- Question 54: You administer a Microsoft SQL Server instance. You need to ...
- Question 55: You administer a Microsoft SQL Server 2012 database. Users r...
- Question 56: DRAG DROP You administer a Microsoft SQL Server database tha...
- Question 57: Before moving an SQL Server 2012 database file to a new loca...
- Question 58: Which of the following SQL Server 2012 tools assists DBAs in...
- Question 59: You administer a Microsoft SQL Server environment. One of th...
- Question 60: Which of the following is required in order for a differenti...
- Question 61: You administer a Microsoft Azure SQL Database database named...
- Question 62: You manage a server that has SQL Server installed and hosts ...
- Question 63: You administer a Microsoft SQL Server environment. The envir...
- Question 64: You are a database administrator for a Microsoft SQL Server ...
- Question 65: Which of the following is the default file extension for an ...
- Question 66: You want to reproduce the same SQL Server 2012 installation ...
- Question 67: You administer a Microsoft SQL Server environment. You purch...
- Question 68: Which of the following is a high availability feature with S...
- Question 69: You administer a Microsoft SQL Server 2012 instance that has...
- Question 70: You administer two Microsoft SQL Server 2012 servers named P...
- Question 71: Which of the following SQL Server 2012 database is NOT creat...
- Question 72: You are a database administrator for a Microsoft SQL Server ...
- Question 73: You are the senior database administrator for a Microsoft SQ...
- Question 74: You administer a Microsoft SQL Server instance that contains...
- Question 75: You are designing a SQL Server Integration Services (SSIS) p...
- Question 76: Which of the following is a prerequisite for an SQL Server 2...
- Question 77: You plan to migrate the database to Azure. You verify that a...
- Question 78: Which of the following is NOT a valid recovery model for an ...
- Question 79: You administer a Microsoft SQL Server default instance. The ...
- Question 80: You administer a Microsoft SQL Server database named Orders....
- Question 81: You administer a Microsoft SQL Server instance named SQL1 th...
- Question 82: Which of the following SQL Server 2012 indexes stores data i...
- Question 83: DRAG DROP You administer a Microsoft SQL Server instance. Yo...
- Question 84: You administer a Windows 2008 server hosting an instance of ...
- Question 85: What is the minimum recommended amount of RAM for SQL Server...
- Question 86: You administer a Microsoft SQL Server 2012 instance that con...
- Question 87: You administer a database that has User A, B and C. User A m...
- Question 88: You administer a Microsoft SQL Server instance that has mult...
- Question 89: You administer a Microsoft SQL Server failover cluster that ...
- Question 90: You install a Microsoft SQL Server 2012 instance. The instan...
- Question 91: You are developing a SQL Server Integration Services (SSIS) ...
- Question 92: You administer a Microsoft SQL Server 2012 database. You con...
- Question 93: You administer a SQL Server database instance. You need to c...
- Question 94: You administer a Microsoft Azure SQL Database instance named...
- Question 95: You administer a Microsoft SQL Server instance. You discover...
- Question 96: You administer a Microsoft SQL Server 2012 database. You wan...
- Question 97: Which of the following DBCC commands can you use to check th...
- Question 98: You plan to install a Microsoft SQL Server 2012 instance. Th...
- Question 99: You want to remove SQL Server Integration Services from a se...
- Question 100: You are completing the installation of the Data Quality Serv...
- Question 101: Note: This question is part of a series of questions that us...
- Question 102: You are a database administrator for a Microsoft SQL Server ...
- Question 103: Note: This question is part of a series of questions that us...
- Question 104: You have the following table. (Exhibit) You need to create a...
- Question 105: Which of the following conditions must exist prior to restor...
- Question 106: You administer a Microsoft SQL Server 2012 database named Or...
- Question 107: You administer a Microsoft SQL Server 2012 instance that con...
- Question 108: You are a database developer of a Microsoft SQL Server 2012 ...
- Question 109: If you find that session ID 42 is blocking several other ses...
- Question 110: Which of the following editions of SQL Server 2012 can you r...
- Question 111: You are planning to install a Microsoft SQL Server database ...
- Question 112: You administer a Microsoft SQL Server 2012 instance that con...
- Question 113: You administer a Microsoft SQL Server 2012. A process that n...
- Question 114: HOTSPOT You administer two Microsoft SQL Server databases na...
- Question 115: You administer a Microsoft SQL Server instance that contains...
- Question 116: You administer a Microsoft SQL Server database. Users report...
- Question 117: You are creating an application that will connect to the Age...
- Question 118: You develop three Microsoft SQL Server 2012 databases named ...
- Question 119: You are creating an application that will connect to the Age...
- Question 120: You administer a single server that contains a Microsoft SQL...
- Question 121: You administer a Microsoft SQL Server 2012 database. The dat...
- Question 122: Which of the following file systems is supported for an SQL ...
- Question 123: You administer a Microsoft SQL Server database instance. You...
- Question 124: You administer a Microsoft SQL Server. A process that normal...
- Question 125: You administer two Microsoft SQL Server 2012 servers named P...
- Question 126: You administer a Microsoft SQL Server database named Sales. ...
- Question 127: You administer a Microsoft SQL Server database server. One o...
- Question 128: You install SQL Server on a new server named SQL1 and create...
- Question 129: You administer a database that has User A, B and C. User A m...
- Question 130: You administer a single server that contains a Microsoft SQL...
- Question 131: You are the administrator of a Microsoft SQL Server 2012 ser...
- Question 132: You administer a database that has User A, B and C. User A m...
- Question 133: You have a default installation of SQL Server that hosts an ...
- Question 134: Which of the following features can you install if you are i...
- Question 135: Which of the following is the default instance name in an SQ...
- Question 136: You administer a Microsoft SQL Server 2012 database named Co...
- Question 137: You administer a Microsoft SQL Server database. Users report...
- Question 138: You administer a Microsoft SQL Server 2012 instance. The ins...
- Question 139: Which of the following Microsoft SQL Server 2012 components ...
- Question 140: You maintain several databases on a 64-bit Microsoft SQL 200...
- Question 141: Which of the following is NOT a pre-defined server role in S...
- Question 142: You plan to install Microsoft SQL Server 2012 for a web host...
- Question 143: Which of the following is a valid upgrade path for SQL Serve...
- Question 144: You administer a Microsoft SQL Server database. The database...
- Question 145: You administer a Microsoft SQL Server database that includes...
- Question 146: You install Microsoft SQL Server 2012 on a new server. After...
- Question 147: You are implementing the indexing strategy for a fact table ...
- Question 148: Which of the following statements about the tempdb system da...
- Question 149: In which of the following statements about audit information...
- Question 150: What is the maximum number of SQL Server 2012 Enterprise edi...
- Question 151: You have configured Resource Governor with three resource po...
- Question 152: You are a database administrator for a Microsoft SQL Server ...
- Question 153: You administer a Microsoft SQL Server 2012 database. You nee...
- Question 154: Note: This question is part of a series of questions that us...
- Question 155: You administer a Microsoft SQL Server database. The database...
- Question 156: You administer a Microsoft Azure SQL Database instance named...
- Question 157: You administer a Microsoft SQL Server 2012 Enterprise Editio...
- Question 158: Which of the following will show you a history of job errors...
- Question 159: You administer two Microsoft SQL Server 2012 servers. Each s...
- Question 160: You install a Microsoft SQL Server instance. The instance wi...
- Question 161: You have a large partitioned fact table in a data warehouse....
- Question 162: You have a server named SQL1 that has SQL Server installed. ...
- Question 163: You are implementing a SQL Server two-node failover cluster....
- Question 164: Which of the following DBCC commands shows optimizer statist...
- Question 165: You have a server named SPS1 that has Microsoft SharePoint S...
- Question 166: Note: This question is part of a series of questions that us...
- Question 167: Note: This question is part of a series of questions that us...
- Question 168: You administer a Microsoft SQL Server 2012 database that con...
- Question 169: Which of the following is NOT a hardware requirement for SQL...
- Question 170: You are designing a data warehouse with two fact tables. The...
- Question 171: You have recently removed a SQL 2012 Database Engine instanc...
- Question 172: You administer a Microsoft SQL Server 2012 instance. After a...
- Question 173: You administer a Microsoft SQL Server database named Contoso...
- Question 174: You need to install SQL Server on a server. The server must ...
- Question 175: You have been hired as a Database Consultant by ABC.com to d...
- Question 176: Note: This question is part of a series of questions that us...
- Question 177: A network administrator creates a virtual machine from a tem...
- Question 178: DRAG DROP You administer a Microsoft SQL Server 2012 databas...
- Question 179: If you are required to move an SQL 2012 database from one se...
- Question 180: Note: This question is part of a series of questions that us...
- Question 181: Which of the following is NOT a method of failover for an SQ...
- Question 182: You maintain several databases on a 32-bit Microsoft SQL Ser...
- Question 183: You administer a Microsoft SQL Server database named Orders....
