Join the discussion
Question 17/61
You need the integration file to generate the date format in the form of "31/07/2025" format
* The first segment is day of the month represented by two characters.
* The second segment is month of the year represented by two characters.
* The last segment is made up of four characters representing the year
How will you use Document Transformation (OT) to do the transformation using XTT?
* The first segment is day of the month represented by two characters.
* The second segment is month of the year represented by two characters.
* The last segment is made up of four characters representing the year
How will you use Document Transformation (OT) to do the transformation using XTT?
Correct Answer: A
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
<xsl:template match="ps:Position">
<Record xtt:dateFormat="dd/MM/yyyy">
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Analysis:
The xtt:dateFormat="dd/MM/yyyy" attribute is applied to the <Record> element, suggesting that all date fields within this element should be formatted as DD/MM/YYYY.
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/> 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
<Record>
<Availability_Date xtt:dateFormat="dd/MM/yyyy">
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
Analysis:
Here, xtt:dateFormat="dd/MM/yyyy" is on the <Availability_Date> element directly, which is more precise and explicitly formats the date output by <xsl:value-of>.
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
<xsl:template match="ps:Position">
</xsl:template>
Analysis:
Incomplete (lines 2-7 are blank). No date transformation logic is present.
Verdict: Incorrect due to lack of implementation.
Option C:
xml
<xsl:template match="ps:Position">
<Record>
<Availability_Date>
<xsl:value-of xtt:dateFormat="dd/MM/yyyy" select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Analysis:
Places xtt:dateFormat="dd/MM/yyyy" directly on <xsl:value-of>, 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
<Record>
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
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
<xsl:template xtt:dateFormat="dd/MM/yyyy" match="ps:Position">
</xsl:template>
Analysis:
Applies xtt:dateFormat to the <xsl:template> 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: <Record xtt:dateFormat="dd/MM/yyyy"> scopes the format to the <Record> element, which works if Workday's XTT applies it to all nested date fields.
C: <xsl:value-of xtt:dateFormat="dd/MM/yyyy"> 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
<xsl:template match="ps:Position">
<Record xtt:dateFormat="dd/MM/yyyy">
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Input: <ps:Availability_Date>2025-07-31</ps:Availability_Date>
Output: <Record><Availability_Date>31/07/2025</Availability_Date></Record> 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., <xsl:value-of select="concat(substring(., 9, 2), '/', substring(., 6, 2), '/', substring(., 1, 4))"/>).
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.
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
<xsl:template match="ps:Position">
<Record xtt:dateFormat="dd/MM/yyyy">
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Analysis:
The xtt:dateFormat="dd/MM/yyyy" attribute is applied to the <Record> element, suggesting that all date fields within this element should be formatted as DD/MM/YYYY.
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/> 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
<Record>
<Availability_Date xtt:dateFormat="dd/MM/yyyy">
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
Analysis:
Here, xtt:dateFormat="dd/MM/yyyy" is on the <Availability_Date> element directly, which is more precise and explicitly formats the date output by <xsl:value-of>.
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
<xsl:template match="ps:Position">
</xsl:template>
Analysis:
Incomplete (lines 2-7 are blank). No date transformation logic is present.
Verdict: Incorrect due to lack of implementation.
Option C:
xml
<xsl:template match="ps:Position">
<Record>
<Availability_Date>
<xsl:value-of xtt:dateFormat="dd/MM/yyyy" select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Analysis:
Places xtt:dateFormat="dd/MM/yyyy" directly on <xsl:value-of>, 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
<Record>
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
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
<xsl:template xtt:dateFormat="dd/MM/yyyy" match="ps:Position">
</xsl:template>
Analysis:
Applies xtt:dateFormat to the <xsl:template> 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: <Record xtt:dateFormat="dd/MM/yyyy"> scopes the format to the <Record> element, which works if Workday's XTT applies it to all nested date fields.
C: <xsl:value-of xtt:dateFormat="dd/MM/yyyy"> 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
<xsl:template match="ps:Position">
<Record xtt:dateFormat="dd/MM/yyyy">
<Availability_Date>
<xsl:value-of select="ps:Position_Data/ps:Availability_Date"/>
</Availability_Date>
</Record>
</xsl:template>
Input: <ps:Availability_Date>2025-07-31</ps:Availability_Date>
Output: <Record><Availability_Date>31/07/2025</Availability_Date></Record> 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., <xsl:value-of select="concat(substring(., 9, 2), '/', substring(., 6, 2), '/', substring(., 1, 4))"/>).
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.
Add Comments
- Other Question (61q)
- Q1. When creating an ISU, what should you do to ensure the user only authenticates via web ser...
- Q2. What is the purpose of granting an ISU modify access to the Integration Event domain via a...
- Q3. Refer to the following scenario to answer the question below. You have been asked to build...
- Q4. You need the integration file to generate the date format in the form of "31/07/2025" form...
- Q5. Refer to the following XML to answer the question below. Refer to the following XML to ans...
- Q6. What are the two valid data source options for an Outbound EIB?...
- Q7. Refer to the following scenario to answer the question below. You have configured a Core C...
- Q8. As of May 1, 2024 Brian Hill's annual salary is $60,000.00. On May 13, 2024 Brian Hill rec...
- Q9. You are creating an outbound connector using the Core Connector: Job Postings template. Th...
- Q10. What is the workflow to chain a Document Transformation system to a Connector integration ...
- Q11. What is the purpose of the <xsl:template> element?...
- Q12. You are configuring an EIB that uses a custom report as its data source. When attempting t...
- Q13. Refer to the following XML to answer the question below. (Exhibit) You need the integratio...
- Q14. A vendor needs an EIB that uses a custom report to output a list of new hires and their ch...
- Q15. What is the task used to upload a new XSLT file for a pre-existing document transformation...
- Q16. Refer to the following XML to answer the question below. Refer to the following XML to ans...
- Q17. You need the integration file to generate the date format in the form of "31/07/2025" form...
- Q18. How does an XSLT processor identify the specific nodes in an XML document to which a parti...
- Q19. Refer to the following scenario to answer the question below. Your integration has the fol...
- Q20. A vendor needs to create a Date Difference calculated field. However, the two dates needed...
- Q21. You have a population of workers who have put multiple names in their Legal Name - First N...
- Q22. What XSL component is required to execute valid transformation instructions in the XSLT co...
- Q23. Refer to the following scenario to answer the question below. You need to configure a Core...
- Q24. You have been asked to create an integration using the Core Connector: Worker with DIS tem...
- Q25. What is the relationship between the Integration System User (ISU), Integration System Sec...
- Q26. You are creating a connector based integration where all fields are provided by the templa...
- Q27. You need to create a report that includes data from multiple business objects. For a super...
- Q28. This is the XML file generated from a Core Connector; Positions integration. (Exhibit) Whe...
- Q29. Refer to the following XML and example transformed output to answer the question below. (E...
- Q30. When creating an ISU, what should you do to ensure the user only authenticates via web ser...
- Q31. What task is needed to build a sequence generator for an EIB integration?...
- Q32. Refer to the scenario. You are implementing a Core Connector: Worker integration to send e...
- Q33. What is the relationship between the Integration System User (ISU), Integration System Sec...
- Q34. Refer to the following XML and example transformed output to answer the question below. (E...
- Q35. Your manager has asked for a value on their dashboard for how many days away the birthdays...
- Q36. After configuring domain security policies, what task must you run to ensure the most rece...
- Q37. Refer to the scenario. You are configuring a Core Connector: Worker integration with the D...
- Q38. Refer to the scenario. You are configuring a Core Connector: Worker integration to extract...
- Q39. What is the workflow to upload an XSLT file for a brand new Document Transformation system...
- Q40. You have been asked to refine a report which outputs one row per worker and is being used ...
- Q41. What is the workflow to upload an XSLT file for a brand new Document Transformation system...
- Q42. Refer to the following XML and example transformed output to answer the question below. (E...
- Q43. This is the XML file generated from a Core Connector; Positions integration. (Exhibit) Whe...
- Q44. You need to filter a custom report to only show workers that have been terminated after a ...
- Q45. What is the workflow to chain a Document Transformation system to a Connector integration ...
- Q46. Which three features must all XSLT files contain to be considered valid?...
- Q47. Refer to the following scenario to answer the question below. You have been asked to build...
- Q48. Refer to the following XML to answer the question below. (Exhibit) You are an integration ...
- Q49. Your manager has asked for a value on their dashboard for how many days away the birthdays...
- Q50. A calculated field used as a field override in a Connector is not appearing in the output....
- Q51. Which features must all XSLT files contain to be considered valid?...
- Q52. Refer to the following scenario to answer the question below. You need to configure a Core...
- Q53. Your manager has asked for a value on their dashboard for how many days away the birthdays...
- Q54. Refer to the following XML to answer the question below. (Exhibit) Within the template whi...
- Q55. Which three features must all XSLT files contain to be considered valid?...
- Q56. You have configured a filename sequence generator for a connector integration. The vendor ...
- Q57. What is the relationship between an ISU (Integration System User) and an ISSG (Integration...
- Q58. A vendor needs an EIB that uses a custom report to output a list of new hires and their ch...
- Q59. How many integration systems can an ISU be assigned to concurrently?...
- Q60. What is the purpose of the <xsl:template> element?...
- Q61. Refer to the following scenario to answer the question below. You have configured a Core C...
[×]
Download PDF File
Enter your email address to download Workday.Workday-Pro-Integrations.v2026-03-13.q61.pdf
