Copy and Edit

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 6 years ago
4310
2
0

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
Image:
Picture1 (binary/octet-stream)
Answer
  • XML
  • Json
  • Neither XML nor json

Question 12

Question
Attached image represent :
Image:
Image (binary/octet-stream)
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 ?
Image:
Image 1 (binary/octet-stream)
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 _________________________________________________
Image:
Image 2 (binary/octet-stream)
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 ?
Image:
Image 3 (binary/octet-stream)
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
Image:
Image 4 (binary/octet-stream)
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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Informatica Cloud
Victoria Jones
Test Sample
Org work
Physics II
Org work
I'm the king of the castle
archita.kmr
Computer Hardware
cscutt
Malware Quiz
khibbitt
Blues, Beats & More! Quiz
Mike'd
An Inspector Calls -- Themes
Sadia Aktar
Peace and Conflict Flashcards - Edexcel GCSE Religious Studies Unit 8
nicolalennon12
PE - GCSE Glossary
rjapmann
PHR and SPHR Practice Questions
Elizabeth Rogers8284
Browse Library