Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 151:

  You use a contained database named ContosoDb within a domain.

  You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.

  Which type of user should you create?

  A. SQL user without login
  B. User mapped to an asymmetric key
  C. SQL user with password
  D. SQL user with a custom SID
  C. SQL user with password

  ---

  SQL Server supports contained database users for both Windows and SQL Server authentication.

  Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable

• Question 152:

  DRAG DROP

  You create a view based on the following statement:

  

  You grant the Select permission to User1 for this view. You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the changes, the view functions correctly for User1. Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

  ---

  Explanation: http://msdn.microsoft.com/en-us/library/hh213020.aspx http://msdn.microsoft.com/en-us/library/ms186819.aspx http://msdn.microsoft.com/en-us/library/ms173846.aspx

• Question 153:

  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?

  A. Start the SQL Server Integration Services service.
  B. Start the SQL Server Browser Service
  C. Use the Data Quality Client to configure the application.
  D. Use the Master Data Services Configuration Manager to configure the application
  B. Start the SQL Server Browser Service

• Question 154:

  If you find that session ID 42 is blocking several other sessions, which of the following will kill that session?

  A. REMOVE 42;
  B. TERMINATE 42;
  C. KILL SESSION 42;
  D. KILL 42;
  D. KILL 42;

  ---

  References https://msdn.microsoft.com/en-us/library/ms173730%28v=sql.110%29.aspx

• Question 155:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 server.

  You need to install the Power View components on a stand-alone server.

  Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 156:

  You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail.

  You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented.

  You need to reduce fragmentation. You need to achieve this goal without taking the index offline.

  Which Transact-SQL batch should you use?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  B. Option B

  ---

  Reference: http://msdn.microsoft.com/en-us/library/ms188388.aspx

• Question 157:

  Which of the following statements about the tempdb system database is FALSE?

  A. It is a globally available resource for all connected users.
  B. It can hold explicitly or implicitly created database objects.
  C. It must be sized in accordance with the smallest user-database on the machine.
  D. It is created every time the SQL Server instance is restarted.
  C. It must be sized in accordance with the smallest user-database on the machine.

  ---

  References: https://msdn.microsoft.com/en-us/library/ms190768%28v=sql.110%29.aspx

• Question 158:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 database.

  You need to convert the database to a contained database. You also need to ensure that all users are converted to contained users.

  Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of http://msdn.microsoft.com/en -us/library/ms191464.aspx actions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

  ---

  Reference: http://msdn.microsoft.com/en-us/library/ff929071.aspx

• Question 159:

  You administer a Microsoft SQL Server database. The database is currently configured to log ship to a secondary server.

  You are preparing to cut over to the secondary server by stopping log-shipping and bringing the secondary database online. You want to perform a tail-log backup.

  You need to leave the primary database in a restoring state.

  Which option of the BACKUP LOG command should you use?

  A. NO_TRUNCATE
  B. NORECOVERY
  C. STANDBY
  D. FORMAT
  B. NORECOVERY

• Question 160:

  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 Microsoft SQL Server 2012 database named Contoso on a server named Server01.

  You need to prevent users from disabling server audits in Server01.

  What should you create?

  A. An Alert
  B. A Resource Pool
  C. An Extended Event session
  D. A Policy
  E. A Database Audit Specification
  F. A SQL Profiler Trace
  G. A Server Audit Specification
  D. A Policy