70-462 exam

You administer all the deployments of Microsoft SQL Server 2012 in your company. A database contains a large product catalog that is updated periodically. You need to be able to send the entire product catalog to all branch offices on a monthly basis. Which configuration should you use?A . •...

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 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.A . Restart the SQL Server...

You administer a SQL Server 2012 database instance. You need to configure the SQL Server Database Engine service on a failover cluster. Which user account should you use?A . A domain userB . The BUILTINSYSTEM accountC . A local user with Run as Service permissionsD . TheSQLBrowser accountView AnswerAnswer: A

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

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

HOTSPOT You administer a Microsoft SQL Server 2012 database instance. Other applications run on the server. Some of the applications are throwing errors because of insufficient memory. You need to ensure that the other applications have sufficient memory. Which setting should you configure? View AnswerAnswer:

You administer a Microsoft SQL Server 2012 failover cluster. You need to ensure that a failover occurs when the server diagnostics returns query_processing error. Which server configuration property should you set?A . SqlOumperDumpFlagsB . FailureConditionLevelC . HealthCheckTimeoutD . SqlDumperDumpPathView AnswerAnswer: B

You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you...

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of...