Microsoft 070-462 Actual Free Exam Questions & Community Discussion
Which of the following is a disaster recovery solution offered in SQL Server 2012 and involves maintaining a standby copy of a primary database?
Correct Answer: C
Vote an answer
You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers.
All objects in Contoso are in the dbo schema.
You need to grant EXECUTE permission for all stored procedures in Contoso to BillingUsers.
Which Transact-SQL statement should you use?
All objects in Contoso are in the dbo schema.
You need to grant EXECUTE permission for all stored procedures in Contoso to BillingUsers.
Which Transact-SQL statement should you use?
Correct Answer: A
Vote an answer
You administer a Microsoft SQL Server database.
Users report that a billing application is throwing errors during busy times of the day.
You identity that the following error is regularly written to the application's error tog every day between 4:00 pm and 5:30 pm:
Error 1205: Transaction (Process ID) was deadlocked on resources with another process and Has been chosen as the deadlock victim.
You need to determine tike cause of deadlocks. You start a trace using SQL Server Profiler.
Which event should you select?
Users report that a billing application is throwing errors during busy times of the day.
You identity that the following error is regularly written to the application's error tog every day between 4:00 pm and 5:30 pm:
Error 1205: Transaction (Process ID) was deadlocked on resources with another process and Has been chosen as the deadlock victim.
You need to determine tike cause of deadlocks. You start a trace using SQL Server Profiler.
Which event should you select?
Correct Answer: A
Vote an answer
You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012.
You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration.
Which SQL Server tool should you use?
You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration.
Which SQL Server tool should you use?
Correct Answer: A
Vote an answer
You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database.
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs.
You also need to maintain transactional consistency of the data across both servers.
You need to achieve these goals without manual intervention.
Which configuration should you use?
Correct Answer: G
Vote an answer
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.
You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?
The Sales database is configured as shown in the following table.
You discover that all files except Sales_2.ndf are corrupt.
You need to recover the corrupted data in the minimum amount of time.
What should you do?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
You need to ensure that data changes are sent to a non-SQL Server database server in near real time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
Correct Answer: E
Vote an answer
You administer a Microsoft SQL Server 2012 database. The database contains two tables named Table A and Table B.
You perform an import and export operation by using the following steps in sequence, as shown in the exhibit.
(Click the Exhibit button.)
Load data from a third-party database to Table A.
Insert a subset of records from Table A to Table B.
Export the data from Table B to a flat file.
You also create a format file for the data export.
You need to choose the correct command or tool for each task. You need to ensure that each task is performed efficiently.
Which command(s) or tool(s) should you use? (To answer, drag the appropriate command(s) or tool(s) to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
You perform an import and export operation by using the following steps in sequence, as shown in the exhibit.
(Click the Exhibit button.)
Load data from a third-party database to Table A.
Insert a subset of records from Table A to Table B.
Export the data from Table B to a flat file.
You also create a format file for the data export.
You need to choose the correct command or tool for each task. You need to ensure that each task is performed efficiently.
Which command(s) or tool(s) should you use? (To answer, drag the appropriate command(s) or tool(s) to their corresponding task or tasks in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)
Correct Answer:
Explanation
You have been hired as a Database Consultant by ABC.com to design a SQL Server 2012 database solution.
You are tasked with designing a scale-out and high-availability SQL Server 2012 Online Transaction Processing (OLTP) database solution that will maintain copies of data across two server instances.
Your solution must provide scale-out of read operations by distributing the reads from clients across two SQL Server 2012 nodes. The data in both SQL Server nodes needs to be indexed.
What should you include in your solution?
You are tasked with designing a scale-out and high-availability SQL Server 2012 Online Transaction Processing (OLTP) database solution that will maintain copies of data across two server instances.
Your solution must provide scale-out of read operations by distributing the reads from clients across two SQL Server 2012 nodes. The data in both SQL Server nodes needs to be indexed.
What should you include in your solution?
Correct Answer: D
Vote an answer
Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You administer a SQL Server database server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?
You administer a SQL Server database server that contains a database named SalesDb. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table. The Sales role is granted the Select permission on the Customers schema.
You need to ensure that UserA is disallowed to select from the Regions table.
Which Transact-SQL statement should you use?
Correct Answer: C
Vote an answer
You administer a Microsoft SQL Server instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN).
You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?
You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?
Correct Answer: B
Vote an answer
You are configuring a Microsoft SQL Server server and setting up a new database.
You need to ensure that the following requirements are met:
* Provide access to the database for a Windows group named CORP\Employees.
The database can be moved to another server with no additional changes to the security configuration of the database or server.
Which three actions should you perform in sequence? (To answer, move the appropriate action or actions from the list of actions to the answer area and arrange them in the correct order.)
You need to ensure that the following requirements are met:
* Provide access to the database for a Windows group named CORP\Employees.
The database can be moved to another server with no additional changes to the security configuration of the database or server.
Which three actions should you perform in sequence? (To answer, move the appropriate action or actions from the list of actions to the answer area and arrange them in the correct order.)
Correct Answer:
Explanation
References:
https://msdn.microsoft.com/en-us/library/ff929139%28v=sql.110%29.aspx
http://www.sqlcoffee.com/SQLServer2012_0009.htm
You administer two instances of Microsoft SQL Server. You deploy an application that uses a database on the named instance.
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?
Correct Answer: D
Vote an answer
0
0
0
10