You run the following Transact-SQL statement:

There are multiple unique OrderlD values. Most of the UnitPrice values for the same OrderlD are different.
You need to create a single index seek query that does not use the following operators:
*Nested loop
*Sort
*Key lookup

• A. CREATE INDEX IX_OrderLines_l ON OrderLines (UnitPrice, OrderlD) INCLUDE(Description, Quantity)
• B. CREATE INDEX IX_OrderLines_l ON OrderLines (OrderlD, UnitPrice, Quantity)
• C. CREATE INDEX IX_OrderLines_l ON OrderLines (OrderlD, UnitPrice) INCLUOE(Quantity)
• D. CREATE INDEX IX_OrderLines_l ON OrderLines (OrderlD, UnitPrice) INCLUDE(Description, Quantity)

You have the following stored procedure that is called by other stored procedures and applications:

You need to modify the stored procedure to meet the following requirements:
* Always return a value to the caller.
* Return 0 if @Status is NULL.
* Callers must be able to use @Status as a variable.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A. Add a SELECT statement to return @Status.
• B. Add a RETURN statement.
• C. Replace NULL values with 0. Add an output parameter to return @Status.
• D. Replace NULL values with 0. Add a PRINT statement to return @Status.
• E. Replace NULL values with 0. Add a SELECT statement to return @Status.
• F. Add a PRINT statement.
• G. Add an output parameter to return @Status.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database named dbReporting. Users run a large number of read-only ad hoc queries against the database. The application and all ad hoc queries use default database transaction isolation levels. You set the value of the READ_COMMITTED_SNAPSHOT database option to ON.
You have an application that updates 10 tables sequentially and modifies a large volume of records in a single transaction. The updates are isolated from each other.
Users report an error which indicates that the version store us full.
You need to reduce the number of occurrences of the error.
Solution: You increase the maximum database size for the dbReporting database.
Does the solution meet the goal?

• A. No
• B. Yes

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a database that is 130 GB and contains 500 million rows of data.
Granular transactions and mass batch data imports change the database frequently throughout the day.
Microsoft SQL Server Reporting Services (SSRS) uses the database to generate various reports by using several filters.
You discover that some reports time out before they complete.
You need to reduce the likelihood that the reports will time out.
Solution: You change the transaction log file size to expand dynamically in increments of 200 MB.
Does this meet the goal?

• A. No
• B. Yes

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stores information about the employees of your company.
You need to implement and enforce the following business rules:
* Limit the values that are accepted by the Salary column.
* Prevent salaries less than $15,000 and greater than $300,000 from being entered.
* Determine valid values by using logical expressions.
* Do not validate data integrity when running DELETE statements.
Solution: You implement a foreign key on the table.
Does the solution meet the goal?

• A. No
• B. Yes