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 FOR UPDATE trigger on the table.Does the solution meet the goal?
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 cascading referential integrity constraints on the table.Does the solution meet the goal?
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.The Account table was created by using the following Transact-SQL statement:There are more than 1 billion records in the Account table. The Account Number column uniquely identifies each account. The ProductCode column has 100 different values. The values are evenly distributed in the table. Table statistics are refreshed and up to date.You frequently run the following Transact-SQL SELECT statements:You must avoid table scans when you run the queries.You need to create one or more indexes for the table.Solution: You run the following Transact-SQL statement:CREATE NONCLUSTERED INDEX IX_Account_ProductCode ON Account(ProductCode);Does the solution meet the goal?
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 are developing a new application that uses a stored procedure. The stored procedure inserts thousands of records as a single batch into the Employees table.Users report that the application response time has worsened since the stored procedure was updated. You examine disk-related performance counters for theMicrosoft SQL Server instance and observe several high values that include a disk performance issue. You examine wait statistics and observe an unusually highWRITELOG value.You need to improve the application response time.Solution: You update the application to use implicit transactions when connecting to the database.Does the solution meet the goal?
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 are developing a new application that uses a stored procedure. The stored procedure inserts thousands of records as a single batch into the Employees table.Users report that the application response time has worsened since the stored procedure was updated. You examine disk-related performance counters for theMicrosoft SQL Server instance and observe several high values that include a disk performance issue. You examine wait statistics and observe an unusually highWRITELOG value.You need to improve the application response time.Solution: You add a unique clustered index to the Employees table.Does the solution meet the goal?
DRAG DROP -Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.You have a database named Sales that contains the following database tables: Customer, Order, and Products. The Products table and the Order table are shown in the following diagram.The customer table includes a column that stores the data for the last order that the customer placed.You plan to create a table named Leads. The Leads table is expected to contain approximately 20,000 records. Storage requirements for the Leads table must be minimized.Changes to the price of any product must be less a 25 percent increase from the current price. The shipping department must be notified about order and shipping details when an order is entered into the database.You need to implement the appropriate table objects.Which object should you use for each table? To answer, drag the appropriate objects to the correct tables. Each object may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.Select and Place:
