Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.

• A.Date fields
• B.Picklist fields
• C.Number fields
• D.Currency fields

Comment: *

Name: *

Email: *

Verification: *

You want to create a report that shows one row per employee, that includes the total number of previous employers for each employee.
Which tool must you use?

• A.Date Options
• B.Aggregated Calculated Columns
• C.Calculated Columns
• D.Runtime Filters

Comment: *

Name: *

Email: *

Verification: *

Which tool can you use to create tiles offline?

• A.Advance Reporting
• B.Query Workspace
• C.Detailed Reporting
• D.YouCalc Designer

Comment: *

Name: *

Email: *

Verification: *

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria
* Only show one row per employee,
* Only show the pay components Base Salary and Bonus,
* Show these pay components as individual columns.
You have joined the Global Job Information table with the Compensation table.What else must you do?

Note: There are 2 correct answers to this question.

• A.Configure a table restriction of the Global Job Information table.
• B.Configure a table restriction of the Compensation table.
• C.Change the table join to the Compensation table to an inner join.
• D.Duplicate the Compensation table.

Comment: *

Name: *

Email: *

Verification: *

Which actions can you permit the report consumer to perform by your configuration of Interactive widgets?
Note: There are 3 correct answers to this question.

• A.Switch between edit and view mode.
• B.Add/delete widgets.
• C.Show/hide labels.
• D.Adjust filters within controls.
• E.Freeze table rows/columns.

Comment: *

Name: *

Email: *

Verification: *