Informatica Cloud - IICS - level 1

Description

Quiz on Informatica Cloud - IICS - level 1, created by Sanjeev Kumar on 06/09/2018.
Sanjeev Kumar
Quiz by Sanjeev Kumar, updated more than 1 year ago
Sanjeev Kumar
Created by Sanjeev Kumar over 5 years ago
4114
2

Resource summary

Question 1

Question
Informatica cloud jobs can be run on :
Answer
  • Only on cloud
  • Only on agent
  • on cloud and on agent

Question 2

Question
Full form if iPaas :
Answer
  • Informatica Platform as a service
  • Integration Platform as a service
  • Intelligent Platform as a service

Question 3

Question
Informatica cloud can do real time integration with Salesforce
Answer
  • True
  • False

Question 4

Question
IICS stands for
Answer
  • Intelligent Integration Cloud Services
  • Intelligent Informatica Cloud Services
  • Informatica Intelligent Cloud Services

Question 5

Question
Informatica Cloud (IICS) have below components
Answer
  • Data Integration
  • Application Integration
  • Monitor
  • Application Integration Console

Question 6

Question
In Application Intregration console we can develop our code by using Process, Service connector, Connection etc
Answer
  • True
  • False

Question 7

Question
Monitor is used for monitoring application integration Jobs
Answer
  • True
  • False

Question 8

Question
We can create below assets in Application Integration
Answer
  • Process
  • Service Connector
  • Mapping
  • Connection

Question 9

Question
We can create below assets in Data Integration
Answer
  • Mapping configuration
  • Data Synchronization
  • Data Replication
  • Guides

Question 10

Question
Connection can be created in :
Answer
  • Application Integration only
  • Administrator only
  • Both in application integration and administrator

Question 11

Question
Picture is representing which data set
Answer
  • XML
  • Json
  • Neither XML nor json

Question 12

Question
Attached image represent :
Answer
  • Mapping
  • Data Synchronization
  • Process
  • Taskflow

Question 13

Question
Transformation like expression, aggregator, filter, router are a part of :
Answer
  • Data Replication
  • Mapping
  • Data Synchronization
  • Taskflow

Question 14

Question
Which one of the below statement is correct
Answer
  • Taskflow can be scheduled via scheduler
  • Process can also be schedule from application integration console
  • Minimum interval for a Scheduler available in administrator is 2 min

Question 15

Question
Which of the below statement is incorrect
Answer
  • Multiple mapping can be called/wrapped in single Mapping configuration task
  • Data synchronization task can be also called in taskflow
  • Mapping can be called in taskflow
  • Multiple Mapping configuration task can use same mapping

Question 16

Question
Which of the following is not a task
Answer
  • Maaping configuration
  • Data Synchronization
  • Mapplet
  • Data Replication

Question 17

Question
Nulls are allowed in Primary Key
Answer
  • True
  • False

Question 18

Question
Foreign Key can have duplicate values
Answer
  • True
  • False

Question 19

Question
Delete * from <table name> . Is this the correct statement
Answer
  • True
  • False

Question 20

Question
Below Services are used to keep track of jobs/processes executed
Answer
  • Application Integration
  • Application Integration Console
  • Data Integration
  • Monitor

Question 21

Question
Which Transformation it is ?
Answer
  • Aggreegator
  • Sorter
  • Joiner
  • Router

Question 22

Question
Under which services you can schedule Data Integration Jobs
Answer
  • Monitor
  • Data Integration
  • Administrator

Question 23

Question
Screenshot depicts _________________________________________________
Answer
  • Taskflow
  • Process
  • Mapping
  • Data Replication task

Question 24

Question
A table has data which store the marks of a student. Which kind of table it is
Answer
  • Fact
  • Dimension

Question 25

Question
OLAP stands for
Answer
  • On Line Analytical Program
  • On Line Analytical Processing
  • On Line Analytical Process
  • On Line Analytical publsihing

Question 26

Question
Which Transformation ?
Answer
  • Aggregator
  • Normalizer
  • Hierarchy Parser
  • Hierarchy builder

Question 27

Question
Scenario: Source is a Flat file which has duplicate records. We need to populate distinct records into the target. Which Transformation can be used to achieve it
Answer
  • Aggregator
  • Expresession
  • Router
  • Sorter

Question 28

Question
Which type of slowly changing dimension it is
Answer
  • SCD Type 1
  • SCD Type 2
  • SCD Type 3
  • SCD Type 6

Question 29

Question
Which out of below are falls under category of an iPaas tool
Answer
  • Dell Boomi
  • Talend
  • Mulesoft
  • Informatica cloud

Question 30

Question
A Data Warehousing (DW) is process for collecting and managing data from varied sources to provide meaningful business insights
Answer
  • True
  • False
Show full summary Hide full summary

Similar

Informatica Cloud
Victoria Jones
Test Sample
Org work
Physics II
Org work
Formula for Physics IGCSE edexcel
amayagn
Circle Theorems
I Turner
Exchange surfaces and breathing
megan.radcliffe16
Cell Organelles and Functions
Melinda Colby
Poetry revision quiz
Sarah Holmes
Conocimiento General de Aeronaves
Adriana Forero
2PR101 1.test - 8. část
Nikola Truong
TISSUE TYPES
Missi Shoup