Get Free Microsoft 70-761 Exam PDF Braindumps With Verified Question Answers By Realexamdumps.com

Question: 1

You need to create an indexed view that requires logic statements to manipulate the data that the view displays.Which two database objects should you use? Each correct answer presents a complete solution.

A. a user-defined table-valued function
B. a CRL function
C. a stored procedure
D. a user-defined scalar function

Answer: A,C 

Question: 2

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 question 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 are creating indexes in a data warehouse.You have a dimension table named Table1 that has 10,000 rows. The rows are used to generate several reports.The reports join a column that is the primary key.The execution plan contains bookmark lookups for Table1.You discover that the reports run slower than expected.You need to reduce the amount of time it takes to run the reports.
Solution: You create a nonclustered index on the primary key column that includes the bookmark lookup columns.Does this meet the goal?

A. Yes
B. No

Answer: B 


QUESTION 3

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 that is denormalized. Users make frequent changes to data in a primary table. You need to ensure that users cannot change the tables directly, and that changes made to the primary table also update any related tables.What should you implement?

A. the COALESCE function
B. a view
C. a table-valued function
D. the TRY PARSE function
E. a stored procedure
F. the ISNULL function
G. a scalar function
H. the TRY CONVERT function

Answer: B

Explanation:
Using an Indexed View would allow you to keep your base data in properly normalized tables and
maintain data-integrity while giving you the denormalized "view" of that data.

References:
http://stackoverflow.com/questions/4789091/updating-redundant- denormalizeddata-automatically-in-sql-server


QUESTION 4

You are developing a Microsoft SQL Server database.You create a view that performs the following tasks:Joins 10 tables that contain up to 400,000 records each.
Performs aggregations on 4 fields.The view is frequently used in several detailed reports.You need to improve the performance of the reports. What should you do?

A. Convert the view into a table-valued function
B. Convert the view into an indexed view
C. Convert the view into a stored procedure and retrieve the result from the stored procedure into a
temporary table
D. Convert the view into a Common Table Expression (CTE)

Answer: B

Explanation:
The first index created on a view must be a unique clustered index. After the unique clustered
index has been created, you can create more nonclustered indexes. Creating a unique clustered
index on a view improves query performance because the view is stored in the database in the
same way a table with a clustered index is stored. The query optimizer may use indexed views to
speed up the query execution. The view does not have to be referenced in the query for the
optimizer to consider that view for a substitution.

QUESTION 5

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 that is denormalized. Users make frequent changes to data in a primary table. You need to ensure that users cannot change the tables directly, and that changes made to the primary table also update any related tables. What should you implement?

A. the COALESCE function
B. a view
C. a table-valued function
D. the TRY PARSE function
E. a stored procedure
F. the ISNULL function
G. a scalar function
H. the TRY CONVERT function

Answer: B

Explanation:
Using an Indexed View would allow you to keep your base data in properly normalized tables and
maintain data-integrity while giving you the denormalized "view" of that data.

References:
http://stackoverflow.com/questions/4789091/updating-redundant- denormalizeddata-automatically-in-sql-server

Get Free Microsoft 70-761 Exam PDF Braindumps With Verified Question Answers By Realexamdumps.com