Mixed Deck — All ICC Topics Flashcards

What is benchmarking in the context of Informatica Cloud Certification quality management?

Answer: Comparing performance against best practices or competitors

Benchmarking involves comparing your processes and performance metrics to industry best practices to identify improvement areas.

When an IICS Workflow uses a sub-workflow (child workflow), how are output values passed back to the parent workflow?

Answer: Through output parameters defined on the sub-workflow task

Sub-workflows expose output parameters that parent workflows can read after the sub-workflow task completes.

What is the effect of enabling 'incremental' deployment mode when importing an IICS package into a target organization?

Answer: Existing objects with the same name are skipped; only new objects are created

Incremental import mode skips objects that already exist in the target org and only creates net-new objects, preventing accidental overwrites.

In IICS, what is the significance of the 'Base URL' field when configuring an API Group?

Answer: It defines the common URL prefix shared by all APIs published under that group

The Base URL is the common path prefix prepended to each individual API's relative URL within a group, forming the full endpoint address.

Which security model is widely used in cloud computing to control access?

Answer: Role-Based Access Control (RBAC)

Role-Based Access Control (RBAC) is a widely adopted security model in cloud computing that assigns permissions and access rights to users based on their organizational roles. Instead of granting individual permissions, users are assigned roles, and these roles have predefined access to resources. RBAC simplifies access management and enhances security by ensuring the principle of least privilege.

In IICS, which Workflow feature allows you to define reusable logic as a component that multiple workflows can invoke?

Answer: Sub-workflow (reusable workflow)

A reusable sub-workflow encapsulates logic once and can be called from multiple parent workflows, promoting DRY design principles.

In IICS, what is the difference between a 'reusable transformation' and a 'mapplet'?

Answer: A reusable transformation is a single transformation instance; a mapplet is a reusable pipeline segment containing multiple transformations

A reusable transformation is one saved transformation instance reused across mappings, while a mapplet encapsulates an entire sub-pipeline with multiple transformations as a single reusable unit.

When designing IICS integrations that must comply with data residency regulations (e.g., GDPR), which architectural control is most relevant?

Answer: Selecting a Secure Agent and IICS pod region that keeps data within the required geography

Data residency compliance requires that both the IICS pod (cloud infrastructure region) and the Secure Agent processing data are located within the required geographic boundary.

Which approach in IICS best supports an ELT (Extract, Load, Transform) pattern for a cloud data warehouse?

Answer: Using pushdown optimization or serverless runtime to execute SQL on the warehouse

Pushdown optimization or serverless runtime pushes transformation SQL directly to the data warehouse engine, implementing the ELT pattern natively.

Which cloud storage class is most cost-effective for data that is accessed less than once per year?

Answer: Archive/Glacier storage

Archive-tier storage (e.g., AWS Glacier, Azure Archive) has the lowest storage cost but highest retrieval latency and cost, making it ideal for rarely accessed data.

Informatica Cloud's data masking transformation replaces sensitive values using a substitution dictionary. Which data structure gives the fastest substitution lookup?

Answer: Hash map

A hash map provides O(1) average-case lookup, making it the fastest structure for substituting sensitive values from a pre-built dictionary.

In IICS, what is the recommended approach for storing sensitive credentials used by connections in a DevOps pipeline?

Answer: Store them in the CI/CD system's secret manager and inject via IICS REST API at deploy time

Credentials should live in a secrets manager (e.g., HashiCorp Vault or CI/CD secrets) and be pushed to IICS connections via the REST API during deployment, never stored in source control.

What does the PDCA cycle stand for in quality management?

Answer: Plan, Do, Check, Act

PDCA (Plan, Do, Check, Act) is a four-step management method for continuous improvement of processes and products.

What is the role of an API gateway in a cloud microservices architecture?

Answer: Acts as a single entry point that routes, authenticates, and rate-limits client requests to backend services

An API gateway sits in front of microservices to handle cross-cutting concerns like authentication, SSL termination, rate limiting, and request routing.

What is the primary function of Informatica Cloud Data Integration?

Answer: ETL (Extract, Transform, Load) operations

Informatica Cloud Data Integration is a cloud-native platform primarily designed to perform ETL (Extract, Transform, Load) operations. It facilitates the movement and transformation of data between various sources and targets, enabling businesses to integrate data across diverse applications and databases. This core function is essential for data warehousing, analytics, and application synchronization.

Which IICS feature allows you to parameterize a mapping so the same design can run against different source tables at runtime?

Answer: Dynamic mapping with schema at run time

Dynamic mappings allow the source or target schema to be resolved at runtime using parameters, enabling one mapping to process multiple tables.

When validating an IDMC API-triggered integration using Application Integration, which tool is most appropriate for sending test HTTP requests and inspecting responses?

Answer: An external REST client such as Postman or curl

External REST clients like Postman or curl allow testers to craft specific HTTP requests, inspect headers, payloads, and status codes independently of the IDMC UI.

In Informatica Cloud, when flattening a deeply nested JSON array into relational rows, which recursive algorithm pattern is applied?

Answer: Depth-first traversal with a call stack

Depth-first traversal using a call stack recurses into each nested array level before moving to siblings, naturally flattening the hierarchy.

In IDMC, what is the key difference between 'Normal' and 'Full' recovery strategies when testing a failed Mapping Task rerun?

Answer: Normal resumes from the last committed checkpoint; Full reruns the entire task from the beginning

Normal recovery resumes processing from the last successful checkpoint, while Full recovery restarts the entire task from scratch regardless of prior progress.

Which Informatica Cloud service is purpose-built for real-time data streaming and event-driven integration?

Answer: Cloud Application Integration

Cloud Application Integration (formerly Cloud Integration Hub / Process Designer) handles real-time, event-driven integration and process orchestration.