PrepAway - Latest Free Exam Questions & Answers

Which item should you configure?

HOTSPOT
A school stores information about teachers, students, classes, and enrollments in a
Microsoft Azure SQL Database database. The database includes a table that maps the user
IDs of teachers to the subjects they teach.

Teachers access reports in a SQL Server Reporting Services (SSRS) instance by using their credentials.
You are developing a report that displays a table of class enrollments for a specific subject.
The report will prompt teachers to select from their mapped subjects. The table is based on
a dataset named ClassData. To minimize report execution time, the ClassData dataset has
been configured to cache all class enrollment data.
You need to ensure that the report displays the correct class enrollment data.
Which item should you configure?
To answer, select the appropriate item in the answer area.

PrepAway - Latest Free Exam Questions & Answers

Answer:

4 Comments on “Which item should you configure?

  1. jak says:

    think classdata should be marked.

    So first teacher opens report -> enters credentials
    then he is prompted for subjects , now the subjects are retrieved from teacher subjects which is based on the credential that is entered.
    Teacher selects subject and runs the report, class enrollmentdata is shown, so i Would say ClassData needs to be configured to show correct data for each teacher’s subject.




    0



    0
  2. Mahmoud Ibrahim says:

    “The report will prompt teachers to select from their mapped subjects” the parameter is mapped to the dataset, answer is classdata as you will be need to filter by Teachers




    0



    0

Leave a Reply