It is more faster and easier to pass the Microsoft 70-462 exam by using Real Microsoft Administering Microsoft SQL Server 2012 Databases questuins and answers. Immediate access to the Leading 70-462 Exam and find the same core area 70-462 questions with professionally verified answers, then PASS your exam with a high score now.

2021 Mar 70-462 book

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

Answer: B 


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


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

One of the hard disk drives that stores the reporting database fails at 16:40 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. Then, restore each differential backup taken before the time of failure from the most recent full backup. 

B. Perform a partial restore. 

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

D. Perform a point-in-time restore. 

E. Restore the latest full backup. 

F. Perform a page restore. 

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

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

Answer: E 


Q4. You are the lead database administrator (DBA) of a Microsoft SQL Server 2012 environment. 

All DBAs are members of the DOMAIN\JrDBAs Active Directory group. You grant DOMAIN\JrDBAs access to the SQL Server. 

You need to create a server role named SpecialDBARole that can perform the following functions: 

View all databases. 

View the server state. 

Assign GRANT, DENY, and REVOKE permissions on logins. 

You need to add DOMAIN\JrDBAs to the server role. You also need to provide the least level of privileges necessary. 

Which SQL statement or statements should you use? Choose all that apply. 

A. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION setupadmin; 

B. ALTER SERVER ROLE [SpecialDBARole] ADD MEMBER [DOMAIN\JrDBAs]; 

C. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION securityadmin; 

D. GRANT VIEW DEFINITION TO [SpecialDBARole]; 

E. CREATE SERVER ROLE [SpecialDBARole] AUTHORIZATION serveradmin; 

F. GRANT VIEW SERVER STATE, VIEW ANY DATABASE TO [SpecialDBARole]; 

Answer: BCF 


Q5. You administer a Microsoft SQL Server 2012 instance. 

You need to configure a new database to support FILETABLES. 

What should you do? Choose all that apply. 

A. Disable FILESTREAM on the Database. 

B. Enable FILESTREAM on the Server Instance. 

C. Configure the Database for Partial Containment. 

D. Create a non-empty FILESTREAM file group. 

E. Enable Contained Databases on the Server Instance. 

F. Set the FILESTREAM directory name on the Database. 

Answer: BDF 


Refresh 70-462 practice exam:

Q6. You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production database. 

You need to ensure that the database remains available if a catastrophic server failure or a disk failure occurs. 

You also need to maintain transactional consistency of the data across both servers. 

You need to achieve these goals without manual intervention. 

Which configuration should you use? 

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

. SQL Server configured as a clustered instance 

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

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

D. . Two servers configured in different data centers 

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

. One server configured as an Active Secondary 

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

F. . Two servers configured in different data centers 

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

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

H. . Two servers configured on the same subnet 

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

Answer: H 


Q7. You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. 

The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the week. 

Backups are performed as shown in the following schedule: 

The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process will take a maximum of 8 hours to complete. 

The batch process will update three tables that are 10 GB in size. The batch process will update these tables multiple times. 

When the batch process completes, the Finance department runs a report to find out whether the batch process has completed correctly. 

You need to ensure that if the Finance department disapproves the batch process, the batch operation can be rolled back in the minimum amount of time. 

What should you do on Saturday? 

A. Perform a differential backup at 08:59 hours. 

B. Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 17:01 hours. 

C. Create a database snapshot at 08:59 hours. 

D. Record the LSN of the transaction log at 08:59 hours. Perform a transaction log backup at 08:59 hours. 

E. Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at 17:01 hours. 

F. Create a marked transaction in the transaction log at 08:59 hours. Perform a transaction log backup at 08:59 hours. 

Answer: C 


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

You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. 

What should you create? 

A. A Database Audit Specification 

B. A Policy 

C. An Alert 

D. A SQL Profiler Trace 

E. A Resource Pool 

F. An Extended Event session 

G. A Server Audit Specification 

Answer: G 


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


Q10. You develop a database for a travel application. 

You need to design tables and other database objects. 

You create the Airline_Schedules table. 

You need to store the departure and arrival dates and times of flights along with time zone information. 

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