So, if you have considered placing any Microsoft 70-462 credential just after name, understand that it is doing contain a understood and incredibly actual importance. You might be considering getting your Microsoft 70-462 qualifications ( Administering Microsoft SQL Server 2012 Databases ) you may be in right on course toward taking your career to a different and higher point.

2021 Apr 70-462 free practice exam

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


Q52. You develop a database for a travel application. 

You need to design tables and other database objects. 

You create a stored procedure. 

You need to supply the stored procedure with multiple event names and their dates as parameters. 

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: E


Q53. 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 and 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 the Regions table. 

Which Transact-SQL statement should you use? 

A. REVOKE SELECT ON Schema::Customers FROM UserA 

B. REVOKE SELECT ON Object::Regions FROM UserA 

C. EXEC sp_addrolemember 'Sales', 'UserA' 

D. DENY SELECT ON Schema::Customers FROM Sales 

E. EXEC sp_droprolemember 'Sales', 'UserA' 

F. REVOKE SELECT ON Schema::Customers FROM Sales 

G. DENY SELECT ON Object::Regions FROM UserA 

H. REVOKE SELECT ON Object::Regions FROM Sales 

I. DENY SELECT ON Schema::Customers FROM UserA 

J. DENY SELECT ON Object::Regions FROM Sales 

Answer: J 


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

Answer: D


Q55. You administer a Microsoft SQL Server 2012 database named Orders. 

Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause. 

You need to gather more data to be able to determine which processes are being blocked and to identify the root cause. 

What should you do? 

A. Start a trace using SQL Server Profiler to catch the Lock: Deadlock event. 

B. Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event. 

C. Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sys.dm_os_wait_stats DMV into a table. 

D. Use System Monitor to catch the Lock Waits/sec event. 

Answer: B 


Regenerate 70-462 exam answers:

Q56. You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a highly active OLTP application. 

Users report abnormally long wait times when they submit data into the application. 

You need to identify which queries are taking longer than 1 second to run over an extended period of time. 

What should you do? 

A. use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000. 

B. Use sp_configure to set a value for blocked process threshold. Create an extended event session. 

C. Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step. 

D. Run the sp_who command from a query window. 

E. Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log. 

Answer: E 


Q57. You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). 

Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. 

You need to reduce the occurrence of these timeout errors. 

What should you do? 

A. Set the Merge agent on the problem subscribers to use the slow link agent profile. 

B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication. 

C. Change the Merge agent on the problem subscribers to run continuously. 

D. Set the Remote Connection Timeout on the Publisher to 0. 

Answer: A 


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

Answer: A 


Q59. You administer a Microsoft SQL Server 2012 database. 

You provide temporary securityadmin access to User1 to the database server. 

You need to know if User1 adds logins to securityadmin. 

Which server-level audit action group should you use? 

A. SERVER_STATE_CHANGE_GROUP 

B. SERVER_PRINCIPAL_IMPERSONATION_GROUP 

C. SUCCESSFUL_LOGIN_GROUP 

D. SERVER_ROLE_MEMBER_CHANGE_GROUP 

Answer: D 


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