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

Q1. You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate your database from SQL Server 2008 to SQL Server 2012. 

You want to evaluate to prepare for possible conflicts and issues that may arise during or after the migration. 

Which SQL Server tool should you use? 

A. Distributed Replay 

B. Migration Assistant 

C. Data Tools 

D. Upgrade Advisor 

Answer: D


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


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


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

You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements can be off-loaded from the primary database to another server. You also need to be able to add indexes to the secondary 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. . 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 

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 Asynchronous-Commit Availability Mode 

E. . Two servers configured on the same subnet 

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

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

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:


Q5. You install a Microsoft SQL Server 2012 instance. 

The instance will store data extracted from two databases running on Windows Azure SQL Database. 

You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of the data. 

You need to ensure that the data steward is given the correct client tools to perform these tasks. 

Which set of tools should you install? 

A. SQL Server Management Studio and Distributed Reply Client 

B. Data Quality Client and SQL Server Data Tools 

C. Data Quality Client and Distributed Replay Client 

D. SQL Server Management Studio and Master Data Services 

Answer: B


Q6. You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements: 

Takes an input variable Returns a table of values Cannot be referenced within a view 

Which object should you use? 

A. Scalar-valued function 

B. Inline function 

C. User-defined data type 

D. Stored procedure 

Answer: D


Q7. You administer a Microsoft SQL Server 2012 database instance. You create a new user named UserA. 

You need to ensure that UserA is able to create SQL Server Agent jobs and execute SQL Server agent jobs owned by UserA 

To which role should you add UserA? 

A. DatabaseMailUserRole 

B. ServerGroupAdministratorGroup 

C. SQLAgentUserRole 

D. Securityadmin 

Answer:


Q8. You administer a Microsoft SQL Server 2012 database. 

You provide temporary securityadmin access to User1 to the database server. 

You need to know if User1 adds logins to securityadmin. 

Which server-level audit action group should you use? 

A. SERVER_STATE_CHANGE_GROUP 

B. SERVER_PRINCIPAL_IMPERSONATION_GROUP 

C. SUCCESSFUL_LOGIN_GROUP 

D. SERVER_ROLE_MEMBER_CHANGE_GROUP 

Answer:


Q9. You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the Windows NT Service virtual accounts for all SQL Services. 

You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as 

a pull subscriber. 

The distribution agent on ProdSrv2 regularly fails, displaying the following error message: 

"Cannot access the file. Operating system error code 5 (Access is denied.)." 

You need to configure the distribution agent by granting only the minimum required access to all accounts. 

What should you do? 

A. Configure the Subscriber to use the Local System account. 

B. Configure the SQL Server Agent service to run under the Local System account. 

Configure the Subscriber to use the SQL Server Agent service account. 

C. Configure the SQL Server Agent service to run under a Windows domain account. Configure the Subscriber to use the SQL Server Agent service account. Grant FULL CONTROL access for the domain account to the ReplData share on ProdSrv1. 

D. Configure the Subscriber to use a Windows domain account. Grant READ access for the domain account to the ReplData share on ProdSrv1. 

Answer:


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