70-462 Exam Questions - Online Test

70-462 Premium VCE File

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

Want to know Testking 70 462 dumps Exam practice test features? Want to lear more about Microsoft Administering Microsoft SQL Server 2012 Databases certification experience? Study Printable Microsoft 70 462 pdf answers to Far out exam 70 462 questions at Testking. Gat a success with an absolute guarantee to pass Microsoft microsoft 70 462 (Administering Microsoft SQL Server 2012 Databases) test on your first attempt.

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

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

Q3. 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 your backup will continue if any invalid checksum is encountered. 

Which backup option should you use? 

A. STANDBY 

B. Differential 

C. FULL 

D. CHECKSUM 

E. BULK_LOGGED 

F. CONTINUE_AFTER_ERROR 

G. SIMPLE 

H. DBO_ONLY 

I. COPY_ONLY 

J. SKIP 

K. RESTART 

L. Transaction log 

M. NO_CHECKSUM 

N. NORECOVERY 

Answer: F 

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

Q5. 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. SQL user without login 

B. User mapped to an asymmetric key 

C. Domain user 

D. login mapped to a virtual account 

Answer: C 

Q6. You create an availability group named HaContoso that has replicas named Server01/HA, Server02/HA, and Server03/HA. 

Currently, Server01l/HA is the primary replicA. 

You need to ensure that the following requirements are met: 

Backup operations occur on Server02/HA. 

If Server02/HA is unavailable, backup operations occur on Server03/HA. 

Backup operations do not occur on Server01/HA. 

How should you configure HaContoso? 

A. . Set the backup preference of HaContoso to Prefer Secondary. 

. Set the backup priority of Server02/HA to 20. 

. Set the backup priority of Server03/HA to 10. 

B. . Set the backup preference of HaContoso to Secondary only. 

. Set the backup priority of Server02/HA to 20. 

. Set the backup priority of Server03/HA to 10. 

C. . Set the backup preference of HaContoso to Secondary only. 

. Set the backup priority of Server02/HA to 10. 

. Set the backup priority of Server03/HA to 20. 

D. . Set the exclude replica of Server01/HA to true. 

. Set the backup priority of Server02/HA to 10. 

. Set the backup priority of Server03/HA to 20. 

Answer: B 

Q7. You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. 

You discover performance issues when complex calculations are performed on large amounts of data under heavy system load. 

You need to limit the number of cores that handle the processing. 

What should you configure? 

A. Max worker threads 

B. Processor affinity 

C. I/O affinity 

D. Lightweight pooling 

Answer: C

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

You need to ensure that data changes are sent to a non-SQL Server database server in near real time. 

You also need to ensure that data on the primary server is unaffected. 

Which configuration should you use? 

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

B. . Two servers configured in different data centers 

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

C. . Two servers configured in different data centers 

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

. One server configured as an Active Secondary 

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

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 on the same subnet 

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

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

. SQL Server configured as a clustered instance 

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

Answer: A 

Q9. You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. 

You discover performance issues when large amounts of data are written to tables under heavy system load. 

You need to limit the number of cores that handle I/O. 

What should you configure? 

A. Processor affinity 

B. Lightweight pooling 

C. Max worker threads 

D. I/O affinity 

Answer: D 

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

A database contains a large product catalog that is updated periodically. 

You need to be able to send the entire product catalog to all branch offices on a monthly basis. 

Which configuration should you use? 

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

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 a Windows Failover Cluster in the same data center 

. SQL Server configured as a clustered instance 

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

E. . Two servers configured in different data centers 

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

. One server configured as an Active Secondary 

F. . Two servers configured on the same subnet 

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

G. . Two servers configured in different data centers 

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

Answer: E