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 requirements listed in the answer area.
Which command or commands should you use? (To answer, drag the appropriate command or commands to their corresponding security requirement or requirements in the answer area. Answer choices may be used once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may need to drag the split bar between panes or scroll to view content.)

Correct Answer:

Explanation

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server 2012 database that has multiple tables in the Sales schema.
Some users must be prevented from deleting records in any of the tables in the Sales schema.
You need to manage users who are prevented from deleting records in the Sales schema. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?

• A.Include the Sales schema as an owned schema for the db_denydatawriter role. Add the users to the db_denydatawriter role.
• B.Create a custom database role that includes the users. Deny Delete permissions on each table in the Sales schema for the custom database role.
• C.Deny Delete permissions on each table in the Sales schema for each user.
• D.Create a custom database role that includes the users. Deny Delete permissions on the Sales schema for the custom database role.

Comment: *

Name: *

Email: *

Verification: *

You are planning to install a Microsoft SQL Server Database Engine instance. The instance will be used to support a high-volume OLTP database application The server has the following logical disk configuration Drive C is used as the system drive:
* Drive C: RAID 1
* Drive D: RAID 10
* Drive E: RAID 5
You need to ensure that the default data folders for the Database Engine are configured for optimal performance. Which three actions should you perform? Each correct answer presents pan of the solution.

• A.Place the TempDB data files on Drive C.
• B.Place the User Database data files and User Database log files on Drive C.
• C.Place the User Database data files on Drive E.
• D.Place the TempDB fog files on Drive E.
• E.Place the TempDB files and TempDB log files on Drive D.
• F.Place the User Database log files on Drive D.

Comment: *

Name: *

Email: *

Verification: *

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores.
You discover performance issues when large amounts of data are written to tables under heavy system load.
You need to limit the number of cores that handle I/O.
What should you configure?

• A.Processor affinity
• B.Lightweight pooling
• C.Max worker threads
• D.I/O affinity

Comment: *

Name: *

Email: *

Verification: *

DRAG DROP
You create a view based on the following statement:

You grant the Select permission to User1 for this view. You need to change the view so that it displays only the records that were processed in the month prior to the current month. You need to ensure that after the changes, the view functions correctly for User1.
Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

Correct Answer:

Explanation:

Explanation/Reference: http://msdn.microsoft.com/en-us/library/hh213020.aspx http://msdn.microsoft.com/en-us/library/ms186819.aspx http://msdn.microsoft.com/en-us/library/ms173846.aspx

Comment: *

Name: *

Email: *

Verification: *