1) In IICS, which task would you use to regularly update a data warehouse with new data from various sources?

2) Which transformation in IICS is best for joining two datasets with a primary key relationship?

3) Which task type in IICS supports schema drift and is ideal for streaming data sources?

4) What does the IICS Data Quality feature help with?

5) Which transformation in IICS is used to match incoming rows against a table and retrieve values?

6) Which of the following is a feature unique to IICS’s Data Integration service?

7) Which of these transformations can help detect and process duplicates in IICS?

8) In IICS, what is the purpose of the Data Integration Hub?

9) Which of the following transformations in IICS is used to filter data dynamically?

10) What does the Expression transformation in IICS NOT do?

11) You are tasked with integrating data from a CRM and an ERP system. Which IICS task would you use to regularly synchronize data between the two systems?

12) You need to perform data masking for sensitive customer data during ETL. Which transformation would you use in IICS to accomplish this?

13) While developing a mapping, you notice that the data has several duplicate entries based on a primary key. Which IICS transformation will help you remove duplicates?

14) A project requires you to merge data from multiple source systems and remove duplicate records. Which two transformations would you use in your mapping to achieve this?

15) You are working on a project where you need to filter data based on a dynamic set of conditions for different business units. Which transformation would you choose for this purpose?

16) You need to schedule a mapping to load data every night. Which IICS feature should you use to set up this recurring schedule?

17) A project requires you to pull data from a flat file and a relational database, then join them on a common key. Which transformation would best suit this scenario?

18) You are tasked with loading a large amount of historical data from on-premises to a cloud data warehouse. Which IICS task type is ideal for this bulk load?

19) You want to execute a task whenever a specific file arrives in an FTP location. Which IICS capability can help you set up this event-based trigger?

20) You need to ensure that multiple ETL tasks run in sequence, where Task B should only run after Task A completes successfully. Which IICS feature would you use?