Free Workday Workday-Pro-Integrations Practice Exam with Questions & Answers | Set: 2

To create a connector-based integration with additional custom configurations such as dynamic file naming and internal-to-external value mapping, the following steps must be followed:

Enable Needed Integration Services:

This step involves activating the required integration services to ensure that the necessary API calls, security, and processing capabilities are available within Workday.

Configure Integration Field Attributes:

Integration Field Attributes allow customization of fields within the integration, enabling changes to formats, mappings, and transformations, such as including a dynamically generated file name with the current date and integration run number.

Configure Integration Maps:

Integration Maps are used to transform internal values into external values as per the vendor’s requirements. This ensures that data fields in Workday align correctly with external system specifications.

Configure Sequence Generator:

The Sequence Generator is used to append unique identifiers to output files, ensuring each integration run produces a uniquely named file (e.g., including the current date and run number).

This workflow ensures that the integration is set up efficiently while meeting the vendor’s additional configuration needs.

References:Workday Advanced Business Process documentation

The scenario involves a Core Connector: Worker integration using the Data Initialization Service (DIS) to export a full file of employee personal data. The vendor requires marital status values to be transformed from Workday’s internal text values (e.g., "Married," "Single") to a specific list of codes (e.g., "M," "S"), and any Workday value not matching the vendor’s list should output "OTHER." Let’s analyze the configuration:

Requirement:Transform the "Marital Status" field values into vendor-specific codes, with a fallback to "OTHER" for unmapped values. This is a field-level transformation, common in Core Connectors when aligning Workday data with external system requirements.

Integration Maps:In Core Connectors,Integration Mapsare the primary tool for transforming field values. You create a map that defines source values (Workday’s marital status text) and target values (vendor’s codes). The "Default" setting in an integration map specifies what value to output if a Workday value isn’t explicitly mapped. Here, setting the default to "OTHER" ensures that any marital status not in the vendor’s list (e.g., a new Workday value like "Civil Union" not recognized by the vendor) is output as "OTHER."

Option Analysis:

A. Configure Integration Maps with a blank Default: Incorrect. A blank default would leave the field empty or pass the original Workday value for unmapped cases, not "OTHER," failing the requirement.

B. Configure Integration Attributes with a blank Default: Incorrect. Integration Attributes define integration-level settings (e.g., file name, delivery method), not field value transformations. They don’t support mapping or defaults for specific fields like marital status.

C. Configure Integration Maps with "OTHER" as a Default: Correct. This uses Integration Maps to map Workday values to vendor codes and sets "OTHER" as the default for unmapped values, meeting the requirement fully.

D. Configure Integration Attributes with "OTHER" as a Default: Incorrect. Integration Attributes don’t handle field-level transformations or defaults for data values, making this option inapplicable.

Implementation:

Edit the Core Connector: Worker integration.

Use the related actionConfigure Integration Maps.

Create a map for the "Marital Status" field (e.g., "Married" → "M," "Single" → "S").

Set theDefault Valueto "OTHER" in the map configuration.

Test the output to ensure mapped values use vendor codes and unmapped values return "OTHER."

References from Workday Pro Integrations Study Guide:

Core Connectors & Document Transformation: Section on "Configuring Integration Maps" explains mapping field values and using defaults for unmapped cases.

Integration System Fundamentals: Highlights how Core Connectors transform data to meet vendor specifications.

The requirement is to filter a custom report to show only workers terminated after a user-prompted date. In Workday, filters are defined in the Filter tab of the custom report definition, and conditions can be combined using AND/OR logic to refine the dataset. Let’s analyze the requirement and options:

Key Conditions:

Workers must beterminated, so the "Worker Status" field must equal "Terminated."

The termination must occuraftera user-specified date, so the "Termination Date" must be greater than the prompted value.

Both conditions must be true for a worker to appear in the report, requiring anANDcombination.

Option Analysis:

A. Worker Status is equal to the value "Terminated" OR Termination Date is greater than a value retrieved from a prompt: Incorrect. Using OR means the report would include workers who are terminated (regardless of date) OR workers with a termination date after the prompt (even if not terminated), which doesn’t meet the strict requirement of terminated workers after a specific date.

B. Worker Status is equal to the value retrieved from a prompt AND Termination Date is less than a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be a prompted value (it’s fixed as "Terminated"), and "less than" would show terminations before the date, not after.

C. Worker Status is equal to the value retrieved from a prompt OR Termination Date is equal to a value retrieved from a prompt: Incorrect. Worker Status shouldn’t be prompted, and "equal to" limits the filter to exact matches, not "after" the date. OR logic also broadens the scope incorrectly.

D. Worker Status is equal to the value "Terminated" AND Termination Date is greater than a value retrieved from a prompt: Correct. This ensures workers are terminated (fixed value) AND their termination date is after the user-entered date, precisely meeting the requirement.

Implementation:

In the custom report’s Filter tab, add two conditions:

Field: Worker Status, Operator: equals, Value: "Terminated".

Field: Termination Date, Operator: greater than, Value: Prompt for Date (configured as a report prompt).

Set the logical operator between conditions toAND.

Test with a sample date to verify only terminated workers after that date appear.

References from Workday Pro Integrations Study Guide:

Workday Report Writer Fundamentals: Section on "Creating and Managing Filters" details combining conditions with AND/OR logic and using prompts.

Integration System Fundamentals: Notes how filtered reports support integration data sources with dynamic user inputs.

The scenario involves a Core Connector: Worker integration with two runs detailed in the integration events report. The goal is to determine whether Brian Hill’s compensation change, effective April 30, 2024, and entered on May 13, 2024, will be included in either of the runs based on their date launch parameters. Let’s analyze each run against the change details to identify the correct answer.

In Workday, the Core Connector: Worker integration in incremental mode (as indicated by the presence of "Last Successful" parameters) processes changes based on the Transaction Log, filtering them by theEntry Moment(when the change was entered) andEffective Date(when the change takes effect). The integration captures changes where:

TheEntry Momentfalls between theLast Successful As of Entry Momentand theAs of Entry Moment, and

TheEffective Datefalls between theLast Successful Effective Dateand theEffective Date.

Brian Hill’s compensation change has:

Entry Moment:05/13/2024 (time not specified, so we assume it occurs at some point during the day, before or up to 11:59:59 PM).

Effective Date:04/30/2024.

Analysis of Run #1

Launch Date:05/15/2024 at 3:00:00 AM

As of Entry Moment:05/15/2024 3:00:00 AM – The latest point for when changes were entered.

Effective Date:05/15/2024 – The latest effective date for changes.

Last Successful As of Entry Moment:05/01/2024 3:00:00 AM – The starting point for entry moments.

Last Successful Effective Date:05/01/2024 – The starting point for effective dates.

For Run #1 to include Brian’s change:

TheEntry Moment(05/13/2024) must be between 05/01/2024 3:00:00 AM and 05/15/2024 3:00:00 AM. Since 05/13/2024 falls within this range (assuming the change was entered before 3:00:00 AM on 05/15/2024, which is reasonable unless specified otherwise), this condition is met.

TheEffective Date(04/30/2024) must be between 05/01/2024 (Last Successful Effective Date) and 05/15/2024 (Effective Date). However, 04/30/2024 isbefore05/01/2024, so this condition isnot met.

Since the effective date of Brian’s change (04/30/2024) precedes theLast Successful Effective Date(05/01/2024), Run #1 will not include this change. In incremental mode, Workday excludes changes with effective dates prior to the last successful effective date, as those are assumed to have been processed in a prior run (before Run #1’s baseline of 05/01/2024).

Analysis of Run #2

Launch Date:05/31/2024 at 3:00:00 AM

As of Entry Moment:05/31/2024 3:00:00 AM – The latest point for when changes were entered.

Effective Date:05/31/2024 – The latest effective date for changes.

Last Successful As of Entry Moment:05/15/2024 3:00:00 AM – The starting point for entry moments.

Last Successful Effective Date:05/15/2024 – The starting point for effective dates.

For Run #2 to include Brian’s change:

TheEntry Moment(05/13/2024) must be between 05/15/2024 3:00:00 AM and 05/31/2024 3:00:00 AM. However, 05/13/2024 isbefore05/15/2024 3:00:00 AM, so this condition isnot met.

TheEffective Date(04/30/2024) must be between 05/15/2024 (Last Successful Effective Date) and 05/31/2024 (Effective Date). Since 04/30/2024 isbefore05/15/2024, this condition is alsonot met.

In Run #2, theEntry Moment(05/13/2024) precedes theLast Successful As of Entry Moment(05/15/2024 3:00:00 AM), meaning the change was entered before the starting point of this run’s detection window. Additionally, theEffective Date(04/30/2024) is well before theLast Successful Effective Date(05/15/2024). Both filters exclude Brian’s change from Run #2.

Conclusion

Run #1:Excluded because the effective date (04/30/2024) is before the Last Successful Effective Date (05/01/2024).

Run #2:Excluded because the entry moment (05/13/2024) is before the Last Successful As of Entry Moment (05/15/2024 3:00:00 AM) and the effective date (04/30/2024) is before the Last Successful Effective Date (05/15/2024).

Brian Hill’s change would have been processed in an earlier run (prior to May 1, 2024) if the integration was running incrementally before Run #1, as its effective date (04/30/2024) predates both runs’ baselines. Given the parameters provided, neither Run #1 nor Run #2 captures this change, makingD. Brian Hill will be excluded from both integration runsthe correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker– Section on "Incremental Processing" explains how changes are filtered based on entry moments and effective dates relative to the last successful run.

Workday Integrations Study Guide: Launch Parameters– Details how "Last Successful As of Entry Moment" and "Last Successful Effective Date" define the starting point for detecting new changes, excluding prior transactions.

Workday Integrations Study Guide: Change Detection– Notes that changes with effective dates before the last successful effective date are assumed processed in earlier runs and are skipped in incremental mode.

The task involves processing the "Legal Name - First Name" field in Workday to meet a third-party vendor’s requirement of accepting only one-word first names. For workers with multiple names (e.g., "John Paul"), separated by a single space, the logic must:

Extract the value before the space (e.g., "John" from "John Paul").

Count the characters in the extracted value.

Check if the character count is greater than 0.

Use the extracted value if the count is greater than 0; otherwise, use the original "Legal Name - First Name" field.

This logic is typically implemented in Workday using calculated fields within a custom report or integration (e.g., EIB or Studio). Let’s break down the required functions:

Substring Text:This function is needed to extract the portion of the "Legal Name - First Name" field before the space. In Workday, the Substring Text function allows you to specify a starting position (e.g., 1) and extract text up to a delimiter (e.g., a space). For example, Substring Text("John Paul", 1, Index of " ") would return "John."

Text Length:After extracting the substring (e.g., "John"), the logic requires counting its characters to ensure it’s valid. The Text Length function returns the number of characters in a text string (e.g., Text Length("John") = 4). This is critical for the condition check.

True/False Condition:The logic involves a conditional check: "Is the number of characters greater than 0?" The True/False Condition function evaluates this (e.g., Text Length(extracted value) > 0), returning True if the extracted value exists and False if it’s empty (e.g., if no space exists or extraction fails).

Evaluate Expression:This function implements the if-then-else logic: if the character count is greater than 0, use the extracted value (e.g., "John"); otherwise, use the original "Legal Name - First Name" field (e.g., "John Paul"). Evaluate Expression combines the True/False Condition with the output values.

Option Analysis:

A. Extract Single Instance, Text Length, Numeric Constant, True/False Condition: Incorrect. Extract Single Instance is used for multi-instance fields (e.g., selecting one dependent), not text parsing. Numeric Constant isn’t needed here, as no fixed number is involved.

B. Text Constant, Substring Text, Arithmetic Calculation, Evaluate Expression: Incorrect. Text Constant provides a fixed string (e.g., "abc"), not dynamic extraction. Arithmetic Calculation isn’t required, as this is a text length check, not a numeric operation beyond comparison.

C. Format Text, Convert Text to Number, True/False Condition, Evaluate Expression: Incorrect. Format Text adjusts text appearance (e.g., capitalization), not extraction. Convert Text to Number isn’t needed, as Text Length already returns a number.

D. Substring Text, Text Length, True/False Condition, Evaluate Expression: Correct. These functions align perfectly with the requirements: extract the first name, count its length, check the condition, and choose the output.

Implementation:

Create a calculated field usingSubstring Textto extract text before the space.

UseText Lengthto count characters in the extracted value.

UseTrue/False Conditionto check if the length > 0.

UseEvaluate Expressionto return the extracted value or the original field based on the condition.

References from Workday Pro Integrations Study Guide:

Workday Calculated Fields: Section on "Text Functions" details Substring Text and Text Length usage.

Integration System Fundamentals: Explains how calculated fields with conditions (True/False, Evaluate Expression) transform data for third-party systems.

Core Connectors & Document Transformation: Highlights text manipulation for outbound integration requirements.