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?
Which tool can you use to upload a report from the test instance to the production instance?
Note: There are 2 correct answers to this question.
A report shows one row for each language an employee speaks. The employee information "First name" and "Last name" is repeated for each language on each row.
Which format option allows you to display the employee information "First name" and "Last name" only once for each employee?
You are configuring a story report. You add the image widget to the top-left corner of the canvas. You then upload the SuccessFactors logo in the Builder and select the logo image so it displays on the canvas. When you preview the report in View Mode, the logo appears centered on the canvas.
What action do you take so the Logo appears in the top-left corner when viewing the report in view mode?
You are building a performance report. In reviewing the Performance Management schema, you notice that the 2019 Performance Review Table is listed in the Available Data section. You begin the query by adding the Basic User Information table from the User schema. You notice that the 2019 Performance Review Table is NO longer listed in the Available Data section.
Why is the 2019 Performance Review table NOT in the list?
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.
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?
In a canvas report, to which of the following can you export multipage reports in a single transaction?
Note: There are 3 correct answers to this question.
You want to create a query that shows only the current Job Information data for each employee.
On the Job Information table, which date type configurations can you use?
Note: There are 2 correct answers to this question.
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?
A user wants to build a pivot chart based on a list report that has a run-time filter.
What must the user do?
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?
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?
When you share a tile, how can the user view that tile?
Note: There are 3 correct answers to this question.
A table report is shared with a user. That user CANNOT see the table report in the Report Center list.
Which role-based permission has NOT been set correctly for this user?
Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.
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.
When you format a list report component, which actions can you perform?
Note: There are 3 correct answers to this question.
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.
User A schedules a report in Report Center Scheduler.
What can user A achieve by enabling the Job Completion notification option for a scheduled job in the Report Center Scheduler?