H&S Quiz

Which date filters are we using in the H&S Dashboard?

• Last 6 months

• Last 2 years

• Last 15 months

• Last 12 months

• Last month

Answer explanation

the filter is from 2022-01-01. The report was created on January, but right now we are almost in April!

How many joins do we have in our H&S SSMS Query?

• 2

• 5

• 6

• 3

• 4

From which partitioned view are we pulling the data used on the H&S Request View? (excluding views used on the joins)

• SystemUser_Partitioned

• Incident_partitioned

• CRMTeam_Partitioned

• Account_Partitioned

Which of the joins was more difficult to implement?

• niq_crmteam

• niq_recordtype

• incident

• createdby

How many Visuals do we have on our report?

• 3

• 5

• 6

• 4

Answer explanation

Here we are not counting the slicers, that technically will count as a visual on this tab!

If we want to see the requests that are assigned to our team, which filter do we have to use?

• Business Functional Unit

• CRM Team

• Subject

• Third Type

• Owner

Why do we have a request record count on the table?

• To check if powerBI is pulling all the requests

• To check if there are duplicates

• To check if a request is unassigned

• To check if all the requests are completed