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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.You are using a query with a static date filter.
• B.You are using the percent of total option.
• C.You are NOT using a template.
• D.You are using a wrong People Scope.

Comment: *

Name: *

Email: *

Verification: *

What permission type applied to table reports is defined by a combination of the user's View permissions and Target Population in role-based permissions?

• A.Row level permission
• B.Run report permission
• C.Field level permission
• D.Cell level permission

Comment: *

Name: *

Email: *

Verification: *

Why would you export report definitions?
Note: There are 2 correct answers to this question.

• A.To support report version control
• B.To move reports between company instances
• C.To schedule reports for offline execution
• D.To distribute reports to report consumers

Comment: *

Name: *

Email: *

Verification: *

You want to return the quarter to date event records to count terminations.
Which options would you set in the time filter?
Note: There are 3 correct answers to this question.

• A.Range period: Actual start/end date of the current quarter
• B.Records Returned: Include only records that begin in your defined date range
• C.Range Type: fixed
• D.Range Type: dynamic
• E.Range Parameters: Period to Date

Comment: *

Name: *

Email: *

Verification: *