IICS Certification IICS Certification MCQ 3 — Questions and Answers
Question 1: In IICS Metadata Manager, what is the primary function of a 'Catalog Source Configuration'?
- It defines the credentials and schedule for scanning a data source to extract metadata (Correct answer)
- It maps physical columns to business glossary terms automatically
- It configures row-level security for sensitive catalog assets
- It generates profiling statistics for all discovered tables
Correct answer: It defines the credentials and schedule for scanning a data source to extract metadata
A Catalog Source Configuration specifies the connection, scope, and scan schedule that CLAIRE uses to harvest metadata.
Question 2: Which transformation in IICS Data Integration allows you to call a stored procedure on a relational database?
- SQL Transformation
- Stored Procedure Transformation (Correct answer)
- Expression Transformation
- Custom Transformation
Correct answer: Stored Procedure Transformation
The Stored Procedure transformation calls a database stored procedure and can pass parameters in and out.
Question 3: What is the role of a 'Connection' object in IICS that is shared across multiple assets?
- It stores the runtime logs for each asset that uses it
- It centralizes credential and endpoint configuration so assets don't hard-code them (Correct answer)
- It defines the IPU consumption rate for the associated service
- It enforces data masking rules for all linked mappings
Correct answer: It centralizes credential and endpoint configuration so assets don't hard-code them
A shared Connection object stores endpoint, credentials, and driver settings once, allowing many assets to reference it without duplication.
Question 4: In IICS Application Integration, which artifact type defines the data structure passed between service steps?
- Process Object (Correct answer)
- Service Connector
- Guide
- BPEL fragment
Correct answer: Process Object
A Process Object defines the schema of complex data types used as inputs, outputs, or intermediate data within Application Integration processes.
Question 5: Which IICS Advanced Cluster option allows mappings to use Apache Spark as the execution engine?
- Enhanced Mode on Secure Agent
- Advanced Mode mapping with a Serverless Runtime Environment (Correct answer)
- Pushdown to Hadoop
- In-memory caching with Redis
Correct answer: Advanced Mode mapping with a Serverless Runtime Environment
Advanced Mode mappings run on a Serverless Runtime Environment powered by Spark, enabling distributed processing of large datasets.
Question 6: In IICS, which schedule type fires a task automatically when a file lands in a monitored cloud storage location?
- Time-based schedule
- File Listener schedule (Correct answer)
- Event Monitor trigger
- Webhook-based schedule
Correct answer: File Listener schedule
A File Listener schedule polls or subscribes to a storage location and triggers the task as soon as a matching file is detected.
Question 7: What does a 'Flat File' source definition's 'Import from File' action do in IICS?
- Uploads the file directly to the target without any transformation
- Reads a sample file to automatically detect column names, delimiters, and data types (Correct answer)
- Converts the file to Parquet format for better performance
- Registers the file in the CLAIRE catalog for lineage tracking
Correct answer: Reads a sample file to automatically detect column names, delimiters, and data types
Importing from a file lets IICS parse a sample to infer the schema, saving you from manually defining each column.
IICS Certification IICS Certification MCQ 3
In IICS Metadata Manager, what is the primary function of a 'Catalog Source Configuration'?