Microsoft 70-462 Online Practice Questions and Exam Preparation

Microsoft 70-462 Online Questions & Answers

• Question 21:

  You administer a Microsoft SQL Server 2012 database.

  The database contains a table that has the following definition:

  

  You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.

  You need to ensure that the following requirements are met:

  The first row of the file contains the first row of data.

  Each record is of the same length.

  The date follows the U.S. date format.

  The file supports international characters.

  What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

  Hot Area:

  

  

  ---

  References: http://msdn.microsoft.com/en-us/library/ms178804.aspx http://msdn.microsoft.com/en-us/library/ms187828.aspx

• Question 22:

  Which of the following SQL Server 2012 features generates numeric values at a defined interval and order?

  A. sequence
  B. number table
  C. index
  D. bigint
  A. sequence

  ---

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

• Question 23:

  You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements: Takes an input variable Returns a table of values Cannot be referenced within a view

  Which object should you use?

  A. Scalar-valued function
  B. Inline function
  C. User-defined data type
  D. Stored procedure
  D. Stored procedure

• Question 24:

  DRAG DROP

  You administer a Microsoft SQL Server 2012 database.

  The database contains a schema named CUSTOMER. CUSTOMER contains several tables and views with sensitive data, as well as various stored procedures and functions.

  In order to configure security for CUSTOMER, you need to determine how to meet the security requirements listed inthe answer area.

  Which command or commands should you use? (To answer, drag the appropriate command or commands to their corresponding security requirement or requirements 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.)

  Select and Place:

  

  

• Question 25:

  You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a database from a SQL Server 2008 instance named SQL2008 to the SQL2012 instance.

  You have upgraded a database from the SQL2008 instance by using the side-by-side migration technique.

  You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.

  What should you do?

  A. Back up the master database on the SQL2008 instance. Restore the master database on the SQL2012 instance
  B. Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package
  C. Use sp_grantlogin
  D. Use xp_logininfo.
  B. Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package

• Question 26:

  You administer a Microsoft SQL Server failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster.

  An additional node named Node C has been added to the existing cluster.

  You need to ensure that the SQL Server instance can use all nodes of the cluster.

  What should you do?

  A. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.
  B. Use Node A to install SQL Server on Node C.
  C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.
  D. Use Cluster Administrator to add a new Resource Group to Node B.
  C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.

  ---

  To add a node to an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node.

  The Installation Wizard will launch the SQL Server Installation Center. To add a node to an existing failover cluster instance, click Installation in the left-hand pane. Then, select Add node to a SQL Server failover cluster.

  References:

  http://technet.microsoft.com/en-us/library/ms191545.aspx

• Question 27:

  Which of the following is NOT a method of failover for an SQL Server 2012 mirror?

  A. Automatic Failover
  B. Manual Failover
  C. Forced Failover
  D. Intermediate Failover
  D. Intermediate Failover

• Question 28:

  You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the Exhibit button.)

  

  You write the following Transact-SQL query:

  

  You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on SalesOrderDetail.

  You need to improve the performance of the query.

  What should you do?

  A. Use a FORCESCAN hint in the query.
  B. Add a clustered index on SalesOrderId in SalesOrderHeader.
  C. Use a FORCESEEK hint in the query.
  D. Update statistics on SalesOrderId on both tables.
  D. Update statistics on SalesOrderId on both tables.

  ---

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

• Question 29:

  You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements.

  There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space.

  You also need to prevent reading queries from blocking writing queries.

  Which isolation level should you use?

  A. SERIALIZABLE
  B. SNAPSHOT
  C. READ COMMITTED SNAPSHOT
  D. REPEATABLE READ
  C. READ COMMITTED SNAPSHOT

  ---

  If READ_COMMITTED_SNAPSHOT is set to ON, the Database Engine uses row versioning to present each statement with a transactionally consistent snapshot of the data as it existed at the start of the statement. Locks are not used to protect the data from updates by other transactions.

  References: https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql

• Question 30:

  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?

  A. EXEC sp_who 60
  B. SELECT * FROM sys.dm_exec_sessions WHERE sessionjd = 60
  C. EXEC sp_helpdb 60
  D. DBCC INPUTBUFFER (60)
  A. EXEC sp_who 60

  ---

  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