DRAG DROP -You must create two staging database tables. The tables have the following requirements:You need to select the correct storage mechanism for each table.Which storage mechanism should you use? To answer, drag the appropriate table types to the correct tables. Each table type 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:
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.You have a database named DB1. There is no memory-optimized filegroup in the database.You have a table and a stored procedure that were created by running the following Transact-SQL statements:The Employee table is persisted on disk. You add 2,000 records to the Employee table.You need to create an index that meets the following requirements:✑ Optimizes the performance of the stored procedure.✑ Covers all the columns required from the Employee table.✑ Uses FirstName and LastName as included columns.✑ Minimizes index storage size and index key size.What should you do?
Case Study -Background -You have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. The reports use multiple queries to estimate payroll expenses. The queries run concurrently. Users report that the payroll estimate reports do not always run. You must monitor the database to identify issues that prevent the reports from running.You plan to deploy the application to a database server that supports other applications. You must minimize the amount of storage that the database requires.Employee Table -You use the following Transact-SQL statements to create, configure, and populate the Employee table:Application -You have an application that updates the Employees table. The application calls the following stored procedures simultaneously and asynchronously:✑ UspA: This stored procedure updates only the EmployeeStatus column.✑ UspB: This stored procedure updates only the EmployeePayRate column.The application uses views to control access to data. Views must meet the following requirements:✑ Allow users access to all columns in the tables that the view accesses.✑ Restrict updates to only the rows that the view returns.Exhibit -Both of the stored procedures experience blocking issues. UspB must not abort if UspA commits changes to a row before UspB commits changes to the same row. UspA must not abort if UspB commits changes to a row before UspA commits changes to the same row.You need to specify the transaction isolation levels to enable row versioning.How should you complete the Transact-SQL statements? To answer, drag the Transact-SQL segments to the correct locations. Each Transact-SQL segment 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:
HOTSPOT -Background -You have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. The reports use multiple queries to estimate payroll expenses. The queries run concurrently. Users report that the payroll estimate reports do not always run. You must monitor the database to identify issues that prevent the reports from running.You plan to deploy the application to a database server that supports other applications. You must minimize the amount of storage that the database requires.Employee Table -You use the following Transact-SQL statements to create, configure, and populate the Employee table:Application -You have an application that updates the Employees table. The application calls the following stored procedures simultaneously and asynchronously:✑ UspA: This stored procedure updates only the EmployeeStatus column.✑ UspB: This stored procedure updates only the EmployeePayRate column.The application uses views to control access to data. Views must meet the following requirements:✑ Allow users access to all columns in the tables that the view accesses.✑ Restrict updates to only the rows that the view returns.Exhibit -Users must only be able to modify data in the Employee table by using the vwEmployee view. You must prevent users from viewing the view definition in catalog views.You need to identify the view attribute to use when creating vwEmployee.In the table below, identify the attributes that you must use.NOTE: Make only one selection in each column.Hot Area:
Background -You have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. The reports use multiple queries to estimate payroll expenses. The queries run concurrently. Users report that the payroll estimate reports do not always run. You must monitor the database to identify issues that prevent the reports from running.You plan to deploy the application to a database server that supports other applications. You must minimize the amount of storage that the database requires.Employee Table -You use the following Transact-SQL statements to create, configure, and populate the Employee table:Application -You have an application that updates the Employees table. The application calls the following stored procedures simultaneously and asynchronously:✑ UspA: This stored procedure updates only the EmployeeStatus column.✑ UspB: This stored procedure updates only the EmployeePayRate column.The application uses views to control access to data. Views must meet the following requirements:✑ Allow users access to all columns in the tables that the view accesses.✑ Restrict updates to only the rows that the view returns.Exhibit -You are analyzing the performance of the database environment. You discover that locks that are held for a long period of time as the reports are generated.You need to generate the reports more quickly. The database must not use additional resources.What should you do?
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:
