1) You are tasked with a data integration project where customer records from a database must be updated in a cloud CRM system whenever a new record is added or updated in the database. Which IICS capability would you utilize for real-time data capture?
2) During a mapping task, you need to add a unique identifier to each row. The value should automatically increase with each row. Which transformation will help you achieve this?
3) You need to filter out records in a mapping task where the ‘Order Amount’ is less than $500 before loading the data into the target. Which transformation is the best choice to accomplish this?
4) A project requires joining two datasets based on a key column but allows for rows from the primary dataset that do not match with any row in the secondary dataset. Which join type would you use in the Joiner transformation?
5) You are building a mapping in IICS that must sum the total sales for each region. Which transformation would you use to group data and perform this aggregation?
6) Your project needs to send a notification email if a data load process fails. How can you implement this in IICS?
7) A data pipeline involves transforming data from multiple sources and loading it into a target system. You want to minimize network usage by processing as much data as possible in parallel. Which feature in IICS helps you configure parallel processing?
8) In a project, you need to route incoming data into different target tables based on region (e.g., North America, Europe, Asia). Which transformation can help you accomplish this?
9) You need to extract data from a web API and transform it before loading it into a database. Which IICS feature allows you to connect to REST or SOAP web services as a data source?
10) A requirement in your project calls for data quality checks on incoming data to ensure it meets specific business rules before it is loaded into the target. Which IICS tool can you use to design and apply these data quality rules?
11) You need to set up a process that listens for new files arriving in an FTP directory and then initiates a data load process in IICS. Which feature would you use to automate this event-driven workflow?
12) A project requires you to update records in a target table based on changes in a source table. Which type of mapping task is ideal for this scenario in IICS?
13) You are tasked with creating a reusable mapping logic for common transformation tasks. Which feature in IICS allows you to encapsulate transformation logic that can be reused in multiple mappings?
14) A data integration project requires incremental data loading from an on-premises database to a cloud data warehouse every night. Which feature in IICS best supports this scenario?
15) You need to load data from multiple source systems into one target table, while filtering out records with null values in a specific column. Which two transformations would you use?
16) In your ETL process, you need to add business rules and calculations to transform the data as it flows through the mapping. Which transformation in IICS is best suited for applying these rules?
17) A project requires you to route data to multiple targets based on specific conditions and also to execute different branches based on those conditions. Which combination of IICS features would you use?
18) You need to load only the newly created and updated records from a source table into a target database, without affecting existing records in the target. Which IICS operation should you configure?
19) In a project where your data needs to be loaded into a cloud data lake, you need to track the data lineage for compliance purposes. Which IICS tool can help you monitor and document data lineage?
20) To integrate with an existing CI/CD pipeline, you need to automate deployment of mappings and taskflows in IICS. Which tool or feature facilitates this process?
