Mixed Deck — All IICS Certification Topics Flashcards
100 cards from real IICS Certification practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 20 Mixed Deck — All IICS Certification Topics flashcards as text
In IICS, what does an 'Advanced Cluster' runtime environment use under the hood?
Answer: Apache Spark for distributed processing
The Advanced Cluster in IICS leverages Apache Spark for scalable, distributed data processing.
What is the purpose of the 'Pre-SQL' and 'Post-SQL' options available in IICS source and target transformations?
Answer: Execute custom SQL commands before and after reading or writing data
Pre-SQL and Post-SQL allow you to run arbitrary SQL (e.g., disabling indexes, truncating staging tables) immediately before or after the main data operation.
In IICS, what does the term 'pushdown optimization' refer to?
Answer: Running transformation logic in the source or target database instead of the Secure Agent
Pushdown optimization allows IICS to push transformation logic as SQL to the source or target database, reducing data movement and improving performance.
In IICS Mass Ingestion Databases, which source database types are typically supported for CDC?
Answer: Oracle, SQL Server, MySQL, PostgreSQL, and other major enterprise relational databases
Mass Ingestion Databases supports CDC from major relational databases including Oracle, Microsoft SQL Server, MySQL, and PostgreSQL.
Which IICS scheduling option should be used when a task needs to run at a specific time only once?
Answer: One-time schedule
A one-time schedule in IICS allows you to configure a task to execute exactly once at a specified future date and time.
What is the purpose of 'API subscription plans' in IICS API Center?
Answer: Defining different tiers of access with varying rate limits, quotas, and features for different consumer categories
Subscription plans let API providers offer different access tiers — for example, basic vs. premium — each with different rate limits and allowed features.
In IICS Data Integration, what is a 'Mapping Task'?
Answer: A runnable instance of a mapping with a specific runtime configuration
A Mapping Task is a runnable object that pairs a mapping with a specific Secure Agent and runtime settings.
What is the purpose of IICS 'User Roles' in access control?
Answer: To grant users specific permissions to view, design, run, or administer IICS assets and services
User Roles assign predefined sets of permissions to users, controlling what they can see and do across IICS services and assets.
Where in IICS can an administrator view the health and status of all Secure Agents across the entire organization?
Answer: Administrator > Runtime Environments page
The Administrator tab's Runtime Environments page displays the status, version, and health of all Secure Agents across the organization's runtime environments.
What is the role of the 'Secure Agent' in IICS?
Answer: A lightweight software installed on-premise or in a private cloud that executes jobs and securely communicates with IICS
The Secure Agent is a lightweight program installed in a customer's environment that runs integration tasks and communicates securely with the IICS cloud platform.
What is the purpose of 'projects' and 'folders' in IICS for asset organization?
Answer: They provide a hierarchical organizational structure for grouping and managing assets with access permissions
Projects and folders organize assets hierarchically in IICS and are used to control access permissions at the project or folder level.
Which transformation in IICS Data Integration is used to remove duplicate rows from a data stream?
Answer: Dedup
The Dedup transformation identifies and removes duplicate rows based on specified key fields.
Which connection property must be configured to enable SSL encryption when connecting to a MySQL database in IICS?
Answer: Use SSL
The 'Use SSL' property in the MySQL connection configuration enables SSL-encrypted communication between the Secure Agent and the MySQL server.
You can process data using Mapping Configuration Tasks according to the data flow logic specified in:
Answer: True
Data Warehousing (DW) is a process for collecting, storing, and managing data from various sources to provide meaningful business insights and support decision-making. A data warehouse is a central repository that consolidates data from different operational systems, such as transactional databases, CRM systems, ERP systems, and more. The data is extracted, transformed, and loaded (ETL) into the data warehouse, where it is organized in a structured manner to support reporting, analysis, and data mining.
What does the 'Incremental Load' option in a Mass Ingestion Databases task control?
Answer: It loads only rows modified since the last successful run using a watermark
Incremental Load uses a high-watermark column (such as a timestamp) to fetch only changed or new rows since the previous run.
In IICS, which type of task is used to execute an operating system command or shell script on the Secure Agent host?
Answer: Command Task
A Command Task in IICS executes OS-level shell commands or scripts on the machine where the Secure Agent is installed.
In IICS, which Runtime Environment configuration option controls the maximum number of simultaneous jobs that a runtime environment will execute?
Answer: There is no fixed limit; it is governed by Secure Agent hardware resources
IICS does not enforce a platform-level concurrent job limit on a Runtime Environment; actual concurrency capacity is determined by the Secure Agent host's available CPU and memory resources.
Users of Informatica Cloud are able to combine data from on-premise databases and applications with cloud-based applications.
Answer: True
No, a Service Call Step does not necessarily require a screen step. A Service Call Step is typically used in workflow or process automation tools to invoke a web service or API and interact with external systems or services. While a screen step is a user interface element used for displaying information or gathering input from users, a Service Call Step is focused on making a request to a service and processing the response.
In IICS Data Integration, which transformation is used to split a single input row into multiple output rows based on a field with delimited values?
Answer: Normalizer
The Normalizer transformation converts a single row containing repeated or delimited data into multiple output rows.
Which IICS security feature restricts which data assets a user can view in the CLAIRE catalog based on their role?
Answer: Asset-level permissions in Metadata Command Center
Metadata Command Center applies asset-level and resource-group permissions so users only see catalog assets authorized for their role.