70-462 exam

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

DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...

DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to be notified immediately when fatal errors occur on Server01. What should you create?A . An AlertB . A Server Audit SpecificationC . An Extended Event sessionD . A Resource PoolE . A...

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

You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'MyPassword1!' CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = 'TDE Certificate'; BACKUP CERTIFICATE TDE_Certificate TO FILE = ''d:TDE_Certificate.cer' WITH PRIVATE KEY (FILE...

You are the administrator of a Microsoft SQL Server 2012 server. Some applications consume significant resources. You need to manage the server workload by restricting resource-intensive applications You need to dynamically limit resource consumption. What should you do?A . Configure Resource Pools, Workload Groups, and Classifier Function, and then enable...

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

DRAG DROP You administer a Microsoft SQL Server database that is used by an application. Users of the application report performance issues. You need to choose the appropriate tool for performance-tuning of SQL Server databases. Which tool or tools should you use? (To answer, drag the appropriate tool or tools...

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_GROUPB . SERVER_PRINCIPAL_IMPERSONATION_GROUPC . SUCCESSFUL_LOGIN_GROUPD . SERVER_ROLE_MEMBER_CHANGE_GROUPView AnswerAnswer: D Explanation: Reference: http://technet.microsoft.com/en-us/library/cc280663.aspx...