Free Microsoft 70-762 Exam Dumps Questions & Answers

You have a database with multiple tables. You must insert data into the tables by using views.
Which of the following two statements best describes an updatable view?
NOTE: Each correct selection is worth one point.

• A.The view may include a composite field.
• B.The view must not include subqueries.
• C.The view must not include the primary key of the table.
• D.The view may include GROUP BY or HAVING statements.
• E.Each view must reference columns from one table.

Note: The 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 question in the series. Information and details provided in a question apply only to that question.
You have a database named DB1. The database does not have a memory optimized filegroup.
You create a table by running the following Transact-SQL statement:

The table is currently used for OLTP workloads. The analytics user group needs to perform real-time operational analytics that scan most of the records in the table to aggregate on a number of columns.
You need to add the most efficient index to support the analytics workload without changing the OLTP application.
What should you do?

• A.Create a nonclustered index on the table.
• B.Create a hash index on the table.
• C.Create a clustered index on the table.
• D.Create a nonclustered columnstore index on the table.
• E.Create a nonclustered filtered index on the table.
• F.Create a clustered columnstore index on the table.

You have a view that includes an aggregate.
You must be able to change the values of columns in the view. The changes must be reflected in the tables that the view uses.
You need to ensure that you can update the view.
What should you create?

• A.table-valued function
• B.a partitioned view
• C.a schema-bound view
• D.a DML trigger

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?

• 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 table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query named Users report that Query1 takes a long time to report results. You run and review the following statistics for an index seek operation:

You need to resolve the performance issue.
Solution: You rebuild the clustered index.
Does the solution meet the goal?

• A.No
• B.Yes