70-462 exam

Topic 2, Volume B You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to 17:00 hours. Users modify more than 30 percent of the data...

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 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 single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed. You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions. You...

You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction. You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index. You need to defragment the index. You also need to ensure that user queries are able to use...

DRAG DROP You administer a Microsoft SQL Server 2012 database. The database is backed up according to the following schedule: - Daily full backup at 23:00 hours. - Differential backups on the hour, except at 23:00 hours. - Log backups every 10 minutes from the hour, except on the hour....

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 prevent users from disabling server audits in Server01. What should you create?A . An AlertB . A Resource PoolC . An Extended Event sessionD . A PolicyE . A Database Audit SpecificationF...

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages. You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration...

You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on the Orders database by using the following statements: You attempt to restore the Orders database and the restore fails. You copy the encryption file to the original location. A hardware failure occurs and so a...