IDMC - CDI Professional Certification Practice Questions

Which of the following Data load types are possible in IICS?

Informatica Cloud is a cloud based iPaaS solution

iPaaS stands for ___

IICS can be used for?

Which of the following is not a Flat file connection property?

To validate a Salesforce connection, you always need security token

Where does the data in tasks and mappings normally get processed?

Secure Agent is ___

You want to load Account records to Salesforce from a .csv source file where 'BillingState'=NY and 'Annual_Revenue'>10000000. Will a simple filter work?

As the field expression syntax is based on database SQL, it cannot be used on data read from a flat-file source.

Which of the following task operations is not supported for a Flat File target in Synchronization task?

You cannot run multiple instances of a synchronization task simultaneously.

A Synchronization task can be used to delete records.

What does the field selection criteria - 'All Fields' do?

To include all incoming fields from an upstream transformation except those with dates, what should you do?

A mapping with a single transformation that is not connected to another downstream object

Which of the following can be used to write to multiple types of targets?

How does a mapping differ from a Synchronization Task?

The Cloud Mapping Designer permits a single mapping to have more than one target.

Each Mapplet transformation can contain ____

You can call connected Lookup in a :LKP expression

A mapplet is a resuable transformation logic

Jennifer is working on creating a report. She has sales data for all regions. She would like to determine total sales per region. She would also like to get the average deal size per region. Which transformation should she be using?

All mappings created within the Cloud Mapping Designer must have atleast one parameter

Which of the following is a possible reason why a parameter file might cause a mapping to fail?

A conversion function is necessary when a non-string value is used in a parameter file

What is the purpose of the Field Mapping in the Cloud Mapping Designer in the Target transformation?

You have edited(updated) a mapping and the mapping ran but your changes did not take effect. What is the possible reason?

Which of the following lookup properties cannot be parameterized

Which of the following types of macro cannot be created in IICS?

Timestamps can be added as part of flatfile name

You cannot simultaneously run multiple Data Replication tasks that write to same target table

You have a data synchronization task that is performing a lookup on the Salesforce Account object to return the Salesforce ld and match contacts to their correct Account records, but that task is running very slowly. Why might that be and what can you do to speed up the task?

When using data masking task, the target object may contain more fields than source.

What determines which data masking rules are available?

You can use a Taskflow to pass parameters to a task

Which of the following cannot be a part of Linear Taskflow?

IICS validates the SQL during the design time

Which of the following is not one of the use cases for Lookup SQL Override?

Which of the following is not one of the type of XML Payload messages?

Hierarchy Parser and Hierarchy Builder transformations can be used without Hierarchal Schema

Parameterized mapping tasks can be modified using the IICS REST API

Which of the following are benefits of IICS REST API ?

Fatal exceptions result in the stopping of the session

When running tasks in IICS, which of the following error types could be encountered?

When you create a Secure Agent group, by default, all the users in the organization can select the Secure Agent group as the runtime Environment

What types of ELT Optimizations are supported in IICS?

All connections support Partitioning in IICS

Can a user start a task during a Schedule Blackout Period?

If the permission is not configured for an asset, then the asset cannot be used

Which of the following asset types can be migrated to a different IICS Organization?

Which of the following target operations are available in Data Transfer Task for the users to select?

In a Data Transfer Task, it is mandatory to set up one or more lookup conditions when you choose a second source to utilize as a lookup source.

Only a single object can be configured as a target in the Data Transfer Task.

A File Listener can be configured to define a file event that triggers notification to which of the following assets ?

To trigger taskflow based on file event, you have to define the Binding type as ____

A File Listener component in Informatica Cloud listens to file events on a defined location and file pattern.

A Dynamic mapping task reduces the number of assets that you need to manage if you want to reuse a parameterized mapping.

What are the supported options for the parameter scope that can be configured for the mapping parameters in Parameters page of Dynamic Mapping Task wizard

Which of the following properties of a Job cannot be configured in a Dynamic Mapping Task?

Intelligent structure model in mappings can be used to parse which of the following types of data?

After Intelligent Structure Discovery discovers the structure of the model input, the user can:

In which of the following tabs, Intelligent structure model displays the output in a tree-like structure?