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 -You view the Deadlock Graph as shown in the exhibit. (Click the Exhibit tab.)Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.NOTE: Each correct selection is worth one point.Hot Area:
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 partition the largest tables.Does this 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 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?
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 create a file group for the indexes and a file group for the data files. You store the files for each file group on separate disks.Does this 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 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 3-TB database. The database server has 64 CPU cores.You plan to migrate the database to Microsoft Azure SQL Database.You need to select the service tier for the Azure SQL database. The solution must meet or exceed the current processing capacity.Solution: You select the Premium service tier.Does this 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 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 3-TB database. The database server has 64 CPU cores.You plan to migrate the database to Microsoft Azure SQL Database.You need to select the service tier for the Azure SQL database. The solution must meet or exceed the current processing capacity.Solution: You select the Standard service tier.Does this meet the goal?
