Transcription
Microsoft70-762Developing SQL Databaseshttp://killexams.com/exam-detail/70-762
QUESTION: 81You have a database named DB1. There is no memory-optimized file group in thedatabase. You have a table and a stored procedure that were created by running thefollowing Transact-SOL 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:What should you do?A. Create a clustered index on the table.B. Create a nonclustered index on the table.C. Create a nonclustered filtered index on the table.D. Create a clustered column store index on the table.E. Create a nonclustered column store index on the table.F. Create a hash index on the table.Answer: BQUESTION: 82DRAG DROPCase StudyBackgroundYou have a database named HR1 that includes a table named Employee.
You have several read-only, historical reports that contain regularly changing totals. Thereports 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 thedatabase 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 TableYou use the following Transact-SQL statements to create, configure, and populate theEmployee table:ApplicationYou have an application that updates the Employees table. The application calls thefollowing stored procedures simultaneously and asynchronously:The application uses views to control access to data. Views must meet the followingrequirements: Both of the stored procedures experience blocking issues.UspB must not abort if UspA commits changes to a row before UspB commits changesto the same row. UspA must not abort if UspB commits changes to a row before UspAcommits changes to the same row. ExhibitYou need to specify the transaction isolation levels to enable row versioning.How should you complete the Transact-SQL statements? To answer, drag the TransactSQL 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 scrollto view content.Answer:
QUESTION: 83HOTSPOT BackgroundYou have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. Thereports 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 thedatabase 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 TableYou use the following Transact-SOL statements to create, configure, and populate theEmployee table:
ApplicationYou have an application that updates the Employees table. The application calls thefollowing stored procedures simultaneously and asynchronously:The application uses views to control access to data. Views must meet the followingrequirements: Users must only be able to modify data in the Employee table by using thevwEmployee view. You must prevent users from viewing the view definition in catalogviews. You need to identify the view attribute to use when creating vwEmployee.ExhibitIn the table below, identify the attributes that you must use. NOTE: Make only oneselection in each column.
Answer:QUESTION: 84BackgroundYou have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. Thereports 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 thedatabase 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 TableYou use the following Transact-SOL statements to create, configure, and populate theEmployee table:
ApplicationYou have an application that updates the Employees table. The application calls thefollowing stored procedures simultaneously and asynchronously:The application uses views to control access to data. Views must meet the followingrequirements: 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 aregenerated. You need to generate the reports more quickly.The database must not use additional resources. ExhibitWhat should you do?A. Update the transaction level of the report query session to READPAST.B. Modify the report queries to use the UNION statement to combine the results of twoor more queries.C. Set the READ COMMITTED SNAPSHOT database option to ON.D. Update the transaction level of the report query session to READ UNCOMMITTED.Answer: C
QUESTION: 85HOTSPOT BackgroundYou have a database named HR1 that includes a table named Employee.You have several read-only, historical reports that contain regularly changing totals. Thereports 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 thedatabase 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 TableYou use the following Transact-SOL statements to create, configure, and populate theEmployee table:ApplicationYou have an application that updates the Employees table. The application calls thefollowing stored procedures simultaneously and asynchronously:The application uses views to control access to data. Views must meet the followingrequirements: You view the Deadlock Graph as shown in the exhibit. (Click the Exhibitbutton .)Use the drop-down menus to select the answer choice that answers each question basedon the information presented in the graphic.NOTE: Each correct selection is worth one point.
Answer:
For More exams visit https://killexams.com/vendors-exam-listKill your exam at First Attempt.Guaranteed!
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 issue
