Recent Posts

Celonis - Data Analyst (Theory MCQ Questions)

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

Celonis - Data Analyst
  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.









  1. “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

  1. 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.

  1. 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

  1. 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








  1. 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

  1. 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)

  1. 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”)

  1. 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)








  1. 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)

  1. 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

  1. 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

  1. 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.

  1. 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








  1. 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.

  1. 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

  1. 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

9 comments:

  1. Hi, I would like know if you have more questions related to Celonis data engineer certification. Please contact me Jagadeeshchaitanya@gmail.com

    ReplyDelete
    Replies
    1. Here are some more questions on Celonis Data Engineering - https://www.apdaga.com/2020/05/celonis-data-engineer-theory-mcq.html

      Delete
  2. Hello Akshay,
    The Celonis - Data Engineer exam contains only MCQ or practical evaluation as well? How Many question comes to MCQ?

    ReplyDelete
    Replies
    1. It has MCQ as well as practical evaluation questions.
      I have shared only answers for the MCQs.

      Delete
  3. Do you have more question for Celonis Analyst exam?

    ReplyDelete
    Replies
    1. No. I tried to summarize all theory questions here.
      All Practical questions are suppose to be solved by you at the time of exam.

      Delete
  4. Syllabus is too huge, how could you remember everything? 151 videos + guided learning. How many theory and how many practical questions are there?

    ReplyDelete
    Replies
    1. 17 theory question out of total 40 or 50 questions. Remaining are practical questions.
      You don't have to remember those 151 videos. Just understand the concept and in exam you get data and do the transformation there itself you will get all the answers.

      Believe me. It's not that hard. All the best.

      Delete
  5. Hi Akshay, I done my exam yesterday and the plataform don’t give me the answer with the correct choose, can you help me to know what is the correct option/s?

    (1 Point) Use your knowledge of Analysis Building to answer the following question: As an Analyst, which of the following can you NOT perform:
    O Make any edits to existing analysis.
    O Make any edits to a Data Model.
    O Make any edits to formulas within an analysis.
    O Make any edits to the Sheet names or properties.


    (1 Point) Using your knowledge of Process Discovery, which of the following are true about the Variant Explorer:
    O Users are able to subsequently add the next most common activity to the process graph.
    a O Users are able to view the % of cases covered for the specific process variant they're viewing.
    O Filters can be applied to activities and connections.
    O Users are able to subsequently add the next most common process variant to the process graph.
    (1 Point) Use your knowledge of Analysis Building to answer the following question: At what point will a draft analysis be live for all Celonis users?
    I Edits are made live once the Analyst exits out of the page or tab.
    O Edits are made live once the Analyst publishes the analysis.
    O Edits are made live once the Analyst clicks on the Celonis logo. •
    Edits are made live once the Analyst turns off the a "Edit" toggle.

    (1 Point) Use your knowledge of Process Discovery to answer the following question: When working with specific violations within Conformance, which of the following statement(s) is/are true:
    O Violations are permanently established and cannot be changed until the next data refresh.
    O When a violation is whitelisted, the conforming cases (both the # and %) should increase.
    O Users can directly view violating cases in the different sheets within the analysis when they click "view cases in...".
    O A violation will only provide a broad view of what the violating case is.

    (1 Point) Use your knowledge of Transformation Center to answer the following question: Which of the following best describes Objectives and KPIs when using Transformation Center?
    0 A KPI represents an initiative for a specific goal-oriented process whereas Objectives allow the KPIs to be measurable.
    O Multiple KPIs can be assigned to an Objective.
    O Objectives without KPIs can provide detailed insights.
    0 An Objective represents an initiative for a specific goal-oriented process whereas KPIs allow Objectives to be measurable.

    ReplyDelete