Press "Enter" to skip to content

Questions Ask for 70 462 pdf

Refined of 70 462 training kit pdf free question materials and lab for Microsoft certification for customers, Real Success Guaranteed with Updated 70 462 pdf pdf dumps vce Materials. 100% PASS Administering Microsoft SQL Server 2012 Databases exam Today!

2017 NEW RECOMMEND

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.certshared.com/exam/70-462/

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

Server01. 

You need to prevent users from disabling server audits in Server01. 

What should you create? 

A. an Alert 

B. a Resource Pool 

C. an Extended Event session 

D. a Policy 

E. a Database Audit Specification 

F. a SQL Profiler Trace 

G. a Server Audit Specification 

Answer:

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

You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. 

Which configuration should you use? 

A. . Two servers configured in different data centers 

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

. One server configured as an Active Secondary 

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 different data centers 

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

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

F. . Two servers configured on the same subnet 

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

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

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

. SQL Server configured as a clustered instance 

Answer:

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

Q74. You administer two Microsoft SQL Server 2012 servers. Each server resides in a different, untrusted domain. 

You plan to configure database mirroring. 

You need to be able to create database mirroring endpoints on both servers. 

What should you do? 

A. Configure the SQL Server service account to use Network Service. 

B. Use a server certificate. 

C. Use a database certificate. 

D. Configure the SQL Server service account to use Local System. 

Answer:

Q75. You create a table that has the StudentCode, SubjectCode, and Marks columns to record mid-year marks for students. The table has marks obtained by 50 students for various subjects. 

You need to ensure that the top half of the students arranged by their average marks must be given a rank of 1 and the remaining students must be given a rank of 2. 

Which Transact-SQL query should you use? 

A. SELECT StudentCode as Code, 

RANK() OVER (ORDER BY AVG (Marks) DESC) AS Value 

FROM StudentMarks 

GROUP BY StudentCode 

B. SELECT Id, Name, Marks, 

DENSE_RANK() OVER (ORDER BY Marks DESC) AS Rank 

FROM StudentMarks 

C. SELECT StudentCode as Code, 

DENSE_RANK() OVER (ORDER BY AVG (Marks) DESC) AS Value 

FROM StudentMarks 

GROUP BY StudentCode 

D. SELECT StudentCode as Code, 

NTILE (2) OVER (ORDER BY AVG (Marks) DESC) AS Value 

FROM StudentMarks 

GROUP BY StudentCode 

E. SELECT StudentCode AS Code,Marks AS Value FROM ( 

SELECT StudentCode, Marks AS Marks, 

RANK() OVER (PARTITION BY SubjectCode ORDER BY Marks ASC) AS Rank 

FROM StudentMarks) tmp 

WHERE Rank = 1 

F. SELECT StudentCode AS Code,Marks AS Value FROM ( 

SELECT StudentCode, Marks AS Marks, 

RANK() OVER (PARTITION BY SubjectCode ORDER BY Marks DESC) AS Rank 

FROM StudentMarks) tmp 

WHERE Rank = 1 

G. SELECT StudentCode AS Code,Marks AS Value FROM ( SELECT StudentCode, Marks AS Marks, RANK () OVER (PARTITION BY StudentCode ORDER BY Marks ASC) AS Rank FROM StudentMarks) tmp WHERE Rank = 1 

H. SELECT StudentCode AS Code,Marks AS Value FROM ( SELECT StudentCode, Marks AS Marks, RANXO OVER (PARTITION BY StudentCode ORDER BY Marks DESC) AS Rank FROM StudentMarks) tmp WHERE Rank = 1 

Answer: D

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

You need to collect data for a long period of time to troubleshoot wait statistics when querying Contoso. You also need to ensure minimum impact to the server. 

What should you create? 

A. An Alert 

B. A Resource Pool 

C. An Extended Event session 

D. A Server Audit Specification 

E. A SQL Profiler Trace 

F. A Database Audit Specification 

G. A Policy 

Answer:

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

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

On Wednesday at 10:00 hours, the development team requests you to refresh the database on a development server by using the most recent version. 

You need to perform a full database backup that will be restored on the development server. 

Which backup option should you use? 

A. NORECOVERY 

B. FULL 

C. NO_CHECKSUM 

D. CHECKSUM 

E. Differential 

F. 8ULK_LOGGED 

G. STANDBY 

H. RESTART 

I. SKIP 

J. Transaction log 

K. DBO ONLY 

L. COPY_ONLY 

M. SIMPLE 

N. CONTINUE AFTER ERROR 

Answer:

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