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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.A notification appears for the recipient of the report on the home page after the report distribution process is complete.
• B.An e-mail is sentto the recipient of the report that the report distribution process is complete with the report.
• C.A notification appears foruser A on the home page after the report distribution process is complete.
• D.An e-mail is sent to user A after the report distribution process is complete.

Comment: *

Name: *

Email: *

Verification: *

In the Advanced Reporting tool, you want to create a query that includesthe 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 join to a left join.
• B.Change the Job Relationship join to an inner join.
• C.Change the Job Relationship join to a right join.
• D.Change the Job Relationship to include a table restriction.

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: *

A user wants to build a pivot chart based on a list report that has a run-time filter.
What must the user do?

• A.Create the pivot chart before adding the run-time filter.
• B.Create a filter group within the run-time filter before building the report.
• C.Create the pivot chart after adding the run-time filter.
• D.Create the run-time filter before building the report.

Comment: *

Name: *

Email: *

Verification: *