Celonis - Get Data into the EMS

What is an event log? Select 2 correct answers... A. A log of all activities that occur in the lifecycle of each case B. A system used to keep track of internal events C. Used by Celonis to reconstruct the process that occurs across multiple systems D. A log of activities for individual occurrences of events for multiple cases

A. A log of all activities that occur in the lifecycle of each case & C. Used by Celonis to reconstruct the process that occurs across multiple systems

When scoping data requirements for a process, which points should you consider? A. Activities B. System Performance C. Dimensions D. Key Metrics E. Branding

A. Activities & C. Dimensions D. Key Metrics

How do you build the Process Data Model in Data Integration? Select 3 correct answers... A. By connecting systems and extracting data B. By transforming data to build relevant tables C. By drag and dropping data from source systems into Celonis D. By automating the building with AI E. By loading data into a Data Model

A. By connecting systems and extracting data B. By transforming data to build relevant tables & E. By loading data into a Data Model

Which of the following are best practices for queries containing table joins? Select 3 correct answers... A. Join only tables that are really required and used (e.g. in SELECT) B. Filter tables within JOIN instead of within WHERE C. Filter tables within WHERE instead of within JOIN D. Use EXISTS when you want to combine columns from two tables E. Apply a proper filter so that only relevant records are processed

A. Join only tables that are really required and used (e.g. in SELECT) B. Filter tables within JOIN instead of within WHERE & E. Apply a proper filter so that only relevant records are processed

A query execution plan provides crucial assistance for query optimization by showing the following elements. Select 3 correct answers... A. Join type B. Alternative (more suitable) join condition C. Estimated query cost D. NO STATISTICS indicator

A. Join type & C. Estimated query cost D. NO STATISTICS indicator

Q: Once you have built a Data Model, what do you also need to consider in Data Integration? A. Scheduling B. Monitoring C. Analysis D. Performance

A. Scheduling B. Monitoring & D. Performance

You've set up a Data Pipeline using both Data Jobs and the Replication Cockpit, what can you do to get notified if anything fails? Select 3 correct answers... A. Set up Data Job alerts B. Set up Replication alerts C. Set up a regular export of the Monitor Dashboard to be sent to your email on a daily basis D. Subscribe to your Data Model(s)

A. Set up Data Job alerts B. Set up Replication alerts & D. Subscribe to your Data Model(s)

Which elements of a temporary join table have a major impact on query performance? Select 2 correct answers... A. Table sorting B. Number of columns C. Existence of table statistics

A. Table sorting & C. Existence of table statistics

If the query contains complex definitions (e.g. multiple joins and conditions), what object should you create? A. Temporary Join Table B. View C. Either of the two

A. Temporary Join Table

Which of these statements are accurate when considering N:1 table relationships in your Data Model. Select 2 correct answers... A. The "N" table is the Fact table B. The "N" table is the Dimension table C. The "N" table has multiple entries per one entry in the dimension table D. The "N" table has one entry for multiple entries in the dimension table

A. The "N" table is the Fact table & C. The "N" table has multiple entries per one entry in the dimension table

What is the most essential table we build in Data Integration? A. The Activity Table B. The Case Table C. The Metadata Table D. The Transactional Data Table

A. The Activity Table

You need to link an Activity table to its Case table in the Data Model view. How should you set this up? Select 2 correct answers... A. The Activity table should be the N table and the Case table the 1 table. B. The Activity table should be the 1 table and the Case table the N table. C. The foreign key link can be done either using the Case ID or the individual columns that represent the Case ID. D. Only the Case ID should be used to link the tables.

A. The Activity table should be the N table and the Case table the 1 table. & C. The foreign key link can be done either using the Case ID or the individual columns that represent the Case ID.

What differentiates the Replication Cockpit (RC) from Data Jobs (DJ)? Select 2 correct answers... A. The RC allows for real-time extractions B. The RC requires less set up work C. The RC works with any source system D. The RC does not use delta filters

A. The RC allows for real-time extractions & D. The RC does not use delta filters* *The Replication Cockpit uses triggers & change logs in source systems to capture delta records.

When scripting transformations for Data Model tables in the Replication Cockpit (RC), what are some clear differences to Data Job (DJ) transformations? Select 2 correct answers... A. The RC transformation select from the staging table instead of the raw table. B. The RC transformation does not use any joins. C. There are no templates for RC transformations D. The RC transformation uses a Delete / Insert approach as it handles Delta values.

A. The RC transformation select from the staging table instead of the raw table. & D. The RC transformation uses a Delete / Insert approach as it handles Delta values.

You are setting a new transformation in the Replication Cockpit, aside from the script itself, what else do you need to consider? Select 2 correct answers... A. The Trigger Table B. The Database Triggers C. The Dependencies D. The Change Log Table

A. The Trigger Table & C. The Dependencies

When scoping Key Metrics, what should you consider? A. The formula used to calculate B. The frequency of the Key Metric calculation C. The object used to display the key metric in an analysis D. The tables and fields needed

A. The formula used to calculate & D. The tables and fields needed

What are the top three points to consider when selecting a unique identifier? A. The unique identifier should be as granular as possible B. The unique identifier must consist of numbers only C. The project scope and strategic goals must be kept in mind D. There must be clear 1-to-1 mappings between the unique identifiers in respective systems

A. The unique identifier should be as granular as possible & C. The project scope and strategic goals must be kept in mind D. There must be clear 1-to-1 mappings between the unique identifiers in respective systems

What is the point of Name Mapping? Select 2 correct answers... A. To facilitate downstream work using your Data Model B. To add funky names to tables and give colleagues a good laugh C. To map names of users needing access to the Data Model D. To translate technical table names into human language

A. To facilitate downstream work using your Data Model & D. To translate technical table names into human language

What does it mean to initialize in the Replication Cockpit? A. To run a full extraction and kick off replications B. To start the Replication Cockpit Engine C. To set up the initial configuration

A. To run a full extraction and kick off replications

When does using a partial Data Model load make sense? Select 2 correct answers... A. When executing individual transformations and wanting to update a portion of the Data Model B. When setting up schedules that update only certain tables C. When the EMS does not have enough capacity to do a full Data Model load D. When certain tables are no longer necessary in the Data Model and can be deleted

A. When executing individual transformations and wanting to update a portion of the Data Model B. When setting up schedules that update only certain tables

You've set up multiple Activity and case tables in your Data Model, what happens when you turn on "Eventlog automerge" and load your Data Model? A. The Data Model automatically finds and adds foreign key relationships to your Data Model and merges them all B. All Activity tables are merged into a new _CEL_MERGED_ACTIVITIES table based on the default Activity table C. The seperate Activity tables are merged and all the different Case IDs are kept in the merged table D. The Activity and Case tables are all merged into one table

B. All Activity tables are merged into a new _CEL_MERGED_ACTIVITIES table based on the default Activity table

Which tables should you be extracting in real-time with the Replication Cockpit? Select 2 correct answers... A. Master Data tables B. Any table tracking activities C. The Case table D. Translation tables

B. Any table tracking activities C. The Case table

Where would you insert EXPLAIN to generate a query execution plan? A. Before CREATE TABLE B. Before SELECT C. At the end of the query D. After SELECT

B. Before SELECT

How can you check if tables are missing table statistics? A. By executing SELECT SHOW_STATISTICS('TableName') B. By reading the query execution plan (EXPLAIN) C. By querying one of the system tables (e.g. Projections) D. By checking the JOIN type. HASH join indicates missing statistics

B. By reading the query execution plan (EXPLAIN) C. By querying one of the system tables (e.g. Projections)

A business expert tells you the number of cases in your Data Model in incorrect, what can you do? Select 2 correct answers... A. Add a "Distinct" to all of your SELECT statements in transformations B. Check the number of cases on the database C. Check the foreign key links of your Data Model D. Check filters and joins in your Data Jobs tasks

B. Check the number of cases on the database & D. Check filters and joins in your Data Jobs tasks

Which columns should you place at the beginning when creating temporary join tables? A. Columns containing big number of characters B. Columns used for joins with other tables C. Columns containing aggregate values D. Data type columns

B. Columns used for joins with other tables

You have 8 processes running with many different Schedules and Data Jobs, what is a good way to get a full overview of your Data Pipeline's health? A. Set up alerts on all Data Jobs B. Enable Custom Monitoring and work with Analyses C. Subscribe to all your Data Models D. Regularly check all logs for all of your processes

B. Enable Custom Monitoring and work with Analyses

Why should you add the Case Table to your Data Model? Select 2 correct answers... A. Without it, the Data Model will not load B. It usually serves as a key table that links to master data tables C. It's important for KPI calculations such as Case Count D. It is crucial for the functioning of schedules and the calendar

B. It usually serves as a key table that links to master data tables C. It's important for KPI calculations such as Case Count

Which of the following two statements are TRUE? A. Celonis cannot map out a process that is executed in multiple systems. B. No matter how many systems involved in a process, it can always be reconstructed end-to-end as long as we can trace and link the cases across these systems. C. A unique identifier is a way to recognize a case as it moves through the process D. It is not necessary to know the ideal flow of a process

B. No matter how many systems involved in a process, it can always be reconstructed end-to-end as long as we can trace and link the cases across these systems. C. A unique identifier is a way to recognize a case as it moves through the process

You want to run your transformations in a Data Job optimally, what steps should you take? A. Put the transformations in the right sequence B. None - Smart ETL takes care of it for you C. Seperate the transformations into seperate Data Jobs with multiple schedules

B. None - Smart ETL takes care of it for you

When scripting transformations for Activities in the Replication Cockpit, what are two important steps to take? A. Add a Replication Cockpit column to the Activity Table B. Split the Activity table C. Apply a suitable Delta approach D. Remove all timestamp tracking

B. Split the Activity table C. Apply a suitable Delta approach

A business expert asks you how a specific activity was defined, what information should you provide? Select 2 correct answers... A. The Data Job and Schedule used B. The timestamp used C. The filters/joins applied D. The parameters used

B. The timestamp used C. The filters/joins applied

You are merging Case Tables in a Global Data Job, which SQL statement should you use? A. GROUP BY B. UNION ALL C. MERGE ALL D. INNER JOIN

B. UNION ALL

How can you rapidly build a Data Model in Data Integration when working with common systems and processes? A. Work with Google and Stack Overflow B. Use Process Connectors from the Marketplace C. Use the ML Process Data Model Creator script D. Automate the creation using Action Flows

B. Use Process Connectors from the Marketplace

A source system has REST APIs but no Celonis Process Connectors or Extractors are available. How should you extract data from the system? A. Use the Data Push API B. Use the Extractor Builder C. Use the File Upload D. Use the Celoxtractor

B. Use the Extractor Builder

You need to get a one time report with sample data into Celonis, what is the fastest way to do this? A. Use the Celoxtractor B. Use the File Upload C. Use a Process Connector D. Use the Data Push API

B. Use the File Upload

If you want to only select records from table A that have corresponding records in table B, but you don't need any column from table B, you should use: A. JOIN B. WHERE EXISTS C. Any of the two

B. WHERE EXISTS

Adding a JOIN solely for filtering purposes is a bad practice that could lead to record duplication and require DISTINCT. Consequently, it will slow down the query. This situation can be resolved by using... A. GROUP BY B. WHERE EXISTS instead of JOIN C. LEFT JOIN instead of JOIN

B. WHERE EXISTS instead of JOIN

One of your source systems contains information on 2 seperate processes you would not like to see any correlation on. How could you set up your Data Jobs to minimize system load and keep your work at a minimum? A. With 2 Data Jobs, each containing extractions and transformations for the seperate processes B. With 1 Data Job for all extractions and 1 per process for all table creations C. With 1 Data Job for all extractions and transformations D. With 1 Global Data Job handling all extractions and transformations

B. With 1 Data Job for all extractions and 1 per process for all table creations

You have three of the same source systems running the same process in different countries. What steps would you take to bring the process data into a Data Model? A. Create 3 Data Pools each with a Data Model, and bring the Data Models together in an Analysis B. Create 3 Data Jobs and use templates to re-use tasks across them C. Create a Global Data Job to merge the Data Model tables D. Share one Data Connection across three Data Pools

C. Create a Global Data Job to merge the Data Model tables

You currently have 1 Data Job in your Data Pool with all extractions, transformations, and your Data Model load. A portion of your extractions and transformation tasks should be scheduled to run more frequently. How can you set this up? A. Schedule a partial load of your Data Job selecting only the tasks you need B. Schedule a Delta Load of your Data Job with only the tasks you need C. Create a separate Data Job with only the tasks you need and set it on a separate schedule D. Manually run the tasks you need every day after drinking your cup of coffee

C. Create a separate Data Job with only the tasks you need and set it on a separate schedule

Three of your processes are related to one another. How should you go about structuring your data in Data Integration? A. Create 1 Data Pool per process B. Create 1 Data Job per process C. Create only 1 Data Pool for the 3 processes D. Create only 1 Data Job for the 3 processes

C. Create only 1 Data Pool for the 3 processes

When using both the Replication Cockpit and Scheduled Data Jobs, what are 2 use cases for Scheduled Data Jobs? A. Table creations B. Hourly loads C. Delta and Full loads for table not covered by the Replication Cockpit D. Data Model loads

C. Delta and Full loads for table not covered by the Replication Cockpit D. Data Model loads

A business expert reports to you that the Total Net Value of all cases seems off. What is typically the primary source of errors here? A. Wrong Data Model Calendars B. Wrong joins and filters C. Wrong Currency Conversions D. Wrong activity timestamps

C. Wrong Currency Conversions

Using Views in transformations often negatively affects the overall performance and significantly increases the total transformation time. Generally, creating a view instead of a temporary join table... A. is always wrong B. is the preferred approach because it saves the storage C. should be limited to Data Model tables only

C. should be limited to Data Model tables only

What is the main difference between connecting Celonis to a closed vs open hosting environment? A. For open environments, the connection is "uplinked" and secured through https. B. For closed environments, Change log and triggers need to be set up. C. For open environments, an RFC module is required for the Extractor Server to work properly. D. For closed environments, the Extractor Server is installed in the hosting environment.

D. For closed environments, the Extractor Server is installed in the hosting environment.

You are joining table A and table B, both of which are not sorted on the same join columns. What type of join will be performed? A. FULL OUTER JOIN B. MERGE JOIN C. NATURAL JOIN D. HASH JOIN

D. HASH JOIN

Your source system only allows extractions at very specific times during the night on specific days. How can you set up an appropriate schedule? A. Set up an hourly schedule but restrict it using the Data Model Calendar B. Set up an hourly schedule and restrict the connection user's rights to only be allowed access during the night C. Set up a daily schedule with the right time and deactivate it on prohibited days D. Set up a schedule using Custom Cron

D. Set up a schedule using Custom Cron "Custom Cron" is a scheduling option that allows you to customize the time intervals of your schedule.

You need to set up a Data Model for a standard process based on SAP, how should you go about it? A. Use an Extractor B. Build an Extractor using the Extractor Builder C. Upload a file export using the File Upload D. Use a Process Connector from the Marketplace

D. Use a Process Connector from the Marketplace

You would like to test and save your work in Data Integration before deploying to a production environment. How can you do this in Data Integration? A. With Data Pool Duplication B. By sharing Data Connnections C. By using templates and downloading your SQL scripts regularly D. With Data Pool versioning

D. With Data Pool versioning

Every time a Data Job is run, the Data Model is fully reloaded. True or False?

FALSE

You can build a Knowledge Model without a Data Model. True or False?

FALSE

You can build a View directly off of a Data Model. True or False?

FALSE

One of the ways to check if all tables in certain queries contain statistics is by reading the query execution plan (EXPLAIN function). If there is "NO STATISTICS" next to a table name, the given table has no statistics. True or False?

TRUE

You should add the SELECT ANALYZE_STATISTICS ('TABLE NAME'); after each "Create table" query statement that creates and populates a table. The database then gathers statistics when the transformation or query is run. True or False?

TRUE