C-THR92-2105 試験問題を無料オンラインアクセス

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?

• A.Inner
• B.Left
• C.Outer

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

In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager. When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.
How do you configure the query to return one row per employee that shows the employee's matrix manager when assigned?

• A.Change the Job Relationship to include a table restriction.
• B.Change the Job Relationship join to a left join.
• C.Change the Job Relationship join to an inner join.
• D.Change the Job Relationship join to a right join.

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.

• A.Show All
• B.Current Date
• C.Date Range (On Start Date) with a date range from Today to Today
• D.As of Date with a dynamic date value of Today

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.Remove the related table and add it using the Show Related Tables command form the Action Menu.
• B.Remove the related table and select and drag it from the Available Data section.
• C.Change the join type to Inner Join.
• D.Change the join type to Left Outer Join.