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

Comment: *

Name: *

Email: *

Verification: *

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

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

• A.An incorrect data type has been selected.
• B.An incorrect dynamic date variable has been used.
• C.An "if then else" statement needs to be included.
• D.The result of the formula is negative.

Comment: *

Name: *

Email: *

Verification: *

You are using Report Center to share a canvas report. You share the report with a Dynamic Group (see attached image).

Who is the report shared with?

• A.Employees of the Sales departments and all employees of Atlanta
• B.Employees of the Sales department of Atlanta
• C.Employees of Atlanta
• D.Employees of the Sales department

Comment: *

Name: *

Email: *

Verification: *

What is included in the saved state of a bookmark for a Story report?
Note: There are 3 correct answers to this question.

• A.Input controls
• B.Comments
• C.Prompts
• D.Filters
• E.Data

Comment: *

Name: *

Email: *

Verification: *

What are the steps to create and assign a date filter to a tile?

• A.1. Enable the date filter in the tile.
  2. Create a new date range.
  3. Configure the Name, label and date from/date to.
  4. Configure end user free selection of date range.
• B.1. Enable the date filter in the tile.
  2. Access Date Options.
  3. Configure date type to Date Range.
  4. Configure the date from/date to.
  5. Configure end user free selection of date range.
• C.1. Create a new date range.
  2. Configure the Name, label and date from/date to.
  3. Enable the date filter in the tile.
  4. Configure end user free selection of date range.
• D.1. Access Date Options.
  2. Configure the date type to Date Range.
  3. Configure the date from/date to.
  4. Enable the date filter in the tile.
  5. Configure end user free selection of date range.

Comment: *

Name: *

Email: *

Verification: *