Ensurepass.com : Ensure you pass the IT Exams
2018 May Microsoft Official New Released 70-462
100% Free Download! 100% Pass Guaranteed!

Administering Microsoft SQL Server 2012 Databases

Question No: 121 – (Topic 2)

You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running Microsoft SQL Server 2012. All databases are hosted on a SAN (Storage Area Network).

You need to design a database solution for a new application.

You are tasked with designing a high-availability database solution.

The solution must include a single copy of the database to save disk space and the database must remain online in the event of a SQL Server failure. What should you include in your solution?

  1. You should include two servers configured as a failover cluster.

  2. You should include two servers and database mirroring.

  3. You should include two servers and log shipping.

  4. You should include two servers configure as a SQL Server Availability Group

Answer: A

Question No: 122 – (Topic 2)

You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders.

Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily

fragmenteD.

You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.

Which Transact-SQL command should you use?

  1. ALTER INDEX IX_OrderDateON CustomerOrderDISABLE

  2. ALTER INDEX IX_OrderDateON CustomerOrderENABLE

  3. ALTER INDEX IX_OrderDateON CustomerOrderREORGANIZE

  4. ALTER INDEX IX OrderDateON CustomerOrderREBUILD

Answer: C

Question No: 123 – (Topic 2)

You administer a Microsoft SQL Server 2012.

A process that normally runs in less than 10 seconds has been running for more than an hour.

You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked.

Which Transact-SQL statement should you use?

  1. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60

  2. DBCC INPUTBUFFER (60)

  3. EXEC sp_helpdb 60

  4. SELECT * FROM sys.dm_exec_request WHERE session_id = 60

Answer: D

Question No: 124 – (Topic 2)

You administer a Microsoft SQL Server 2012 environment. One of the SQL Server 2012

instances contains a database named Sales.

You plan to migrate Sales to Windows Azure SQL Database. To do so, you need to implement a contained database.

What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  1. Set database containment to AZURE.

  2. Enable server property contained database authentication.

  3. Disable server property cross db ownership chaining.

  4. Set database containment to PARTIAL.

  5. Disable server property contained database authentication.

  6. Set database containment to FULL.

Answer: B,D

Question No: 125 – (Topic 2)

You administer a Microsoft SQL Server 2012.

A process that normally runs in less than 10 seconds has been running for more than an hour.

You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked.

Which Transact-SQL statement should you use?

  1. EXEC sp_who 60

  2. SELECT * FROM sys.dm_exec_sessions WHERE sessionid = 60

  3. EXEC sp_helpdb 60

  4. DBCC INPUTBUFFER (60)

Answer: A Explanation:

References:

http://msdn.microsoft.com/en-us/library/ms174313.aspx http://msdn.microsoft.com/en-us/library/ms176013.aspx http://msdn.microsoft.com/en-us/library/ms178568.aspx http://msdn.microsoft.com/en-us/library/ms187730.aspx

Question No: 126 – (Topic 2)

You want to simulate read, write, checkpoint, backup, sort, and read-ahead activities for your organization’s SQL Server 2012 deployment.

Which of the following tools would you use to accomplish this goal?

  1. SQLIO

  2. SQLIOSim

  3. SQLIOStress

  4. chkdsk

Answer: B

Question No: 127 DRAG DROP – (Topic 2)

You administer a database named SalesDb that has users named UserA, UserB, and UserC.

You need to ensure that the following requirements are met:

  • UserA must be able to provide Windows login access to the database.

  • UserB must be able to select, update, delete and insert data to the database tables.

  • UserC must be able to create new tables and stores procedures

You need to achieve this goal by granting only the minimum permissions required.

To which fixed database role or roles should you add the users?

Ensurepass 2018 PDF and VCE

Answer:

Ensurepass 2018 PDF and VCE

Question No: 128 – (Topic 2)

You administer a SQL Server 2012 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 the Sales role, including UserA, is disallowed to select from any of the tables in the Customers schema.

Which Transact-SQL statement should you use?

  1. REVOKE SELECT ON Schema::Customers FROM UserA

  2. DENY SELECT ON Object::Regions FROM UserA

  3. EXEC sp_addrolemember #39;Sales#39;, #39;UserA#39;

  4. DENY SELECT ON Object::Regions FROM Sales

  5. REVOKE SELECT ON Object::Regions FROM UserA

  6. DENY SELECT ON Schema::Customers FROM Sales

  7. DENY SELECT ON Schema::Customers FROM UserA

  8. EXEC sp_droprolemember #39;Sales#39;, #39;UserA#39;

  9. REVOKE SELECT ON Object::Regions FROM Sales

  10. REVOKE SELECT ON Schema::Customers FROM Sales

Answer: F Explanation: References:

http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx http://msdn.microsoft.com/en-us/library/ms187728.aspx

Question No: 129 – (Topic 2)

You want to reproduce the same SQL Server 2012 installation configuration across five servers.

Which of the following files will you generate by using SQL Server Setup to accomplish this goal?

  1. Configuration.xml

  2. Setup.ini

  3. Setup.xml

  4. ConfigurationFile.ini

Answer: D

Question No: 130 – (Topic 2)

Which of the following is NOT a database role that you can assign users in SQL Server 2012?

  1. db_ddladmin

  2. db_owner

  3. db_datawriter

  4. db_databaseadmin

Answer: D

Explanation: References:

https://msdn.microsoft.com/en-us/library/ms189121(v=sql.110).aspx

100% Ensurepass Free Download!
Download Free Demo:70-462 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 70-462 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Comments are closed.