70-462 Exam Questions - Online Test

70-462 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

we provide Precise Microsoft microsoft 70 462 exam question which are the best for clearing microsoft 70 462 test, and to get certified by Microsoft Administering Microsoft SQL Server 2012 Databases. The 70 462 exam Questions & Answers covers all the knowledge points of the real 70 462 dumps exam. Crack your Microsoft 70 462 exam Exam with latest dumps, guaranteed!

Q21. You administer a Microsoft SQL Server 2012 instance. 

You need to stop a blocking process that has an SPID of 64 without stopping other processes 

What should you do? 

A. Execute the following Transact-SQL statement: EXECUTE sp_KillSPID 64 

B. Restart the SQL Server service. 

C. Execute the following Transact-SQL statement: KILL 64 

D. Execute the following Transact-SQL statement: ALTER SESSION KILL '64' 

Answer: C 

Q22. You administer a Microsoft SQL Server 2012 database instance. 

You plan to migrate the database to Windows Azure SQL Database. You verify that all objects contained in the database are compatible with Windows Azure SQL Database. 

You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database. 

What should you do? 

A. Use the Copy Database wizard. 

B. Back up the database from the local server and restore it to Windows Azure SQL Database. 

C. Use the Database Transfer wizard. 

D. Use SQL Server Management Studio to deploy the database to Windows Azure SQL Database. 

Answer: D 

Q23. You administer a Microsoft SQL Server 2012 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? 

A. Move user databases to a local disk. 

B. Expand the tempdb data and log files. 

C. Modify application code to use table variables. 

D. Move the tempdb files to a local disk. 

Answer: D 

Q24. You administer a Windows Azure SQL Database database named Orders. 

You need to create a copy of Orders named Orders_Reporting. 

Which Transact-SQL command should you use? 

A. Option A 

B. Option B 

C. Option C 

D. Option D 

Answer: A 

Q25. Your database contains a table named SalesOrders. The table includes a DATETIME column named OrderTime that stores the date and time each order is placed. There is a non-clustered index on the OrderTime column. The business team wants a report that displays the total number of orders placed on the current day. 

You need to write a query that will return the correct results in the most efficient manner. 

Which Transact-SQL query should you use? 

A. SELECT COUNT(*) FROM SalesOrders 

WHERE OrderTime = CONVERT(DATE, GETDATE()) 

B. SELECT COUNT(*) FROM SalesOrders 

WHERE OrderTime = GETDATE() 

C. SELECT COUNT(*) FROM SalesOrders 

WHERE CONVERT(VARCHAR, OrderTime, 112) = CONVERT(VARCHAR, GETDATE(I, 112)) 

D. SELECT COUNT(*) FROM SalesOrders 

WHERE OrderTime >= CONVERT(DATE, GETDATE()) 

AND OrderTime < DATEADD(DAY, CONVERT(DATE, GETDATE())) 

Answer: D

Q26. You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. 

The recovery model and backup schedule are configured as shown in the following table: 

The differential backup of the reporting database fails. Then, the reporting database fails at 14:00 hours. 

You need to ensure that the reporting database is restored. You also need to ensure that data loss is minimal. 

What should you do? 

A. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup. 

B. Perform a point-in-time restore. C Restore the latest full backup. 

C. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup. 

D. Restore the latest full backup. Then, restore the latest differential backup. 

E. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup. 

F. Perform a page restore. 

G. Perform a partial restore. 

Answer: C 

Q27. You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. 

You need to track all SELECT statements issued in the Contoso database only by users in a role named Sales. 

What should you create? 

A. An Alert 

B. A Resource Pool 

C. An Extended Event session 

D. A Server Audit Specification 

E. A SQL Profiler Trace 

F. A Database Audit Specification 

G. A Policy 

H. A Data Collector Set 

Answer: F 

Q28. You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). 

The financial database has the following characteristics: 

A data file of 2 terabytes is located on a dedicated LUN (drive D). 

A transaction log of 10 GB is located on a dedicated LUN (drive E). 

Drive D has 1 terabyte of free disk space. 

Drive E has 5 GB of free disk space. 

The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day. 

The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database. 

These data load operations must occur in the minimum amount of time. 

A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours. 

You need to ensure that the backup size is as small as possible. 

Which backup should you perform every two hours? 

A. BULK_LOGGED 

B. NO_CHECKSUM 

C. FULL 

D. RESTART 

E. CHECKSUM 

F. STANDBY 

G. DBO.ONLY 

H. NORECOVERY 

I. SIMPLE 

J. SKIP 

K. Transaction log 

L. COPY_ONLY 

M. Differential 

N. CONTINUE_AFTER_ERROR 

Answer: K 

Q29. You administer all the deployments of Microsoft SQL Server 2012 in your company. 

You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. 

Which configuration should you use? 

A. . Two servers configured in different data centers 

. SQL Server Availability Group configured in Synchronous-Commit Availability Mode 

. One server configured as an Active Secondary 

B. . SQL Server that includes an application database configured to perform transactional replication 

C. . Two servers configured in the same data center 

. SQL Server Availability Group configured in Asynchronous-Commit Availability Mode 

. One server configured as an Active Secondary 

D. . Two servers configured in different data centers 

. SQL Server Availability Group configured in Asynchronous-Commit Availability Mode 

E. . Two servers configured in the same data center 

. A primary server configured to perform log-shipping every 10 minutes 

. A backup server configured as a warm standby 

F. . Two servers configured on the same subnet 

. SQL Server Availability Group configured in Synchronous-Commit Availability Mode 

G. . SQL Server that includes an application database configured to perform snapshot replication 

H. . Two servers configured in a Windows Failover Cluster in the same data center 

. SQL Server configured as a clustered instance 

Answer: H 

Q30. 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. User mapped to a certificate 

B. SQL user without login 

C. Domain user 

D. SQL user with login 

Answer: C