Report Governance: Data Dictionary, Row Security and Pivots — Assessment

1. Why can reports only join along declared relations?

Because joins are a paid add-on Joining on the workspace alone would multiply rows and give wrong totals To save storage To hide columns

2. What is the column limit on a pivot?

No limit 12 24 100

3. A row security rule uses the viewer’s department, and the viewer has none. What do they see?

No rows Every department Only their own records An error page

4. Who is exempt from row security rules?

Everyone with View reports People with Manage all reports The dataset owner only Nobody

5. What happens when someone exports a report holding sensitive fields?

The export is blocked They give a reason and the file is watermarked An Admin must export it The sensitive columns are deleted

6. What does the AI report draft see?

The first 100 rows The last saved report The dataset’s column names and types only All datasets in the workspace

Your details for the certificate

This is the name that will appear on your certificate.

Full name

Email

We email your result to this address with a link to confirm it is yours. If you are signed in, or once you confirm, the administrators of an organisation this email belongs to on AWRA OpsHub can see your attempts and certificate. Your name is as you type it here; only the email is confirmed.

Send me AWRA’s monthly email: new guides, product updates and courses. Unsubscribe anytime.

Graded server-side. No peeking at answers in the page source.