Free SAP C-THR92-2311 Exam Dumps Questions & Answers

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?

• A.  Change the join type to Left Outer Join.
• B.  Change the join type to Inner Join.
• C.  Remove the related table and add it using the Show Related Tables command form the Action Menu.
• D.  Remove the related table and select and drag it from the Available Data section.

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.  Personal Information is joined to Address table with a left join and the Address table is joined to the Dependents table with a left join.
• B.  Personal Information is joined to Dependents table with a left join and the Dependents table is joined to the Address table with a left join.
• C.  Personal Information is joined to both the Dependents table and the Address table with an inner join.
• D.  Personal Information is joined to both the Dependents table and the Address table with a left join.

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?

• A.  Column Style Settings
• B.  Sum Function
• C.  Show Total Row
• D.  Group Columns

What provisioning setting must you enable to allow customers to upload a custom BIRT template to a Table Report?

• A.  Additional Adhoc Sub domain Schemas Configuration.
• B.  Enable Visual Publisher.
• C.  Enable Bl Publisher to BIRT Template Converter.
• D.  Allow Bl Publisher template upload.

You create a report page and want to change the grid column width and grid row height. Where can you do this?

• A.  Edit page properties
• B.  Edit designer properties
• C.  Validate page
• D.  Edit Query