You administer a Microsoft SQL Server 2012 database.
The database contains a Product table created by using the following definition:

You need to ensure that the minimum amount of disk space is used to store the data in the Product table.
What should you do?

• A.Convert all indexes to Column Store indexes.
• B.Implement Unicode Compression.
• C.Implement row-level compression.
• D.Implement page-level compression.

Comment: *

Name: *

Email: *

Verification: *

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 do not provide the required detail.
The following error message is an example error message:
"The job failed. The Job was invoked by User CONTOSO\ServiceAccount. The last step to run was step 1 (Subplan_1)."
You need to ensure that all available details of the job step failures for SQL Server Agent jobs are retained.
What should you do?

• A.Configure output files.
• B.Expand agent logging to include information from all events.
• C.Disable the Limit size of job history log feature.
• D.Configure event forwarding.

Comment: *

Name: *

Email: *

Verification: *

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 Wizard to create a Database Mail profile. Security has not been configured for the Database Mail profile.
You need to ensure that AgentPortalUser can send email messages.
What should you do?

• A.In the Database Mail Configuration Wizard, configure the Database Mail profile as a private profile for the AgentPortalUser account.
• B.Disable the guest user in the msdb database.
• C.Use the sysmail_help_profileaccount_sp stored procedure to add accounts to the Database Mail profile.
• D.In the Database Mail Configuration Wizard, create an email account for each recipient's email address in the Database Mail profile.
• E.Configure the Microsoft SQL Server Agent to use Database Mail.

Comment: *

Name: *

Email: *

Verification: *

You have recently removed a SQL 2012 Database Engine instance from a computer running the Windows Server 2008 R2 operating system. Prior to the removal of the instance, you had configured affinity so that the default instance used CPU 0 and 1 and the second instance used CPU 2 and 3.
You want to ensure that the default instance can use all processors available to the host.
Which of the following commands would you use to accomplish this goal?

• A.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 2,3
• B.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,4
• C.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = 0,1
• D.ALTER SERVER CONFIGURATION SET PROCESS AFFINITY CPU = AUTO

Comment: *

Name: *

Email: *

Verification: *

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 user should you create?

• A.login mapped to a virtual account
• B.Domain user
• C.SQL user without login
• D.User mapped to an asymmetric key

Comment: *

Name: *

Email: *

Verification: *