[Jul 2017] exam 70 462

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

2017 NEW RECOMMEND

Free VCE & PDF File for Microsoft 70-462 Real Exam
(Full Version!)

Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions

Free Instant Download NEW 70-462 Exam Dumps (PDF & VCE):
Available on:
http://www.certleader.com/70-462-dumps.html

Q1. You administer a SQL Server 2012 database instance. 

You need to configure the SQL Server Database Engine service on a failover cluster. 

Which user account should you use? 

A. A domain user 

B. The BUILTIN\\SYSTEM account 

C. A local user with Run as Service permissions 

D. TheSQLBrowser account 

Answer:

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

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

Q4. You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the Exhibit button.) 

You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on SalesOrderDetail. 

You need to improve the performance of the query. 

What should you do? 

A. Use a FORCESCAN hint in the query. 

B. Add a clustered index on SalesOrderId in SalesOrderHeader. 

C. Use a FORCESEEK hint in the query. 

D. Update statistics on SalesOrderId on both tables. 

Answer: D

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

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

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

What should you use? 

A. a schedule 

B. an alert 

C. an operator 

D. a proxy 

Answer: D

Q7. You administer a Microsoft SQL Server 2012 database named Contoso that contains a single user-defined database role namedBillingUsers. 

All objects in Contoso are in the dbo schemA. 

You need to grant EXECUTE permission for all stored procedures in Contoso to BillingUsers. 

Which Transact-SQL statement should you use? 

A. GREATE ROLE proc_caller GRANT EXECUTE ON Schema : : dbo TO proc_caller ALTER ROLE proc_caller ADD MEMBER BillingUsers 

B. GRANT EXECUTE ON INFORMATION_SCHEMA.ROUTINES TO BillingUsers 

C. EXEC sp_addrolemember 'executor' , 'BillingUsers' 

D. GREATE ROLE proc_caller GRANT EXECUTE ON ALL PROCEDURES TO proc_caller ALTER MEMBER BillingUsers ADD TO ROLE proc_caller 

Answer:

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

Q9. You administer a Microsoft SQL Server 2012 database. 

The database contains a customer table created by using the following definition: 

You need to ensure that the minimum amount of disk space is used to store the data in the customer table. 

What should you do? 

A. Implement row-level compression. 

B. Implement page-level compression. 

C. Convert all indexes to Column Store indexes. 

D. Implement Unicode compression. 

Answer:

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

Certleader Dumps
Certleader is a company specialized on providing high quality IT exam materials and fully committed to assist our respected clients crack any IT certification tests on their 1st efforts.