Q18. You are creating a Story report on Job Classifications. You have configured the chart, table, and input control on the canvas as displayed in the screenshot.

How do you set the input control?

Q19. What are the steps to create and assign a date filter to a tile?

Q20. While constructing a dashboard, you find that you need to create a tile that requires more complex
configuration than what is available with the Online Tile Builder tool.
What tool can you use to create this tile?

Q21. You want to join two tables, A and B, and you want to include all rows from Table A, and only matching
rows from Table B. Which join type must you use?

Q22. You are creating a calculated column to calculate an employee’s organizational tenure.

Why does the formula in the screenshot result in an error?

Q23. You create a query using the Basic User Information table. After you add the Proxy Information table,
you notice that some of the basic information records are NO longer displayed in the preview.
How do you adjust the query to return the missing records in the preview?

Q24. You have created a custom MDF object to track company car information. You need to be able to create
story reports on the data of the custom MDF object.
What must you do to enable a custom MDF object to be listed in the Available Data section of Query
Designer?

Q25. You are using Report Center to share a canvas report. You share the report with a Dynamic Group (see attached image).

Who is the report shared with?

Q26. In addition to any chart filter you may have applied to your chart, which other filters may be affecting the chart filter, due to the Cascading effect?
Note: There are 2 correct answers to this question.

Q27. The data source used by the two tables only displays current (active) employees.
How would you configure a filter on the table End of Previous Year Headcount by Location to display data accurately?

Note: There are 2 correct answers to this question.

Q28. You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.

Q29. You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.

What are the reasons?

Q30. You are creating a query that lists employee information such as name, address, and dependent
information. The query uses Personal Information as the driving table and joins the Dependents and
Address tables. You notice many employees are missing from the result set.

What are the reasons?

Q31. You have created a custom MDF object to track company car information. You need to be able to create story reports on the data of the custom MDF object.
What must you do to enable a custom MDF object to be listed in the Available Data section of Query Designer?

Q32. Which are valid destinations of a scheduled Report Distributor bundle?

Note: There are 3 correct answers to this question.

Q33. The drill-down list of a tile contains more entries than the values displayed in a chart (see attached image).

How do you make the outputs match?

Q34. When you format a list report component, which actions can you perform?
Note: There are 3 correct answers to this question.

Q35. You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.

When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.

Q36. User A maintains a canvas report of employee contact information. User A leaves the company. Another report designer, user B, is assigned the responsibility to maintain the report, but currently CANNOT modify the report.
How do you allow user B to modify only this report?

Q37. A report consumer claims that a canvas report shared with them is NO longer available in Report Center. Upon your investigation, you find the report has been deleted. You need to reproduce the report as quickly as possible.
What action do you take?