Q44. 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.

Q45. 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.

Q46. You are using a Multi Dataset table report without Business Intelligence Reporting Tools (BIRT).
What are characteristics of the report output?
Note: There are 2 correct answers to this question.

Q47. You want to build a query for a cross-domain report.
What does the system do with fields that are NOT available for this report?

Q48. 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?

Q49. 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?

Q50. When you create a table report with filter groups, what is the logical relationship between filter groups?

Q51. 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?

Q52. When you use a column of type text as a measure in a pivot query, which of the following pivot functions are available?
Note: There are 2 correct answers to this question.

Q53. When constructing an expression for a calculated column, which syntax should you use to enter a date?

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

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

Q55. You are using a pivot table in your canvas report but the report does NOT display the most recent data.
What could be the reason?

Q56. 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?

Q57. You want to create a page in a canvas report that includes a custom image, a user editable title centered underneath the image, and the current date in the top-right corner.
Which combinations of components can you use to accomplish this?
Note: There are 2 correct answers to this question.

Q58. You want to create a query that includes information about an employee’s current job, as well as information such as name and date of birth.
How do you do this?
Note: There are 2 correct answers to this question.

Q59. Where can you obtain the latest versions of the standard report templates provided by SAP Success Factors?