What to do with sql server 2012 exam 70-462

Want to know Pass4sure 70-462 Exam practice test features? Want to lear more about Microsoft Administering Microsoft SQL Server 2012 Databases certification experience? Study Tested Microsoft 70-462 answers to Renewal 70-462 questions at Pass4sure. Gat a success with an absolute guarantee to pass Microsoft 70-462 (Administering Microsoft SQL Server 2012 Databases) test on your first attempt.

2016 Aug microsoft sql server 70-462:

Q1. You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server. 

You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also need to ensure that the new Transact-SQL functionality in SQL Server 2012 can be used in the database after the migration. 

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

A. Perform a side-by-side installation of a 32-bit SQL Server 2012 instance. 

B. Perform a side-by-side installation of a 64-bit SQL Server 2012 instance. 

C. Perform an in-place upgrade to 64-bit SQL Server 2012. 

D. Detach the database from the old instance and attach it to the new instance. 

E. Change the compatibility level of the database. 

Answer: BDE 


Q2. You administer a Microsoft SQL Server 2012 instance. 

You discover that the SQL Agent Error Log file is rapidly growing in size. 

You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute. 

What should you do? 

A. Execute the sp_cycle_agent_errorlog stored procedure. 

B. Configure event forwarding. 

C. Enable the Auto Shrink option on the master database. 

D. Enable the Auto Shrink option on the msdb database. 

E. Disable the Include execution trace messages feature. 

Answer: E 


Q3. 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 


Q4. You administer a Microsoft SQL Server 2012 default instance. 

The instance is hosted by a server that has a local firewall configureD. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. 

You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections. 

What should you do? Choose all that apply. 

A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. 

B. Execute the following Transact-SQL command: sp_configure 'remote admin connections', C. Execute the Reconfigure command. 

D. Execute the following Transact-SQL command: sp_configure 'remote access', 1 

E. Restart the SQL Server Agent Service. 

F. Enable inbound connections on TCP port 135 in the Windows Firewall on the server. 

Answer: ABC 


Q5. You administer a Microsoft SQL Server 2012 server. 

When transaction logs grow, SQL Server must send an email message to the database administrators. 

You need to configure SQL Server to send the email messages. 

What should you configure? 

A. SQL Mail 

B. An Extended Events session 

C. Alerts and operators in SQL Server Agent 

D. Policies under Policy-Based Management 

Answer: C 


Q6. 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? 

A. ALTER INDEX IX_OrderDateON CustomerOrderDISABLE 

B. ALTER INDEX IX_OrderDateON CustomerOrderENABLE 

C. ALTER INDEX IX_OrderDateON CustomerOrderREORGANIZE 

D. ALTER INDEX IX OrderDateON CustomerOrderREBUILD 

Answer: C 


Q7. 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


70-462 free practice questions

Avant-garde transcender 70-462 review:

Q8. You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. 

You discover that a large amount of memory is consumed by single-use dynamic queries. 

You need to reduce procedure cache usage from these statements without creating any additional indexes. 

What should you do? 

A. Add a HASH hint to the query. 

B. Add a LOOP hint to the query. 

C. Add a FORCESEEK hint to the query. 

D. Add an INCLUDE clause to the index. 

E. Add a FORCESCAN hint to the Attach query. 

F. Add a columnstore index to cover the query. 

G. Enable the optimize for ad hoc workloads option. 

H. Cover the unique clustered index with a columnstore index. 

I. Include a SET FORCEPLAN ON statement before you run the query. 

J. Include a SET STATISTICS PROFILE ON statement before you run the query. 

K. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query. 

L. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query. 

M. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query. 

N. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query. 

Answer: G 


Q9. 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: 


At 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are corrupted on the reporting database. 

You also need to ensure that data loss is minimal. 

What should you do? 

A. Perform a partial restore. 

B. 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. 

C. Restore the latest full backup. 

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

E. Perform a page restore. 

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

G. Perform a point-in-time restore. 

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

Answer: H 


Q10. You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. 

The media files will require fast access and will be retrieved frequently. 

What should you do? 

A. Use the CAST function. 

B. Use the DATE data type. 

C. Use the FORMAT function. 

D. Use an appropriate collation. 

E. Use a user-defined table type. 

F. Use the VARBINARY data type. 

G. Use the DATETIME data type. 

H. Use the DATETIME2 data type. 

I. Use the DATETIMEOFFSET data type. 

J. Use the TODATETIMEOFFSET function. 

Answer: F


Q11. You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSO\SQLService. 

You plan to configure Instant File Initialization. 

You need to ensure that Data File Autogrow operations use Instant File Initialization. 

What should you do? Choose all that apply. 

A. Restart the SQL Server Agent Service. 

B. Disable snapshot isolation. 

C. Restart the SQL Server Service. 

D. Add the CONTOSO\SQLService account to the Perform Volume Maintenance Tasks local security policy. 

E. Add the CONTOSO\SQLService account to the Server Operators fixed server role. 

F. Enable snapshot isolation. 

Answer: CD 


Q12. You administer a Microsoft SQL Server 2012 database. 

You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated permissions. 

You need to ensure that the job step can run using a different user account. 

What should you use? 

A. A notification 

B. A schedule 

C. A job category 

D. A proxy 

Answer: D 


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

Answer: C 


Q14. You administer a Microsoft SQL Server 2012 server. You plan to deploy new features to an application. 

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance. 

What should you do? 

A. Query the sys.dm_db_index_usage_stats DMV. 

B. Query the sys.dm_db_missing_index_details DMV. 

C. Use the Database Engine Tuning Advisor. 

D. Query the sys.dm_db_missing_index_columns DMV. 

Answer: C 


Q15. 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 



see more 70-462 dumps