What should you recommend creating?
Which encryption type and data type should you identity?
You plan to create a new table that will contain a column named Salary. Salary will contain highly sensitive data.
Salary must meet the following requirements:
Contain numeric data.
Contain only encrypted data that remains encrypted in memory.
You need to identify which encryption type and data type must be used for Salary.
Which encryption type and data type should you identity?
To answer, drag the appropriate encryption type and data type to the correct identifier in the answer area.
Select and Place:
Which code segment should you execute?
You have a SQL Server 2012 database named DB1. You have a backup device named Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions. The solution must not affect the chain of log sequence
numbers (LSNs).
Which code segment should you execute?
Which tool should you use?
You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?
You need to reduce the amount of time it takes to execu…
Which advanced server option should you modify?
You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?
You need to create one index to minimize the amount of …
You have a database that contains three tables. The tables are configured as shown in the following table.
You have the following query:
The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)
You need to create one index to minimize the amount of time it takes to execute the query.
What should you do?
To answer, drag the appropriate columns to the correct locations in the answer area. (Answer choices may be
used once, more than once, or not at all.)
Select and Place:
Which function is required in the view definition?
You need to create an indexed view that contains an aggregation.
Which function is required in the view definition?
Which transaction isolation level should you use in sp1?
You use SQL Server 2012 to store data used by an e-commerce application.
You develop a stored procedure named sp1. Sp1 is used to read the price of all the products sold on the ecommerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the price of a product.
Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?