70-462 exam

You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?A . Execute sp_configure 'max log size', 2C . use the ALTER DATABASD . ..SET LOGFILE command along with the maxsize parameter.E...

You are the administrator of a Microsoft SQL Server database 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 . Create a new Plan Guide with a Scope Type of sql...

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

You administer a Microsoft SQL Server 2012 server. When transaction logs grow, SQL Server must send an email message to the database administrators. You need to configure SQL Server to send the email messages. What should you configure?A . SQL MailB . An Extended Events sessionC . Alerts and operators...

You maintain several databases on a 32-bit Microsoft SQL Server 2005 instance on a Windows Server 2008 R2 64-bit server. You need to migrate the databases to a 64-bit SQL Server 2012 instance on the same server. You also need to ensure that the new Transact-SQL functionality in SQL Server...

You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated. The following error message is an example of the truncated error message: "Executed as user CONTOSOServiceAccount....0.4035.00 for 64-bit...

You administer several Microsoft SQL Server database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors....

You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a new application that requires the deployment of a database on the server. The application login requires sysadmin permissions. You need to ensure that the application login is unable to access other...

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You attempt to add the [CorpnetUser1] login to the database. However, you receive the following error message: "User already exists in current database." You need to configure the [CorpnetUser1] login to be able...