What should you do?

Correct Answer for the following Question is given below

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse; and the dimDistrict table contains information about sales districts. The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters.You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts.What should you do?

Question:

What should you do?

Options:

Add a district column to the dimUser table.

Partition the factSales table on the district column.

Create a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.

For each district, create a view of the factSales table that includes a WHERE clause for the district.

Correct Answer

The Correct Answer for this Question is

Create a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.

Explanation

The Question – What should you do? has been answered correctly and answers for the question is Create a userDistrict table that contains primary key columns from the dimUser and dimDistrict tables.

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