70-462 exam

You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...

You administer a Microsoft SQL Server 2012 database. You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated permissions. You need to ensure that the job step can run using a different user account. What...

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 administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...

You administer a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A user named UserA is a member of a role named Sales. UserA is granted the Select permission on the Regions table. The Sales role...

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

DRAG DROP You administer a Microsoft SQL Server 2012 database. The database contains a schema named CUSTOMER. CUSTOMER contains several tables and views with sensitive data, as well as various stored procedures and functions. In order to configure security for CUSTOMER, you need to determine how to meet the security...

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?A . A Database Audit SpecificationB . A PolicyC...

You administer a Microsoft SQL Server 2012 instance. You discover that the SQL Agent Error Log file is rapidly growing in size. You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL Server agent jobs execute. What should you do?A . Execute the...

You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is...