What should you recommend?

Correct Answer for the following Question is given below

Your network contains an Active Directory domain that has two groups named Group1 and Group2.The domain contains two SQL Server instances named SQLDev and SQLProd. Each SQL Server instance has access to various storage media.The SQL Server instances have a database that contains a table named Table1.Table1 contains a column named Column1. The value for Column1 can be either Value1 or Value2.You need to recommend a solution to ensure that users in Group1 can retrieve only rows from Column1 that contain the value of Value1.What should you recommend?A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data. Unless indexed, a view does not exist as a stored set of data values in a database. The rows and columns of data come from tables referenced in the query defining the view and are produced dynamically when the view is referenced.A view acts as a filter on the underlying tables referenced in the view.http://msdn.microsoft.com/en-us/library/ms190174.aspxIncorrect:Not A: Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.http://technet.microsoft.com/en-us/library/ms188754(v=sql.120).aspx

Question:

What should you recommend?

Options:

A dynamic management view

Filegroups

Snapshot isolation

User-defined views

Correct Answer

The Correct Answer for this Question is

User-defined views

Explanation

The Question – What should you recommend? has been answered correctly and answers for the question is User-defined views

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment