You want to delete a Prism data source, but you are unable to complete the dataset unpublish. You have deleted the Report Writer reports. What else must you delete, if present?
Correct Answer: C
Comprehensive and Detailed Explanation From Exact Extract: In Workday Prism Analytics, unpublishing a dataset to delete a Prism data source requires removing all dependencies that reference the data source. According to the official Workday Prism Analytics study path documents, if you have already deleted Report Writer reports but are still unable to unpublish the dataset, you must also delete any discovery board visualizations that reference the Prism data source (option C). Discovery boards in Workday allow users to create visualizations based on Prism data sources, and these visualizations create a dependency on the data source. If such visualizations exist, the system prevents the dataset from being unpublished until they are removed, ensuring that no downstream dependencies are broken. The other options are incorrect: * A. Upstream tables: Upstream tables are the source of data for the dataset, but they are not dependencies of the published data source and do not need to be deleted to unpublish the dataset. * B. Published rows: Published rows are part of the data source itself and are removed when the dataset is unpublished; they are not a separate dependency to delete. * D. Upstream datasets: Upstream datasets may feed into the dataset being unpublished, but they are not dependencies of the published data source and do not prevent unpublishing. Deleting discovery board visualizations ensures all dependencies are cleared, allowing the dataset to be unpublished and the Prism data source to be deleted. References: Workday Prism Analytics Study Path Documents, Section: Publishing and Visualizing Data, Topic: Unpublishing Prism Data Sources Workday Prism Analytics Training Guide, Module: Publishing and Visualizing Data, Subtopic: Managing Dependencies for Data Source Deletion
Workday-Prism-Analytics Exam Question 17
You want to apply a Filter stage to your derived dataset to show only expense reports submitted in the current month and where the expense report total amount is higher than 2000 USD. What should you do?
Correct Answer: A
Comprehensive and Detailed Explanation From Exact Extract: In Workday Prism Analytics, a Filter stage in a derived dataset is used to include only rows that meet specific criteria. The requirement here is to show expense reports that satisfy two conditions: (1) submitted in the current month, and (2) total amount higher than 2000 USD. According to the official Workday Prism Analytics study path documents, this can be achieved by using a simple filter with two conditions and the "If All" operator (option A). The first condition would check the submission date, using a function like MONTH() to compare with the current month (e.g., MONTH(submission_date) = MONTH(CURRENT_DATE())). The second condition would compare the total amount (e.g., total_amount > 2000). The "If All" operator ensures that both conditions must be true for a row to be included, which aligns with the requirement that both criteria (current month AND amount > 2000 USD) must be met. A simple filter is sufficient because the logic involves straightforward comparisons without nested conditions. The other options are incorrect: * B. Use a simple filter, two conditions, and "If Any" operator: The "If Any" operator would include rows where either condition is true (e.g., submitted in the current month OR amount > 2000 USD), which does not meet the requirement for both conditions to be true. * C. Use a simple filter, three conditions, and "If All" operator: Only two conditions are needed (submission month and amount), so three conditions are unnecessary. * D. Use a simple filter, three conditions, and "If Any" operator: This combines the issues of option B (wrong operator) and option C (too many conditions). Using a simple filter with two conditions and the "If All" operator ensures the dataset includes only the expense reports that meet both criteria. References: Workday Prism Analytics Study Path Documents, Section: Data Prep and Transformation, Topic: Applying Filters in Derived Datasets Workday Prism Analytics Training Guide, Module: Data Prep and Transformation, Subtopic: Configuring Simple Filters with Multiple Conditions