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 Global Job Information table.
• B.Duplicate the Compensation table.
• C.Configure a table restriction of the Compensation table.
• D.Change the table join to the Compensation table to an inner join.

Comment: *

Name: *

Email: *

Verification: *

While constructing a dashboard, you find that you need to create a tile that requires more complex configuration than what is available with the Online Tile Builder tool. What tool can you use to create this tile?

• A.PDFSam
• B.Business Intelligence Reporting Tool (BIRT)
• C.LMS Report Designer
• D.YouCalc designer

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

What are the requirements for a custom block in People Profile to be reportable in a Story?Note: There are 2 correct answers to this question.

• A.The MDF object must NOT be linked to another schema.
• B.The MDF object must have an externalCode of datatype Generic Object.
• C.The MDF object must be linked to a schema as a root object.
• D.The MDF object must have an externalCode of datatype User.

Comment: *

Name: *

Email: *

Verification: *