70-462 Exam Questions - Online Test

70-462 Premium VCE File

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

We provide real 70 462 pdf exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Microsoft 70 462 training kit pdf Exam quickly & easily. The 70 462 training kit pdf PDF type is available for reading and printing. You can print more and practice many times. With the help of our Microsoft 70 462 training kit pdf dumps pdf and vce product and material, you can easily pass the 70 462 training kit pdf exam.

Q11. You administer a Microsoft SQL Server 2012 default instance. 

The instance is hosted by a server that has a local firewall configureD. The firewall only allows inbound connections on port 1433. The server only hosts a single instance of SQL Server. 

You need to ensure that the instance is configured to allow remote connections even if the SQL Server is unresponsive to client connections. 

What should you do? Choose all that apply. 

A. Enable inbound connections on TCP port 1434 in the Windows Firewall on the server. 

B. Execute the following Transact-SQL command: sp_configure 'remote admin connections', C. Execute the Reconfigure command. 

D. Execute the following Transact-SQL command: sp_configure 'remote access', 1 

E. Restart the SQL Server Agent Service. 

F. Enable inbound connections on TCP port 135 in the Windows Firewall on the server. 

Answer: ABC 

Q12. 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: B 

Q13. You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema. 

Some users must be prevented from deleting records in any of the tables in the Sales schema. 

You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort. 

What should you do? 

A. Create a custom database role that includes the users. Deny Delete permissions on the Sales schema for the custom database role. 

B. Include the Sales schema as an owned schema for the db_denydatawriter role. Add the users to the db_denydatawriter role. 

C. Deny Delete permissions on each table in the Sales schema for each user. 

D. Create a custom database role that includes the users. Deny Delete permissions on each table in the Sales schema for the custom database role. 

Answer: A 

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

Q15. 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 the minimum amount of data is lost. 

Which recovery model should the database use? 

A. FULL 

B. DBO_ONLY 

C. CONTINUE_AFTER_ERROR 

D. CHECKSUM 

E. NO_CHECKSUM 

F. SIMPLE 

G. Transaction log 

H. SKIP 

I. RESTART 

J. COPY_ONLY 

K. NORECOVERY 

L. BULK_LOGGED 

M. Differential 

N. STANDBY 

Answer: L 

Q16. You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. 

The Sales database is configured as shown in the following table. 

You discover that all files except Sales_2.ndf are corrupt. 

You need to recover the corrupted data in the minimum amount of time. 

What should you do? 

A. Perform a restore from a full backup. 

B. Perform a transaction log restore. 

C. Perform a file restore. 

D. Perform a filegroup restore. 

Answer: C 

Q17. You use Microsoft SQL Server 2012 to develop a database application. You need to implement a computed column that references a lookup table by using an INNER JOIN against another table. 

What should you do? 

A. Reference a user-defined function within the computed column. 

B. Create a BEFORE trigger that maintains the state of the computed column. 

C. Add a default constraint to the computed column that implements hard-coded values. 

D. Add a default constraint to the computed column that implements hard-coded CASE statements. 

Answer: A

Q18. You administer a Microsoft SQL Server 2012 instance. 

The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. 

You plan to define a backup strategy for the database. You need to ensure that the following requirements are met: 

. No more than 5 minutes worth of transactions are lost. 

. Data can be recovered by using the minimum amount of administrative effort. 

What should you do? Choose all that apply. A. Configure the database to use the SIMPLE recovery model. 

B. Create a DIFFERENTIAL database backup every 4 hours. 

C. Create a LOG backup every 5 minutes. 

D. Configure the database to use the FULL recovery model. 

E. Create a FULL database backup every 24 hours. 

F. Create a DIFFERENTIAL database backup every 24 hours. 

Answer: BCDE 

Q19. You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A and Node B. A single instance of SQL Server is installed on the cluster. 

An additional node named Node C has been added to the existing cluster. 

You need to ensure that the SQL Server instance can use all nodes of the cluster. 

What should you do? 

A. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A. 

B. Use Node A to install SQL Server on Node C. 

C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C. 

D. Use Cluster Administrator to add a new Resource Group to Node B. 

Answer: C 

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