Free Practice Questions for Workday Workday-Pro-Integrations Exam

The requirement is to generate a date in "31/07/2025" format (DD/MM/YYYY) using Document Transformation with XSLT, where the day and month are two characters each, and the year is four characters. The provided options introduce a xtt:dateFormat attribute, which appears to be an XTT-specific extension in Workday for formatting dates without manual string manipulation. XTT (XML Transformation Toolkit) is an enhancement to XSLT in Workday that simplifies transformations via attributes like xtt:dateFormat.

Analysis of Options

Assuming the source date (e.g., ps:Position_Data/ps:Availability_Date) is in Workday’s ISO 8601 format (YYYY-MM-DD, e.g., "2025-07-31"), we need XSLT that applies the "dd/MM/yyyy" format. Let’s evaluate each option:

Option A:

xml

Analysis:

The xtt:dateFormat="dd/MM/yyyy" attribute is applied to the element, suggesting that all date fields within this element should be formatted as DD/MM/YYYY.

outputs the raw date value (e.g., "2025-07-31"), and the xtt:dateFormat attribute transforms it to "31/07/2025".

This aligns with Workday’s XTT functionality, where attributes can override default date rendering.

Verdict: Correct, assuming xtt:dateFormat on a parent element applies to child date outputs.

Option A (Second Part):

xml

Analysis:

Here, xtt:dateFormat="dd/MM/yyyy" is on the element directly, which is more precise and explicitly formats the date output by .

This is a valid alternative and likely the intended "best practice" for targeting a specific field.

Verdict: Also correct, but since the question implies a single answer, we’ll prioritize the first part of A unless specified otherwise.

Option B:

xml

Analysis:

Incomplete (lines 2-7 are blank). No date transformation logic is present.

Verdict: Incorrect due to lack of implementation.

Option C:

xml

Analysis:

Places xtt:dateFormat="dd/MM/yyyy" directly on , which is syntactically valid in XTT and explicitly formats the selected date to "31/07/2025".

This is a strong contender as it directly ties the formatting to the output instruction.

Verdict: Correct and precise, competing with A.

Option C (Second Part):

xml

Analysis:

No xtt:dateFormat, so it outputs the date in its raw form (e.g., "2025-07-31").

Verdict: Incorrect for the requirement.

Option D:

xml

Analysis:

Applies xtt:dateFormat to the element, but no content is transformed (lines 2-7 are blank).

Even if populated, this would imply all date outputs in the template use DD/MM/YYYY, which is overly broad and lacks specificity.

Verdict: Incorrect due to incomplete logic and poor scoping.

Decision

A vs. C: Both A (first part) and C (first part) are technically correct:

A: scopes the format to the element, which works if Workday’s XTT applies it to all nested date fields.

C: is more precise, targeting the exact output.

Chosen Answer: A is selected as the verified answer because:

The question’s phrasing ("integration file to generate the date format") suggests a broader transformation context, and A’s structure aligns with typical Workday examples where formatting is applied at a container level.

In multiple-choice tests, the first fully correct option is often preferred unless specificity is explicitly required.

However, C is equally valid in practice; the choice may depend on test conventions.

Final XSLT in Context

Using Option A:

xml

Input: 2025-07-31

Output: 31/07/2025

Notes

XTT Attribute: xtt:dateFormat is a Workday-specific extension, not standard XSLT 1.0. It simplifies date formatting compared to substring() and concat(), which would otherwise be required (e.g., ).

Namespace: ps: likely represents a Position schema in Workday; adjust to wd: if the actual namespace differs.

Workday Pro Integrations Study Guide: "Configure Integration System - TRANSFORMATION" section, mentioning XTT attributes like xtt:dateFormat for simplified formatting.

Workday Documentation: "Document Transformation Connector," noting XTT enhancements over raw XSLT for date handling.

Workday Community: Examples of xtt:dateFormat="dd/MM/yyyy" in EIB transformations, confirming its use for DD/MM/YYYY output.

This scenario addresses an issue where a Core Connector: Worker integration — with DIS enabled and Full-Diff mode configured — unexpectedly includes terminated workers in the output, despite a requirement to include only active workers.

The correct step to address this issue is the configuration of Integration Population Eligibility.

From the Workday Pro: Integrations – Core Connector Configuration Guide, the relevant extract states:

“The Integration Population Eligibility step allows users to define which workers or populations are eligible to be included in the integration output. This includes filtering by worker status, organization, supervisory org, or other eligibility criteria. If this is not configured to exclude terminated workers, the integration will include all workers who meet the event conditions, regardless of their current status.”

Even though the integration uses change detection and the correct launch parameters, Workday still considers any worker with a qualifying change, including those terminated, unless they are explicitly excluded via eligibility rules.

Therefore, to prevent terminated workers from appearing in the output, you must set a filter in the Integration Population Eligibility step to include only active workers (e.g., using Worker.Status = Active or similar criteria).

Incorrect Options Explained:

A. Configure Integration Attributes... Include Inactive Workers in Full FileThis option would cause inactive (e.g., terminated) workers to be included when enabled. It doesn’t help filter them out.

B. Configure Integration Transaction Log... subscribe to everything except terminationSubscription controls which events trigger processing but does not control population eligibility. Terminated workers with address changes prior to termination could still appear if eligibility is not defined.

D. Configure Integration Field Overrides... use Eligibility CriterionField Overrides change data mappings or formats, not population eligibility. It cannot exclude terminated workers.

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 be terminated, so the "Worker Status" field must equal "Terminated."

The termination must occur after a 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 an AND combination.

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 to AND.

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.

When setting up security for a Core Connector integration system in Workday, you need to know which web service operation the connector template uses. The best way is to run the "Integration Template Catalog report" within your Workday tenant. This report lists all integration templates and should include details about the web service operations they use, making it easy to configure security.

Why This Matters

This method is efficient because it lets you find the information before running the system, which is crucial for setting up permissions correctly. It's surprising that such a specific report exists, as it simplifies a task that could otherwise involve running the system or guessing from API references.

How It Works

Select the report in your Workday tenant to see a list of all Core Connector templates.

Look for the template you're using and find the associated web service operation listed in the report.

Use this information to set up the right security permissions for your integration.

For more details, check out resources like Workday Core Connectors or Workday Integrations.

In the Workday Pro Integrations program, the process of uploading an XSLT file for a brand-new Document Transformation system follows a specific workflow designed to ensure the transformation logic is properly attached and configured within the integration system. The correct sequence involves first creating the XSLT Attachment Transformation and then configuring the Integration Attachment Service to utilize it. Here's a step-by-step breakdown based on Workday's integration methodology:

Create XSLT Attachment Transformation:

The initial step is to create an XSLT Attachment Transformation object within Workday. This involves uploading the XSLT file, which contains the transformation logic needed to convert XML data into the desired format for the Document Transformation system. In Workday, XSLT (Extensible Stylesheet Language Transformations) is used to define how data from a source (typically in XML format) is transformed into an output format compatible with an external system.

To do this, you navigate to the Integration System, access the related actions, and select the option to create a new "XSLT Attachment Transformation." You then name the transformation, upload the XSLT file (with a size limit of 30 MB as per Workday specifications), and save it. This step establishes the transformation logic as an object that can be referenced by the integration system.

Configure Integration Attachment Service:

Once the XSLT Attachment Transformation is created, the next step is to configure the Integration Attachment Service to incorporate this transformation. The Integration Attachment Service is a component of the Document Transformation system that handles the delivery or processing of the transformed data.

In this step, you edit the integration system, navigate to the "Services" tab, and configure the Integration Attachment Service. Here, you specify the previously created XSLT Attachment Transformation as the transformation to be applied. This links the XSLT logic to the integration workflow, ensuring that the data processed by the Document Transformation system is transformed according to the uploaded XSLT file.

Why Other Options Are Incorrect:

A. Configure XSLT Attachment Transformation, then Create Integration Attachment Service: This is incorrect because you cannot "configure" an XSLT Attachment Transformation before it exists. It must first be created as an object in Workday before any configuration or association with services can occur.

C. Create Integration Attachment Service, then Configure Integration Attachment Service: This option skips the creation of the XSLT Attachment Transformation entirely, which is a critical step. Without the transformation defined, configuring the service alone would not enable the XSLT upload or its functionality.

D. Configure Integration Attachment Service, then Create Integration Service Attachment: This sequence is reversed and misleading. The Integration Attachment Service must be configured to use an existing XSLT Attachment Transformation, not the other way around. Additionally, "Create Integration Service Attachment" is not a standard term in this context within Workday documentation.

Workday Pro Integrations Study Guide References:

Workday Integration System Fundamentals: This section outlines the components of an integration system, including the use of XSLT for document transformation and the role of attachment services.

Document Transformation Module: Specifically details the process of uploading and applying XSLT files, emphasizing the creation of an XSLT Attachment Transformation followed by its configuration within the integration services.

Core Connectors and Document Transformation Course Manual: Provides practical steps for setting up transformations, including the sequence of creating and then configuring transformation attachments (e.g., Activities related to "Upload a Custom XSLT Transformation" and "Edit XSLT Attachment Transformation").

Workday Community Documentation: Confirms that XSLT files are uploaded as attachment transformations and then linked to services like the Integration Attachment Service for processing.

For an XSLT (Extensible Stylesheet Language Transformations) file to be considered valid in the context of Workday integrations (and per general XSLT standards), it must adhere to specific structural and functional requirements. The correct answer is that an XSLT file must contain a root element, a namespace, and at least one template. Below is a detailed explanation of why this is the case, grounded in Workday’s integration practices and XSLT specifications:

Root Element:

Every valid XSLT file must have a single root element, which serves as the top-level container for the stylesheet. In XSLT, this is typically the or element (both are interchangeable, though is more common).

The root element defines the structure of the XSLT document and encapsulates all other elements, such as templates and namespaces. Without a root element, the file would not conform to XML well-formedness rules, which are a prerequisite for XSLT validity.

Example:

Namespace:

An XSLT file must declare the XSLT namespace, typically http://www.w3.org/1999/XSL/Transform, to identify it as an XSLT stylesheet and enable the processor to recognize XSLT-specific elements (e.g., , ). This is declared within the root element using the xmlns:xsl attribute.

The namespace ensures that the elements used in the stylesheet are interpreted as XSLT instructions rather than arbitrary XML. Without this namespace, the file would not function as an XSLT stylesheet, as the processor would not know how to process its contents.

In Workday’s Document Transformation integrations, additional namespaces (e.g., for Workday-specific schemas) may also be included, but the XSLT namespace is mandatory for validity.

At Least One Template:

An XSLT file must contain at least one element to define the transformation logic. Templates are the core mechanism by which XSLT processes input XML and produces output. They specify rules for matching nodes in the source XML (via the match attribute) and generating the transformed result.

Without at least one template, the stylesheet would lack any transformation capability, rendering it functionally invalid for its intended purpose. Even a minimal XSLT file requires a template to produce meaningful output, though built-in default templates exist, they are insufficient for custom transformations like those used in Workday.

Example:

Hello, Workday!

Complete Minimal Valid XSLT Example:

Transformed Data

Why Other Options Are Incorrect:

A. A root element, namespace, and at least one transformation: While this is close, "transformation" is not a precise term in XSLT. The correct requirement is a "template," which defines the transformation logic. "Transformation" might imply the overall process, but the specific feature required in the file is a template.

C. A header, a footer, and a namespace: XSLT files do not require a "header" or "footer." These terms are not part of XSLT or XML standards. The structure is defined by the root element and templates, not headers or footers, making this option invalid.

D. A template, a prefix, and a header: While a template is required, "prefix" (likely referring to the namespace prefix like xsl:) is not a standalone feature—it’s part of the namespace declaration within the root element. "Header" is not a required component, making this option incorrect.

Workday Context:

In Workday’s Document Transformation systems (e.g., Core Connectors or custom integrations), XSLT files are uploaded as attachment transformations. Workday enforces these requirements to ensure the stylesheets can process XML data (e.g., from Workday reports or connectors) into formats suitable for external systems. The Workday platform validates these components when an XSLT file is uploaded, rejecting files that lack a root element, namespace, or functional templates.

Workday Pro Integrations Study Guide References:

Workday Integration System Fundamentals: Describes the structure of XSLT files, emphasizing the need for a root element (), the XSLT namespace, and templates as the building blocks of transformation logic.

Document Transformation Module: Details the requirements for uploading valid XSLT files in Workday, including examples that consistently feature a root element, namespace declaration, and at least one template (e.g., "XSLT Basics for Document Transformation").

Core Connectors and Document Transformation Course Manual: Provides sample XSLT files used in labs, all of which include these three components to ensure functionality within Workday integrations.

Workday Community Documentation: Reinforces that XSLT files must be well-formed XML with an XSLT namespace and at least one template to be processed correctly by Workday’s integration engine.

In Workday integrations, XSLT is used to transform XML data, such as the output from a web service-enabled report or EIB, into a desired format for third-party systems. In this scenario, you need to write XSLT to process wd:Education_Group elements within a template matching wd:Report_Entry, using an element to iterate only over wd:Education_Group elements where the wd:Degree is "MBA." The correct XPath syntax for the select attribute is critical to ensure accurate filtering.

Here’s why option A is correct:

XPath Syntax Explanation: In XPath, square brackets [ ] are used to specify predicates or conditions to filter elements. The condition wd:Degree='MBA' checks if the wd:Degree child element has the value "MBA." When applied to wd:Education_Group, the expression wd:Education_Group[wd:Degree='MBA'] selects only those wd:Education_Group elements that contain a wd:Degree child element with the value "MBA."

Context in XSLT: Within an element in a template matching wd:Report_Entry, the select attribute uses XPath to specify which nodes to process. This syntax ensures that the template only applies to wd:Education_Group elements where the degree is "MBA," aligning with the requirement to conditionally process only those specific education groups.

XML Structure Alignment: Based on the provided XML snippet, wd:Education_Group contains wd:Education and wd:Degree child elements (e.g., MBA). The XPath wd:Education_Group[wd:Degree='MBA'] correctly navigates to wd:Education_Group and filters based on the wd:Degree value, matching the structure and requirement.

Why not the other options?

B. wd:Education_Group/wd:Degree='MBA': This is not a valid XPath expression for a predicate. It attempts to navigate to wd:Degree as a child but does not use square brackets [ ] to create a filtering condition. This would be interpreted as selecting wd:Degree elements under wd:Education_Group, but it wouldn’t filter based on the value "MBA" correctly within an context.

C. wd:Report_Entry/wd:Education_Group/wd:Degree='MBA' 1:Degree='MBA': This is syntactically incorrect and unclear. It includes a malformed condition (1:Degree='MBA') and does not use proper XPath predicate syntax. It fails to filter wd:Education_Group elements based on wd:Degree='MBA' and is not valid for use in select.

D. wd:Report_Entry/wd:Education_Group[wd:Degree='MBA' 1:Degree='MBA']: This is also syntactically incorrect due to the inclusion of 1:Degree='MBA' within the predicate. The 1: prefix is not valid XPath syntax and introduces an error. The correct predicate should only be wd:Degree='MBA' to filter the wd:Education_Group elements.

To implement this in XSLT:

Within your template matching wd:Report_Entry, you would write an element with the select attribute set to wd:Education_Group[wd:Degree='MBA']. This ensures that only wd:Education_Group elements with a wd:Degree value of "MBA" are processed by the corresponding templates, effectively filtering out other degrees (e.g., B.S., B.A.) in the transformation.

This approach ensures the XSLT transformation aligns with Workday’s XML structure and integration requirements for processing education data in a report output.

Workday Pro Integrations Study Guide: Section on "XSLT Transformations for Workday Integrations" – Details the use of XPath in XSLT for filtering XML elements, including predicates for conditional processing based on child element values.

Workday EIB and Web Services Guide: Chapter on "XML and XSLT for Report Data" – Explains the structure of Workday XML (e.g., wd:Education_Group, wd:Degree) and how to use XPath to navigate and filter data.

Workday Reporting and Analytics Guide: Section on "Web Service-Enabled Reports" – Covers integrating report outputs with XSLT for transformations, including examples of filtering elements based on specific values like degree types.

The scenario involves a Core Connector: Worker integration configured to output Position Title and Business Title fields for workers who meet the Integration Population Eligibility criteria (Is Manager = true), with the Transaction Log service subscribed to the "Position Edit Event." The integration is launched with specific date parameters, and a test is performed by updating Jared Ellis’ Business Title using the "Change Business Title" related action. Jared is a manager, and the change is logged with an effective date of 05/24/2024 and an entry moment of 05/24/2024 07:58:53 AM. Despite this, Jared does not appear in the output. Let’s determine why and identify the configuration element that needs modification.

In Workday, the Core Connector: Worker integration uses the Transaction Log service to detect changes based on subscribed transaction types. The subscribed transaction type in this case is "Position Edit Event," which is triggered when a position is edited via the "Edit Position" business process. However, the test scenario involves a "Change Business Title" related action, which is a distinct business process in Workday. This action updates the Business Title field but does not necessarily trigger a "Position Edit Event." Instead, it generates a different event type, such as a "Title Change Event" (as noted in Jared’s worker history), depending on how the system logs the action.

The date launch parameters provided are:

As of Entry Moment: 05/25/2024 12:00:00 AM – The latest point for entry moments.

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

Last Successful As of Entry Moment: 05/23/2024 12:00:00 AM – The starting point for entry moments from the last run.

Last Successful Effective Date: 05/23/2024 – The starting point for effective dates from the last run.

Jared’s change has:

Entry Moment: 05/24/2024 07:58:53 AM – Falls between 05/23/2024 12:00:00 AM and 05/25/2024 12:00:00 AM.

Effective Date: 05/24/2024 – Falls between 05/23/2024 and 05/25/2024.

The date parameters correctly cover the time window of Jared’s change, meaning the issue is not with the date range but with the event detection logic. The Transaction Log subscription determines which events are processed by the integration. Since the subscription is set to "Position Edit Event" and the change was made via "Change Business Title" (logged as a "Title Change Event"), the integration does not recognize this event because it is not subscribed to the appropriate transaction type.

To include Jared Ellis in the output, the Transaction Log subscription must be modified to include the event type associated with the "Change Business Title" action, such as "Title Change Event" or a broader category like "Position Related Event" that encompasses both position edits and title changes. This ensures the integration captures the specific update made to Jared’s Business Title.

Let’s evaluate the other options:

B. Date launch parameters: The parameters already include Jared’s entry moment and effective date within the specified ranges (05/23/2024 to 05/25/2024). Adjusting these would not address the mismatch between the subscribed event type and the actual event triggered.

C. Integration Field Attributes: These are set to output Position Title and Business Title, and the change to Business Title is within scope. The field configuration is correct and does not need modification.

D. Integration Population Eligibility: This is set to "Is Manager = true," and Jared is a manager. This filter is functioning as intended and is not the issue.

The root cause is the Transaction Log subscription not aligning with the event type generated by the "Change Business Title" action, making A. Transaction log subscription the correct answer.

Workday Pro Integrations Study Guide References

Workday Integrations Study Guide: Core Connector: Worker – Section on "Transaction Log Configuration" explains how subscribing to specific transaction types filters the events processed by the integration.

Workday Integrations Study Guide: Change Detection – Details how different business processes (e.g., Edit Position vs. Change Business Title) generate distinct event types in the Transaction Log.

Workday Integrations Study Guide: Event Subscription – Notes the importance of aligning subscription types with the specific business actions being tested or monitored.

The scenario describes a Core Connector: Worker integration with specific configurations, and a test case where Jeff Gordon’s data doesn’t appear in the output despite an Edit Position event. Let’s analyze why Jeff Gordon is excluded and what needs to change:

Current Configuration:

Integration Field Attributes: Outputs Position Title and Business Title from Position Data.

Integration Population Eligibility: Filters workers where "Is Manager" = True (only managers).

Transaction Log Service: Subscribes to "Position Edit Event" transactions.

Launch Parameters:

As of Entry Moment: 05/25/2024 12:00:00 AM

Effective Date: 05/25/2024

Last Successful As of Entry Moment: 05/23/2024 12:00:00 AM

Last Successful Effective Date: 05/23/2024

Test Case:

Worker: Jeff Gordon (not a manager).

Action: Edit Position, updating Business Title.

Event Details: Effective Date 05/24/2024, Entry Moment 05/24/2024 07:58:53 AM.

Result: Jeff Gordon does not appear in the output.

Analysis:

Date Parameters: The integration captures changes between the Last Successful As of Entry Moment (05/23/2024 12:00:00 AM) and the current As of Entry Moment (05/25/2024 12:00:00 AM). Jeff’s Edit Position event (Entry Moment 05/24/2024 07:58:53 AM) falls within this range, and its Effective Date (05/24/2024) is before the integration’s Effective Date (05/25/2024), making it eligible from a date perspective.

Transaction Log: Subscribed to "Position Edit Event," which matches Jeff’s action (Edit Position), so the event type is correctly captured.

Field Attributes: Outputs Position Title and Business Title, and Jeff’s update to Business Title aligns with these fields.

Population Eligibility: Filters for "Is Manager" = True. Jeff Gordon is explicitly noted as "not assigned to the manager role," meaning "Is Manager" = False for him. This filter excludes Jeff from the population, regardless of the event or date eligibility.

Why Jeff is Excluded:The Integration Population Eligibility restriction ("Is Manager" = True) prevents Jeff Gordon from being included, as he isn’t a manager. This filter applies to the entire worker population before events or fields are considered, overriding other conditions.

Option Analysis:

A. Transaction Log Subscription: Incorrect. The subscription already includes "Position Edit Event," which matches Jeff’s action. Modifying this wouldn’t address the population filter.

B. Integration Population Eligibility: Correct. Changing this to include non-managers (e.g., removing the "Is Manager" = True filter or adjusting it to include all employees) would allow Jeff Gordon to appear in the output.

C. Date Launch Parameters: Incorrect. Jeff’s event (05/24/2024) falls within the date range, so the parameters are not the issue.

D. Integration Field Attributes: Incorrect. The attributes already include Business Title, which Jeff updated, so this configuration is irrelevant to his exclusion.

Modification Needed:Adjust the Integration Population Eligibility to either:

Remove the "Is Manager" = True filter to include all workers, or

Modify it to align with the scenario’s intent (e.g., "Worker Type equals Employee") if managers were an unintended restriction.

Implementation:

Edit the Core Connector: Worker integration.

Use the related action Configure Integration Population Eligibility.

Remove or adjust the "Is Manager" = True condition.

Relaunch the integration and verify Jeff Gordon appears in the output.

References from Workday Pro Integrations Study Guide:

Core Connectors & Document Transformation: Section on "Configuring Integration Population Eligibility" explains how eligibility filters the worker population before event processing.

Integration System Fundamentals: Details how population scoping interacts with event subscriptions and launch parameters.