Question 1
Question
Informatica Cloud allows business users to integrate data across both cloud-based applications and on-premise applications and databases.*
Question 2
Question
Which Informatica Cloud application is best to use for performing regular backups of data?
Answer
-
Data Synchronization
-
Mapping Configuration
-
Data Replication
Question 3
Question
Views marked as private can be accessed by your user and admin users only.
Question 4
Question
Where does the data get processed?*
Answer
-
In the Informatica Cloud Repository
-
In the Informatica Cloud Secure Agent (behind customer firewall)
-
In the Informatica Cloud servers
Question 5
Question
Which of the following are stored in the Informatica Cloud (IC) Repository?
Question 6
Question
Where do you enter proxy server settings?
Question 7
Question
How does the Secure Agent communicate with Informatica Cloud?*
Answer
-
There is no communication between the secure agent and Informatica Cloud
-
All communication is outbound through HTTPS protocol (port 443)
-
Communication is initiated over telnet
Question 8
Question
Which of the following lists includes three types of Native connectors?
Answer
-
Salesforce, FTP/SFTP, Netsuite
-
MS Dynamics CRM, Amazon Redshift, Zuora
-
Flat File, SAP, Web Service
Question 9
Question
What information is required in order to access Salesforce via their API? (select best answer)
Question 10
Question
A Flat File connection points to a single folder/directory.
Question 11
Question
Which operation would be best to use when synchronizing data between two systems?*
Question 12
Question
Where can you find Informatica Cloud log files?* (Select 2)
Answer
-
On the agent machine, in the Secure Agent installation directory, under
-
Error rows preview and job log file can be accessed from the activity log and job details pages in Informatica Cloud
-
By logging into the IC Repository
Question 13
Question
When using the Delete operation in a task with a Salesforce target, you should use which of the following?
Answer
-
Salesforce ID
-
Foreign Key
-
External ID
Question 14
Question
A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud.
Question 15
Question
You want to load account records from a SQL Server source where 'BillingState' = NY AND 'Annual Revenue' >= 10000000. Should you use a simple or advanced filter to do this?*
Question 16
Question
Filtering on Informatica Cloud system variables $LastRunDate or $LastRunTime is referred to as which of the following?
Answer
-
Date-Based Filtering
-
Incremental Processing
-
Pre-Processing Command
Question 17
Question
Which of the following could you use a field expression to do? (select all that apply)*
Answer
-
Insert a value into a target field for all records
-
Convert date to the correct format for target field
-
Mapping multiple source fields to a single target
-
Trimming blank spaces from a source field
Question 18
Question
Data from multiple source Connections can be combined using multiple object source.
Question 19
Question
Muliple object source type can be used with the following:
Answer
-
Flat files
-
Database tables
-
Salesforce objects
Question 20
Question
Saved Queries can be used to perform which of the following? * (select 2)
Question 21
Question
Which of the following is/are best practices for using Saved Queries?
Question 22
Question
You have a child object, for example, a contact that belongs to an Account in Salesforce but youI don't have the external id to match it up to. You do have the account name on the incoming contact record so you can match that up to the account name on the account record in Salesforce. What do you need to do in the Data Synchronization Wizard to match those values together? *
Answer
-
On Step 5 of the Data Synchronization Wizard, use the Related Objects Button to point to the related field in the parent object and then use lookup function to match the records and return the Salesforce Id field.
-
On Step 4 of the Data Synchronization Wizard, use the Related Objects Button to point to the related field in the parent object and then use the lookup function to match the records and return the Salesforce Id field.
-
On Step 5 of the Data Synchronization Wizard use the lookup function to match the records and return the Salesforce Id field.
Question 23
Question
You have a data synchronization task that is performing a lookup on the Salesforce account object to return the Salesforce Id and match contacts to their correct account records, but that task is running really slowly. Why might that be and what can you do to speed up the task?*
Answer
-
Run the task off hours so that performance is not impacted by normal intraday processing.
-
Informatica Cloud uses one API call per lookup which is expensive and slows the process down. Create smaller source files and run more frequent jobs to increase performance.
-
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.
Question 24
Question
Data replication tasks can be used for: (select 2)
Question 25
Question
Incremental Processing is built into Data Replication for all source types.*
Question 26
Question
Which of the following is NOT a function available from the Data Replication tasks page?
Answer
-
Create Target
-
Download Mapping XML
-
Reset Target
Question 27
Question
What is the smallest increment of time allowed for creating a schedule in Informatica Cloud to run jobs automatically?
Answer
-
1 minute
-
5 minutes
-
10 minutes
Question 28
Question
Name the Informatica Cloud feature used to sequentially run tasks in a specified order.*
Answer
-
Task Flows
-
Templates
-
Work Flows
Question 29
Question
Which of the following can be used to write to multiple targets?*
Answer
-
Mapplets
-
Mappings
-
Connections
Question 30
Question
It is recommended that you follow the Velocity Methodology to name the elements of a mapping.
Question 31
Question
Active transformations do not change the number of rows that pass to the next step of the mapping.*
Question 32
Question
It is recommended that the Mapping Designer be used with which browser?
Answer
-
IE version 8
-
Firefox
-
Chrome
Question 33
Question
It is best practice to handle naming conflicts in a mapping as close to the target as possible.
Question 34
Question
To include all incoming fields from an upstream transformation except those with dates, what should you do?
Answer
-
Delete all of the date fields from the source.
-
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.
-
Configure a simple filter condition to exclude fields with data type of Date/Time.
Question 35
Question
Which transformation type would you use to create a new field, performing non-aggregate calculations?
Question 36
Question
Mapping Configuration Tasks allow you to process data based on the data flow logic defined in: (select 2)
Answer
-
Integration Templates
-
Mappings
-
Mapplets
Question 37
Question
When adding parameters to a mapping, it is a good idea to add them:
Answer
-
In the mapping configuration task.
-
After the mapping has been configured and tested with specified objects or filters, then parameters can be added to replace those objects or filters
-
During the initial configuration of the mapping.
Question 38
Question
After changes have been made to a mapping that is being used by one or more mapping configuration tasks, you can deploy these changes using which of the following: (select 2)
Answer
-
Import the new mapping from PowerCenter.
-
Save and deploy to mapping configuration tasks.
-
Save updates as a new mapping (retaining the previous version of the mapping).
Question 39
Question
Where are parameter files located that are used by the Data Synchronization Wizard?
Answer
-
On the Informatica Secure Agent machine under the userparameters directory
-
The parameters are passed in by the developer at run time
-
On the Informatica Cloud under the Configuration tab
Question 40
Question
Which of the following is a supported pre- or post-processing commands? (select 3)
Answer
-
SQL Command
-
Unix Command
-
Valid DOS or batch file
Question 41
Question
If pre- or post-processing command(s) fails, your task will complete successfully.
Question 42
Question
Which method is used to achieve real time integration when Salesforce is the integration source?
Question 43
Question
Which of the following explains why you might want to change the Salesforce target batch size? (select 2)
Answer
-
You are using APEX triggers which require that you load one record at a time to function properly.
-
You want to avoid writing duplicate data from your source.
-
You are loading a million or more rows of data from your source.
Question 44
Question
Salesforce Bulk API jobs run in parallel mode (batches are written to the target at the same time) by default.
Question 45
Question
The Data Masking application masks the sensitive columns in source data with realistic test data for non-production environments.
Question 46
Question
Data Masking can be used in which of the following scenarios? (select 2)
Answer
-
SQL Server source data loaded and masked into Salesforce target
-
Oracle data masked in place
-
Salesforce source data loaded and masked into separate Salesforce target
Question 47
Question
Which of the following masking rules use a set of dictionary files located in the agent installation directory?
Answer
-
Substitution Masking
-
Key Masking
-
Random Masking
Question 48
Question
Which of the following might be a reason your company would use the Contact Validation App in Informatica Cloud? (select 3)
Answer
-
Your company sends direct mail marketing pieces.
-
Your company purchases lead lists from tradeshows.
-
Your company uses the Territory Management feature in Salesforce.
Question 49
Question
Running a Contact Validation task will update a source database with corrected/normalized data based on parameters you specify in the task.
Question 50
Question
If you want to validate shipping and billing address fields, what is the best method for setting up the Contact Validation task?
Answer
-
Map the shipping and billing address fields separately.
-
Check the multiple source object option.
-
Create two Contact Validation tasks - one for each set of address fields.
Question 51
Question
Informatica Cloud users must be assigned which of the following?
Answer
-
Permission
-
User Group
-
Role
Question 52
Question
Configuring object-level permissions allows you to restrict or expand the permissions the user group has for the object.
Question 53
Question
Which of the following objects cannot be migrated from one Informatica Cloud org to another?
Answer
-
Mappings
-
Connections
-
Schedules
Question 54
Question
Most Organization have either On-Premise OR Cloud Applications
Question 55
Question
What Does Hybrid Infrastructure mean?
Answer
-
Business Users have to Use Excel and Access to do Analytics
-
None of the Above
-
Companies having JAVA , .NET or PL/SQL to accomplish Data Integration needs in their organizations
-
Companies have On-Premise Data Sources and SaaS Applications that require integration
Question 56
Question
Which one of the following is NOT a Informatica Product
Question 57
Question
What does Cloud Connector Toolkit allows you to do?
Answer
-
Toolkit allows you to give you training to your business users
-
It provides Data out of your ERP Systems
-
JAVA Framework to create standardized integrations to your SaaS Applications
-
it allows Integration between Powercenter and ICS
Question 58
Question
What are the Three Ways you extend Informatica PaaS to achieve Rpid Development, Configuration and Consumption?
Answer
-
Powercenter, Data Quality and Cloud MDM
-
Create a Java Framework and Create standardized Flat Files
-
Cloud ICC, Cloud Integration Templates and Cloud Connector ToolKit
-
Developer, ILM & Test Data Management
Question 59
Question
A mapping defines reusable data flow logic that you can use in mapping configuration tasks.
Question 60
Question
Following types of Macros could be created using Cloud Mapping Designer
Answer
-
Parallel
-
Hybrid
-
Vertical
-
Horizontal
Question 61
Question
To create categories for employees based on salary ranges, you might create a macro that defines the minimum and maximum values for each range and corresponding job categories.This is an example of
Answer
-
Vertical Macro
-
Horizontal Macro
-
Hybrid Macro
Question 62
Question
The Normalizer transformation is an passive transformation that transforms one incoming row into multiple output rows. When the Normalizer transformation receives a row that contains multiple-occurring data, it returns a row for each instance of the multiple-occurring data.
Question 63
Question
You can use the following field mapping options on the Normalizer Field Mapping tab.
Answer
-
Show Fields
-
Show Lines
-
Automatch
-
Action menu
-
All of these
Question 64
Question
The Mapping Configuration application generates the following fields for normalized data.
Answer
-
Generated Key
-
Generated Row Id
-
Generated Column ID
Question 65
Question
Which of the following statements are true about the Data Masking transformation. Select all that apply. (Select 4)
Answer
-
Create masked data for software development, testing, training, and data mining
-
The Data Masking transformation provides masking rules based on the source datatype and masking type you configure for a port
-
You cannot maintain data relationships in the masked data and maintain referential integrity between database tables
-
Masking transformation modifies source data based on masking rules that you configure for each column
-
Use the Data Masking transformation to change sensitive production data to realistic test data for non- production environments
Question 66
Question
The Data Masking transformation is a passive transformation.
Question 67
Question
Which of the following Masking Techniques are available with the Data Masking Transformation. Select all that apply. (Select 4)
Answer
-
Encryption masking
-
Substitution masking
-
Key masking
-
Random masking
-
IP Address masking
Question 68
Question
________________produces deterministic results for the same source data and seed value. (select one)
Answer
-
Random masking
-
Substitution masking
-
None of the Above
-
All of the above
-
Key masking
Question 69
Question
Which of the following statements are true? Select all that apply. (select 3)
Answer
-
The Mapping Configuration application processes SOAP messages with document/literal encoding.
-
The Web service request/response messages in the transformation are in JSON format
-
Web Service operations include requests for information, requests to update data and requests to perform tasks.
-
WSDL is the is an XML file that describes the operations of a Web Service
Question 70
Question
One of the following options that correctly describes, sequence of steps involved to create a Web Services transformation in a mapping is:
Answer
-
Define a Business Service, Create a Web Services Consumer connection, Configure the Web ServicesTransformation in the mapping
-
Create a Web Services V2 connection, Define a Business Service, Configure the Web Services Transformation in the mapping.
-
Create a Web Services Consumer connection, Define a Business Service, Configure the Web ServicesTransformation in the mapping.
-
Define a Business Service, Create a Web Services V2 connection, Configure the Web ServicesTransformation in the mapping
Question 71
Question
A web service integrates applications and uses open standards, such as SOAP, WSDL, and XML.
Question 72
Question
What does WSDL stand for?
Answer
-
Web Services Description Language
-
Web Services Definition language
-
Web Services Delegation Language
-
Web Services Derivation Language
Question 73
Question
_________ is the communications protocol for Web Services in the Web Service Transformation.
Question 74
Question
What of these objects can be found in a bundle? Select all that apply.
Answer
-
Connectors
-
Mapplets
-
Integration Templates
-
Mappings
Question 75
Question
By default, every Org has the ability to author and publish a bundle?
Question 76
Question
Bundles are versioned?
Question 77
Question
Bundles can be managed by the following groups / individuals. Select all that apply. (select 4)
Answer
-
Service Integrators
-
User Community
-
OEM's
-
Informatica
Question 78
Question
Bundles are automatically upgraded when a newer version is available, users have no control?
Question 79
Question
ReST is an abstraction of the architecture of the World Wide Web; more precisely, ReST is an alternative to SOAP style web-services.ReST stands for
Question 80
Question
The different types of parameters that a ReST API may need to process the incoming request are:
Question 81
Question
What does SOAP Stand for?
Answer
-
Standard object Access Protocol
-
Simple object Access Protocol
-
System object Access Protocol
Question 82
Question
What message format Does SOAP use?
Question 83
Question
What Type of Connector needs to be configured to connect to a WebService?
Answer
-
WebServices
-
WebServices V2
-
XMLTarget
Question 84
Question
What Task needs to be created in Informatica Cloud Services to integrate with a Web Service?
Question 85
Question
When Creating the Web Services connector it is crucial to test the connector whilst the “Auto csv File Creation” option is set to “Auto creation”?
Question 86
Question
What does the Object source drop down represent when a Web Service connector is selected?
Question 87
Question
It is impossible to create a Data Filter for Web Service Source objects in Informatica Cloud Services?
Question 88
Question
How can a Batch Integration job be invoked? Select all that apply.
Answer
-
CDC
-
User Initiated
-
On-Demand
-
Pre-defined Schedule
Question 89
Question
Informatica Cloud requires a SalesForce object to be designated as replicatable in order to setup CDC on it.
Question 90
Question
CDC can be enabled for a DSS task.
Question 91
Question
The advanced properties "Use queryAll" and "Enable Bulk Query" can be used together.
Question 92
Question
What does a CDC Time Limit of -1 indicate?
Question 93
Question
Using Informatica Cloud ReST API,you can perform tasks such as:
Answer
-
create, update, and delete connections
-
create, update, and delete schedules
-
start and monitor tasks and task flows
-
verify the Salesforce API version
-
All of the above
Question 94
Question
What resources are provided by the REST API?
Answer
-
login
-
job
-
cloud real time
-
mapping
-
connection
Question 95
Question
The utilities available to access Informatica Cloud ReST API, are :
Select one or more:
Answer
-
popular ReST Clients such as POSTMAN , ADVANCE ReST Client
-
Informatica Cloud Utility available at MarketPlace
-
cURL
-
Power Center
Question 96
Question
What is Informatica Process Developer?
Answer
-
Informatica's Methodolgy for Developer to follow a Best Practice(Process)
-
Eclipse Based tool to developer BPEL Processes for Informatica Cloud
-
Create a Process in Informatica Cloud to be invoked by SFDC
-
Developer Resource required to create Real-Time Orchestration
Question 97
Question
Web Services Definition language is required for a BPEL Process
Question 98
Question
What is Required for WSDL Creation?
Answer
-
Create a Participant and Have XML Schema attached to it
-
Create a Participant(Consumer or Provider)
-
Flat File with Header Records for Input/output
-
Only know the Type of WSDL (Synchronous or Asynchronous)
Question 99
Question
What is expression Editor?
Answer
-
Regex Expression Builder
-
Ways to Bind values to Output Variable Responses
-
Allows you to write Powercenter Expression Functions
-
Constructs data using WS-BPEL and other extension Functions
Question 100
Question
What is the Sequence for Deploying BPEL Process to Cloud?
Answer
-
Export Eclipse Workspace Project to BPR and Deploy that to Admin Console
-
Import Business Process Archive , Create a Process Deployment Descriptor and Import it in Process Developer
-
Create a valid BPEL Process, Create PDD, Create BPR
-
None of the Above
Question 101
Question
Contribution ins a deployed Business Process archive manged on the server as a unit of files
Question 102
Question
Version is achieved using contribution
Question 103
Question
Contribution have the Following States:
Answer
-
offline pending
-
offline
-
Deleted
-
online
Question 104
Question
It's always best to Create a .bpr for each BPEL/WSDL in your Orchestration Project
Question 105
Question
Once you create and deploy a process using Real Time, how can that process be invoked?
Answer
-
As a JSON service
-
Using the Informatica Cloud API.
-
By running an Informatica Cloud task.
-
As a REST/XML or JSON service
Question 106
Question
Real Time Guides allow business users to create and deploy custom process applications.
Question 107
Question
Which of the following is not true regarding Real Time Guides?
Answer
-
Can be built by non-technical business users
-
Require an on-premise Informatica Agent to run
-
Automate processes and methodologies
-
Can retrieve data from/write data to Salsforce or other applications
Question 108
Question
Which is not a feature of the Real Time for Salesforce managed package?
Answer
-
Provides built-in support for reading data from/writing data to Salesforce objects.
-
Allows you to access all of the same features as Service & Process Designer.
-
Includes support for running guides on the Salesforce1 mobile platform.
-
Includes service and process monitoring within Salesforce.
-
Includes Visualforce Pages for displaying guides within the Salesforce UI.
Question 109
Question
How are Real Time guides displayed on Salesforce pages?
Answer
-
A custom button must be created.
-
A Visualforce page must be added to the page layout.
-
The user viewing the page must be a System Administrator.
Question 110
Question
The Managed package cannot be installed in a Sandbox environment.
Question 111
Question
What does the Guide “Applies To” property control?
Answer
-
Which Salesforce users can access the guide
-
The subcategory the guide will be displayed under in the Guides list
-
Whether or not the guide can be accessed from the Service & Process Designer
-
Which object the guide will operate on and have access to.
Question 112
Question
Steps are used to guide a user through a process.
Question 113
Question
What is the primary purpose of a screen step?
Answer
-
Display instructions and allow a user to enter data
-
Display a list of records to a user.
-
Include HTML formatting and images in the guide.
-
Ask the user a question.
Question 114
Question
What is the purpose of end of guide outcomes?
Answer
-
Allow you to track guide results for reporting purposes.
-
Allow you to provide options to guide users.
-
To display different results, depending on guide path taken.
-
Help you control the possible outcomes for users.
Question 115
Question
A user cannot access a guide unless it has been published.
Question 116
Question
The primary purpose of a Create step is
Answer
-
To create a new record of any type
-
To create a new user
-
To create a guide log event
-
To create a new guide outcome
Question 117
Question
If you select “Screen” as the value of an input field, where does the value come from when the guide runs?
Answer
-
The value is entered by the guide user
-
The value is determined by a formula.
-
The value is hard-coded and remains the same each time the guide is run.
-
The value is determined by the value of the selected field.
Question 118
Question
An assignment step cannot be used to set the value of fields on a related object.
Question 119
Question
A service call step can perform a task automatically. Tasks that can be performed include:
Answer
-
Tasks defined in the Salesforce System Administrator.
-
Sending an Email, Converting a Lead, and Submitting a Record for Approval.
-
Tasks available in Salesforce only.
-
Tasks available in Integrated Services and Applications, and tasks defined in service connections (created in Service and Process Designer).
Question 120
Question
A Service Call Step must have a screen step.
Question 121
Question
Only a single step can jump to the same target step
Question 122
Question
What is the benefit of using a Jump step ?
Answer
-
Allows a guide user more flexibility.
-
Avoids duplication of the same set of steps.
-
Allows the guide to automatically start a background process
Question 123
Question
Which statements are true regarding Data Decision steps?
Answer
-
Allows a guide to take different paths depending on the value of a field
-
The order of the branches is not important
-
Tests for a condition
-
Each condition has a branch
Question 124
Question
Which are advantages of using an embedded guide?
Answer
-
Allow you to have multiple versions of the same guide
-
Allow you to repeat steps on multiple records
-
Allow you to avoid creating the same set of steps
-
Allow you to make changes in one place
Question 125
Question
An embedded guide must be published before it is run.
Question 126
Question
How are values passed between the embedding and embedded guides?
Answer
-
Through the use of temporary fields in the embedded guide step.
-
Via the definition of global variables
-
Through the use of Guide-level fields
Question 127
Question
You are designing a guide that will embed another guide. That embedded guide will return information that you’ll need to use downstream in your guide. What type of guide field should you define for this?
Question 128
Question
When displaying a list of records in an embedded guide step or screen step, how do you define which fields (columns) will display?
Answer
-
Edit the Guide properties and select the fields
-
You cannot control which fields display in a list of records
-
Edit the field properties and select the Display Fields
Question 129
Question
How can you selectively display a guide – based on a Salesforce user’s role, for example?
Answer
-
Define different page layouts for different user roles
-
Edit the Guide’s Applies To property
-
In the Guide’s Advanced properties, define a Boolean expression
-
In the Guide’s Advanced properties, list the user roles who can access the guide
Question 130
Question
How can you display a single guide when a user clicks a button or link?
Answer
-
Create a Visualforce page for the guide
-
Create a custom page layout for the guide
-
Edit the Guide Properties and select the button or link
-
Edit the Record Detail page layout for the guide’s Applies To object
Question 131
Question
How can guides be accessed in the Salesforce1 mobile app?
Question 132
Question
When would you run a process on a local agent (versus Cloud agent):
Answer
-
If the process will connect to more than one application or service.
-
If the process includes input and output fields.
-
If the process needs to access an on-premise resource that resides behind a firewall.
Question 133
Question
A process can be invoked from the following (check all that apply):
Question 134
Question
Which of the following are true about the Parallel Path step do (check all that apply)?
Answer
-
Each path waits for a result, then the next branch is executed.
-
It executes multiple branches at the same time.
-
It is unique to processes (not available in guides).
-
A jump step can only jump to a step in the same branch.
Question 135
Question
A process call step cannot have an input screen.
Question 136
Question
Select the best definition of a service connector.
Answer
-
An object that holds the details for connecting to an application or service – including username and password.
-
An object that defines the interaction between a Process Designer and a service – how the service will send and receive data.
-
An out-of-the-box connector that can be leveraged using Real Time.
Question 137
Question
Which of the following are available out of the box service connectors (select all that apply):
Answer
-
Salesforce
-
Big Machines
-
JDBC
-
Netsuite
-
SAP
Question 138
Question
A Service Connector can define multiple actions.
Question 139
Question
How does a service connector parse data returned from a service and place it in variables (select all that apply)?
Answer
-
Output values must be automatically generated using the XML response.
-
Data can be extracted using xQuery.
-
Data can be mapped directly to an output field using XML tag names or JSON properties.
Question 140
Question
Before you can use a Service Connector in a process or guide, you must (select all that apply):
Answer
-
Publish the service connector.
-
Register the service connector using the Process Console.
-
Create a connection using the Service Connector.
Question 141
Question
What does a connection do?
Answer
-
Defines a connection to a data source.
-
Stores a username and password for Salesforce.
-
Determines if you are licensed for a specific service or application.
Question 142
Question
If you are using the JDBC connection, which step would you use in a process or guide to create a new record in a database?
Answer
-
Process Call
-
Creat
-
Service Call
-
Assignment
Question 143
Question
Which of the following things can you determine using Process Console (select all that apply)?
Answer
-
Which path a process took.
-
The user who initiated the process
-
The start/end date/time for the process
-
A list of inputs/outputs