Black Friday Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

When you format a list report component, which actions can you perform?

Note: There are 3 correct answers to this question.

A.

Change column types.

B.

Change column headers.

C.

Change the order of columns.

D.

Adjust column widths.

E.

Save formats to a template.

Full Access
Question # 5

Why would you export report definitions?

Note: There are 2 correct answers to this question.

A.

To distribute reports to report consumers

B.

To move reports between company instances

C.

To support report version control

D.

To schedule reports for offline execution

Full Access
Question # 6

A manager changed jobs and subsequently lost access to a custom tile-based dashboard.

What functionality would an administrator use to restore access?

Note: There are 2 correct answers to this question.

A.

Dynamic Groups

B.

Manage Report Center

C.

Role Based permission Groups

D.

Role Maintenance

Full Access
Question # 7

How do you configure the Builder to display the table in the screenshot in a story report? Note: There are 3 correct answers to this question. Headcount by Location

A.

Row: Count

B.

Table Structure: Aggregated List

C.

Column: Count

D.

Table Structure: Cross-tab

Full Access
Question # 8

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.

The result of the formula is negative.

B.

An incorrect data type has been selected.

C.

An incorrect dynamic date variable has been used.

D.

An "if then else" statement needs to be included.

Full Access
Question # 9

In a live data query, what are user-prompted filter types?

Note: There are 2 correct answers to this question.

A.

Runtime

B.

People Scope

C.

Filter Groups

D.

Dynamic

Full Access
Question # 10

Which actions can you perform in a Simple Text component?

Note: There are 3 correct answers to this question.

A.

Select the font, font size, and font style options for the text.

B.

Select an image to display inline within text.

C.

Select the background color, numeric list options, and indentation for the text.

D.

Add a link to an existing canvas report.

E.

Upload an image to display before or after the text.

Full Access
Question # 11

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria

• Only show one row per employee,

• Only show the pay components Base Salary and Bonus,

• Show these pay components as individual columns.

You have joined the Global Job Information table with the Compensation table.What else must you do?

Note: There are 2 correct answers to this question.

A.

Configure a table restriction of the Compensation table.

B.

Duplicate the Compensation table.

C.

Configure a table restriction of the Global Job Information table.

D.

Change the table join to the Compensation table to an inner join.

Full Access
Question # 12

You want to create a pie chart of your company's headcount by country. For each slice you want to display the proportion by country and the country name. Which formatting options must you select?

Note: There are 2 correct answers to this question.

A.

Use Smart Labels

B.

Percent of Total

C.

Chart type: Area

D.

Rolling Averaqe

Full Access
Question # 13

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

A.

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.

B.

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.

C.

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.

D.

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.

Full Access
Question # 14

In addition to any chart filter you may have applied to your chart, which other filters may be affecting the chart filter, due to the Cascading effect?

Note: There are 2 correct answers to this question.

A.

Story

B.

Table

C.

Query

D.

Page

Full Access
Question # 15

Why is it important to consider the People step of the report definition when you share a table report with another user?

A.

The user may NOT have access to the fields in the report.

B.

The user may NOT have access to run reports.

C.

The user may NOT have the same line of sight.

D.

The user may NOT have access to the relevant report domain.

Full Access
Question # 16

How do you configure the Builder to display the chart in the screenshot in a story report?

Note: There are 3 correct answers to this question.

A.

Set Dimensions to Pay Grade

B.

Set Color to Pay Grade

C.

Set Dimensions to Gender

D.

Set Measures to EOP Headcount

E.

Set Color to Gender

Full Access
Question # 17

When a user builds a query, what is the default People Scope of the query?

A.

All Reports of the logged-in user

B.

All employees in the department of the logged-in user

C.

Direct Reports of the logged-in user

D.

The matrix reports of the logged-in user

Full Access
Question # 18

You want to create a report that shows one row per employee, that includes the total number of previous employers for each employee.

Which tool must you use?

A.

Calculated Columns

B.

Runtime Filters

C.

Aggregated Calculated Columns

D.

Date Options

Full Access
Question # 19

When using Report Center, what permissions are required to create a canvas report on Employee Profile data using the Detailed Reporting tool?

Note: There are 3 correct answers to this question.

A.

Report Center

B.

Report - Canvas Designer

C.

Create Reports: Employee Profile

D.

Report - Canvas Designer Admin

E.

Run Report: Employee Profile

Full Access
Question # 20

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.

Show Total Row

B.

Column Style Settings

C.

Sum Function

D.

Group Columns

Full Access
Question # 21

You want to create a page in a canvas report that includes a custom image, a user editable title centered underneath the image, and the current date in the top-right corner.

Which combinations of components can you use to accomplish this?

Note: There are 2 correct answers to this question.

A.

1 custom image component, 2 rich text components

B.

1 custom image component, 1 rich text component

C.

1 custom image component, 1 rich text component, 1 simple text component

D.

1 custom image component, 1 simple text component

Full Access
Question # 22

Which are valid destinations of a scheduled Report Distributor bundle?

Note: There are 3 correct answers to this question.

A.

Home Page

B.

FTP

C.

Notification

D.

Run Offline

E.

E-Mail

Full Access
Question # 23

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.

As of Date with a dynamic date value of Today

C.

Date Range (On Start Date) with a date range from Today to Today

D.

Current Date

Full Access