Prism Analytics

Prism Analytics practice questions, page 2 of 2, with answer review and explanations.

Question 6

You want to use a custom report containing prompts as a source connection for a table.What must you ensure to make this possible?

  1. The prompts are mapped at the data change task level.
  2. The report is built on an indexed data source.
  3. The prompts are marked as required.
  4. The custom report prompts have default values assigned on the report definition.

Question 7

A consultant needs to update a table in Prism Analytics with the latest data from an uploaded CSV file. The CSV file contains new salary information for both existing and new employees since the last update.What table operation should the consultant use to update the table?

  1. Truncate and Insert
  2. Upsert
  3. Update
  4. Insert

Question 8

What must you do to blend Workday instance data with external text data?

  1. Import a text equivalent field that represents the text value of the instance field.
  2. Change the field type from instance to text in Prism using a Manage Fields stage.
  3. Use an external mapping file to map the instance field to a text field.
  4. Add the instance field to the external dataset using Prism calculated fields.

Question 9

A Prism data writer needs to create a new Prism calculated field on a derived dataset using the CASE function.When creating a calculated field, what symbol do you use to view a list of fields that you can select from in the dataset?

  1. {
  2. #
  3. [
  4. (

Question 10

What window function returns the number of rows within a window?

  1. COUNT
  2. MAX
  3. SUM
  4. AVG