Celonis - Data Analyst (Theory MCQ Questions)

▸ Celonis - Data Analyst (Theory Knowledge | MCQ Questions) :

1. When using the bookmarks feature in Celonis, which of the following is true? Select all that apply: (2 Points)
   • Bookmarks are exclusive to each analysis.
   • Bookmarks can only be created by Analysts and Data Engineers.
   • Bookmarks can be sorted Alphabetically and by Creation Date.
   • Bookmarks cannot be shared with others.

---

2. “Process Analytics” contains all the analyses in the Intelligent Business Cloud. All analyses within “Process Analytics” are structured in “Workspaces”. Which of the following statements are true? Select all that apply: (2 Points)
   • All analyses in one “Workspace” are based on the same data model
   • One “Workspace” can be linked to multiple data models
   • One “Workspace” can host a maximum of three analyses
   • One “Workspace” can host multiple analyses

---

3. Using your knowledge of the Variant and Process Explorer, which of the following are true about the Process Explorer: Select all that apply
   (2 Points)
   • Users are able to subsequently add the next most common process variant to the Process Explorer.
   • Filters can be applied to activities and connections.
   • Filters can be applied to specific process variants.
   • Users are able to subsequently add the next most common activity to the Process Explorer.

---

4. Using your knowledge of the Variant and Process Explorer, which explorer is better suited to count the total number of cases running through a particular activity? Select the appropriate response (2 Points)
   • The Process Explorer
   • The Variant Explorer

---

5. Which of the following is true about analysis Components? Select all that apply: Select the appropriate response (2 Points)
   • Components size are static and cannot be changed
   • Components contain only Charts and Tables
   • Once a filter is created on the sheet level, it will not affect new components
   • Components can be copied from one sheet to another

---

6. Which of the different ways can you create a Target Process Model for Process Conformance in Celonis? Select all that apply: (2 Points)
   • Select from Online Process Models
   • Create a new Process Model from scratch with the process modelling tool
   • Upload a Process Model (.bpmn-file)
   • Mine the target Process Model in Celonis

---

7. Assume you created an OLAP table displaying the Sales Organizations and the Automation Rate as a percentage. In a next step you want to add a Conditional Format (color mapping) to the Automation Rate column with the following conditions: - If greater than 50% then “green” - If greater than 30% and less than or equal to 50% then “yellow” - If greater than 10% and less than or equal to 30% then “orange” - If less than or equal to 10% then “red” Put the following conditions (a-d) in the proper order (from top to bottom) to apply the correct filter? a) “Red” if Less than/equal 0.1 b)“Yellow” if Greater than 0.3 c) “Orange” if Greater than 0.1 d) “Green” if Greater than 0.5. Select the appropriate response (10 Points)
   • d); c); a); b)
   • a); c); b); d)
   • a); b); c); d)

---

8. Assume you are given two date columns (“ShippingDate” and “ReturnDate”) within the Table “CustomerShipping”, what is the PQL formula used to calculate the HOURS between the two dates? Hint: The “PQL reference” and “PQL function library” might be helpful here. Select the appropriate response (10 Points)
   • DATE_BETWEEN (“CustomerShipping”.“ReturnDate”, “CustomerShipping”.“ShippingDate”)
   • DATE_BETWEEN (“CustomerShipping”.“ShippingDate”, “CustomerShipping”.“ReturnDate”)
   • DATEDIFF (mm,“CustomerShipping”.“ShippingDate”, “CustomerShipping”.“ReturnDate”)
   • DATEDIFF (hh,“CustomerShipping”.“ShippingDate”, “CustomerShipping”.“ReturnDate”)

---

9. Assume you want to create a KPI that displays the percentage of cases (sales order items) where the activity “Ship Goods” occurred and was FOLLOWED by “Change Price” with an arbitrary number of process steps in between. Which of the following PQL formulas is correct? Select the appropriate response (10 Points)
   • AVG(CASE WHEN PROCESS EQUALS ‘Ship Goods’ to any to ‘Change Price’ THEN 1.0 ELSE 0.0 END)
   • AVG(WHEN PROCESS EQUALS ‘Change Price’ to any to ‘Ship Goods’ THEN 1.0 ELSE 0.0 END)
   • AVG(WHEN PROCESS EQUALS ‘Ship Goods’ to any to ‘Change Price’ THEN 1.0 ELSE 0.0 END)
   • AVG(CASE WHEN PROCESS EQUALS ‘Change Price’ to any to ‘Ship Goods’ THEN 1.0 ELSE 0.0 END)

---

10. Assume you want to create a KPI that displays the percentage of cases (sales order items) that were executed by a batch user (“USER_TYPE” = ‘B’). Which of the following PQL formulas is correct? Select the appropriate response (10 Points)
    • AVG(COUNT(CASE WHEN “_CEL_O2C_ACTIVITIES”.“USER_TYPE” = ‘B’ THEN 1.0 ELSE 0.0 END))
    • AVG(CASE WHEN “_CEL_O2C_ACTIVITIES”.“USER_TYPE” = ‘B’ THEN ‘Automated User’ ELSE ‘Manual User’ END)
    • AVG(CASE WHEN “_CEL_O2C_ACTIVITIES”.“USER_TYPE” = ‘B’ THEN ‘Batch User’ ELSE ‘Manual User’ END)
    • AVG(CASE WHEN “_CEL_O2C_ACTIVITIES”.“USER_TYPE” = ‘B’ THEN 1.0 ELSE 0.0 END)

---

11. Use your knowledge on Value Realization to name the categories of improvement opportunities used in the first step of the Celonis Path to Value. Select the appropriate response (5 Points)
    • Process Step, Sequence, Throughput Time, Attribute, Time
    • Process Step, Sequence, Throughput Time, Automation, Time
    • Process Step, Sequence, Throughput Time, Segregation of Duties, Attribute
    • Process Step, Sequence, Throughput Time, Automation, Attribute

---

12. Use your knowledge on Value Realization to answer the following question. Which Celonis tool is best suited for monitoring? Select the appropriate response (5 Points)
    • Transformation Center
    • Action Engine
    • Event Collection
    • Conformance Check

---

13. Use your knowledge on Value Realization to answer the following question. What is benchmarking used for? Select the appropriate response (5 Points)
    • Benchmarking puts the performance of individual entities into perspective, but can’t be used to derive optimization potentials.
    • Benchmarking is used to validate a potential root cause within the business.
    • Benchmarking puts the performance of individual entities into perspective and can derive optimization potentials.
    • Benchmarking can be used to derive optimization potentials, but doesn’t put the performance of individual entities into perspective.

---

14. Use your knowledge on Value Realization to answer the following question. Which categories of improvement opportunities can be found using the Conformance Check? Select the appropriate response (10 Points)
    • Sequence, Attribute
    • Process Step, Sequence
    • Process Step, Throughput Time
    • Sequence, Automation

---

15. Use your knowledge on the Celonis Ecosystem to answer the following question. Which are tasks of a Celonis Customer Success Manager? Select all that apply (2 Points)
    • Ensure customer retention.
    • Conduct Proof-of-Values.
    • Provide proactive, ongoing support and advice.
    • Initiate success stories.

---

16. Use your knowledge on the Celonis Ecosystem to answer the following question. Which of the following statements are true? Select all that apply. The professional services team is reponsible for… Select all that apply (2 Points)
    • Conducting technical tasks like data extraction, data configuration and building analyses
    • Driving the overall long-term success of their respective customers
    • Executing customer workshops
    • Customer IT infrastructure setup

---

17. Use your knowledge on the Celonis Ecosystem to answer the following question. What should be your first point of contact when you need more technical information on an IBC implementation? Select the appropriate response (2 Points)
    • I use the contextual help center within the Celonis software and browse the IBC help page
    • I go to the Celonis corporate website.
    • I send an email to servicedesk@celonis.com.
    • I contact my Celonis partner manager or Customer Sucess Manager.

---

Click here to see solutions for all Machine Learning Coursera Assignments.
&
Click here to see more codes for Raspberry Pi 3 and similar Family.
&
Click here to see more codes for NodeMCU ESP8266 and similar Family.
&
Click here to see more codes for Arduino Mega (ATMega 2560) and similar Family.

Feel free to ask doubts in the comment section. I will try my best to answer it.
If you find this helpful by any mean like, comment and share the post.
This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,
- APDaga DumpBox