IDMC - CDI Professional Certification Practice Questions
63 Questions
39 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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

  • Cloud to Cloud
  • Cloud to On-Premise
  • On-Premise to Cloud
  • All of the above (correct)

    • Informatica Cloud is a cloud based iPaaS solution

    True

    iPaaS stands for ___

  • Infrastructure Platform as a Service
  • Integration Platform as a Source
  • Integration Platform as a Service (correct)
  • Infrastructure Platform as a Source

    • IICS can be used for?

    <p>All of the above</p> Signup and view all the answers

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

    <p>Delimiter</p> Signup and view all the answers

    To validate a Salesforce connection, you always need security token

    <p>False</p> Signup and view all the answers

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

    <p>In the IICS Secure Agent</p> Signup and view all the answers

    Secure Agent is ___

    <p>a lightweight 64-bit self upgrading program that runs on a machine in the customer's network, or on Amazon, Azure or Google, or hosted by Informatica Cloud</p> Signup and view all the answers

    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?

    <p>True</p> Signup and view all the answers

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

    <p>False</p> Signup and view all the answers

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

    <p>Upsert</p> Signup and view all the answers

    You cannot run multiple instances of a synchronization task simultaneously.

    <p>True</p> Signup and view all the answers

    A Synchronization task can be used to delete records.

    <p>True</p> Signup and view all the answers

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

    <p>Includes or Excludes all fields</p> Signup and view all the answers

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

    <p>Configure two field rules. First, use the All Fields rule to include all fields. Then, create a Fields by Datatype rule to exclude fields by data type and select Date/Time as the data type to exclude</p> Signup and view all the answers

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

    <p>is invalid and cannot be run</p> Signup and view all the answers

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

    <p>Cloud Mappings</p> Signup and view all the answers

    How does a mapping differ from a Synchronization Task?

    <p>A mapping can read from multiple types of source objects in a single task</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    Each Mapplet transformation can contain ____

    <p>one mapplet</p> Signup and view all the answers

    You can call connected Lookup in a :LKP expression

    <p>False</p> Signup and view all the answers

    A mapplet is a resuable transformation logic

    <p>True</p> Signup and view all the answers

    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?

    <p>Aggregator</p> Signup and view all the answers

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

    <p>False</p> Signup and view all the answers

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

    <p>The parameter file name was changed</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

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

    <p>Allows fields from source to be mapped to the fields in the target</p> Signup and view all the answers

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

    <p>The changes were not saved</p> Signup and view all the answers

    Which of the following lookup properties cannot be parameterized

    <p>Lookup type(single or multi-return)</p> Signup and view all the answers

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

    <p>Declarative Macro</p> Signup and view all the answers

    Timestamps can be added as part of flatfile name

    <p>True</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    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?

    <p>Informatica Cloud uses one API call per lookup which is expensive and slows the process down. To increase performance, create a Data Replication task that extracts the Salesforce ID and the lookup value (Name for example and the Salesforce ID for that record) into a file or database table and use this in lookup function</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    What determines which data masking rules are available?

    <p>Datatype</p> Signup and view all the answers

    You can use a Taskflow to pass parameters to a task

    <p>True</p> Signup and view all the answers

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

    <p>Schedule Task</p> Signup and view all the answers

    IICS validates the SQL during the design time

    <p>False</p> Signup and view all the answers

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

    <p>Changing the lookup data in lookup source</p> Signup and view all the answers

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

    <p>JSON</p> Signup and view all the answers

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

    <p>False</p> Signup and view all the answers

    Parameterized mapping tasks can be modified using the IICS REST API

    <p>True</p> Signup and view all the answers

    Which of the following are benefits of IICS REST API ?

    <p>All of the above</p> Signup and view all the answers

    Fatal exceptions result in the stopping of the session

    <p>True</p> Signup and view all the answers

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

    <p>All of the above</p> Signup and view all the answers

    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

    <p>True</p> Signup and view all the answers

    What types of ELT Optimizations are supported in IICS?

    <p>All of the above</p> Signup and view all the answers

    All connections support Partitioning in IICS

    <p>False</p> Signup and view all the answers

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

    <p>Yes, if done manually</p> Signup and view all the answers

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

    <p>False</p> Signup and view all the answers

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

    <p>All of the above</p> Signup and view all the answers

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

    <p>All of the above</p> Signup and view all the answers

    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.

    <p>True</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

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

    <p>File Ingestion tasks</p> Signup and view all the answers

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

    <p>Event</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

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

    <p>True</p> Signup and view all the answers

    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

    <p>Default and Global</p> Signup and view all the answers

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

    <p>Parameter File</p> Signup and view all the answers

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

    <p>All of the above</p> Signup and view all the answers

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

    <p>All of the above</p> Signup and view all the answers

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

    <p>Visual Model</p> Signup and view all the answers

    Study Notes

    Informatica Cloud (IICS)

    • iPaaS stands for Integration Platform as a Service.
    • IICS is a cloud-based iPaaS solution.

    Data Load Types

    • IICS supports various data load types.

    Flat File Connections

    • 'Record delimiter' is not a Flat File connection property.
    • Field expression syntax is based on database SQL, so it cannot be used on data read from a flat-file source.

    Tasks and Mappings

    • Data in tasks and mappings is normally processed in the Secure Agent.
    • A Synchronization task can be used to delete records, but it does not support the 'Update' operation for a Flat File target.
    • Multiple instances of a Synchronization task cannot be run simultaneously.

    Field Selection Criteria

    • The 'All Fields' field selection criteria include all incoming fields from an upstream transformation.
    • To include all incoming fields from an upstream transformation except those with dates, use a field selection criteria with a filter.

    Mappings and Mapplets

    • A mapping with a single transformation that is not connected to another downstream object is called a Mapplet.
    • A Mapplet is reusable transformation logic.
    • Each Mapplet transformation can contain multiple transformations.
    • A connected Lookup can be called in a :LKP expression.
    • The Cloud Mapping Designer permits a single mapping to have more than one target.
    • Mappings and Synchronization tasks differ in their objectives: mappings focus on data transformation, while Synchronization tasks focus on data movement.

    Use Cases

    • To load Account records to Salesforce from a .csv source file with specific conditions ('BillingState'=NY and 'Annual_Revenue'>10000000), a filter can be used.
    • To determine total sales per region and average deal size per region, an Aggregator transformation should be used.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser