Informatica Cloud allows business users to integrate data across both cloud-based applications and on-premise applications and databases.*
Which Informatica Cloud application is best to use for performing regular backups of data?
Data Synchronization
Mapping Configuration
Data Replication
Views marked as private can be accessed by your user and admin users only.
Where does the data get processed?*
In the Informatica Cloud Repository
In the Informatica Cloud Secure Agent (behind customer firewall)
In the Informatica Cloud servers
Which of the following are stored in the Informatica Cloud (IC) Repository?
Source and Target Metadata
Schedules
Saved Queries
Where do you enter proxy server settings?
Informatica Cloud Agent Console
Organization settings page
Agent Log File
How does the Secure Agent communicate with Informatica Cloud?*
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
Which of the following lists includes three types of Native connectors?
Salesforce, FTP/SFTP, Netsuite
MS Dynamics CRM, Amazon Redshift, Zuora
Flat File, SAP, Web Service
What information is required in order to access Salesforce via their API? (select best answer)
Trusted IP Range
Security Token
Either Security Token or Trusted IP Range
A Flat File connection points to a single folder/directory.
Which operation would be best to use when synchronizing data between two systems?*
Insert
Upsert
Update
Where can you find Informatica Cloud log files?* (Select 2)
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
When using the Delete operation in a task with a Salesforce target, you should use which of the following?
Salesforce ID
Foreign Key
External ID
A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud.
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?*
Advanced
Simple
Filtering on Informatica Cloud system variables $LastRunDate or $LastRunTime is referred to as which of the following?
Date-Based Filtering
Incremental Processing
Pre-Processing Command
Which of the following could you use a field expression to do? (select all that apply)*
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
Data from multiple source Connections can be combined using multiple object source.
Muliple object source type can be used with the following:
Flat files
Database tables
Salesforce objects
Saved Queries can be used to perform which of the following? * (select 2)
Limit or qualify the data that is being pulled from a source
Complicated join of multiple tables
Aggregations in SQL
Which of the following is/are best practices for using Saved Queries?
Use the SQL COUNT function
Use a SELECT statement
Do not use conversion functions (like TO_CHAR, etc)
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? *
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.
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?*
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.
Data replication tasks can be used for: (select 2)
Data back-up
Synchronizing data between systems
Offline Reporting
Incremental Processing is built into Data Replication for all source types.*
Which of the following is NOT a function available from the Data Replication tasks page?
Create Target
Download Mapping XML
Reset Target
What is the smallest increment of time allowed for creating a schedule in Informatica Cloud to run jobs automatically?
1 minute
5 minutes
10 minutes
Name the Informatica Cloud feature used to sequentially run tasks in a specified order.*
Task Flows
Templates
Work Flows
Which of the following can be used to write to multiple targets?*
Mapplets
Mappings
Connections
It is recommended that you follow the Velocity Methodology to name the elements of a mapping.
Active transformations do not change the number of rows that pass to the next step of the mapping.*
It is recommended that the Mapping Designer be used with which browser?
IE version 8
Firefox
Chrome
It is best practice to handle naming conflicts in a mapping as close to the target as possible.
To include all incoming fields from an upstream transformation except those with dates, what should you do?
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.
Which transformation type would you use to create a new field, performing non-aggregate calculations?
Joiner
Filter
Expression
Mapping Configuration Tasks allow you to process data based on the data flow logic defined in: (select 2)
Integration Templates
When adding parameters to a mapping, it is a good idea to add them:
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.
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)
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).
Where are parameter files located that are used by the Data Synchronization Wizard?
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
Which of the following is a supported pre- or post-processing commands? (select 3)
SQL Command
Unix Command
Valid DOS or batch file
If pre- or post-processing command(s) fails, your task will complete successfully.
Which method is used to achieve real time integration when Salesforce is the integration source?
Salesforce Trigger
Salesforce Outbound Messaging
Third Party Scheduler
Which of the following explains why you might want to change the Salesforce target batch size? (select 2)
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.
Salesforce Bulk API jobs run in parallel mode (batches are written to the target at the same time) by default.
The Data Masking application masks the sensitive columns in source data with realistic test data for non-production environments.
Data Masking can be used in which of the following scenarios? (select 2)
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
Which of the following masking rules use a set of dictionary files located in the agent installation directory?
Substitution Masking
Key Masking
Random Masking
Which of the following might be a reason your company would use the Contact Validation App in Informatica Cloud? (select 3)
Your company sends direct mail marketing pieces.
Your company purchases lead lists from tradeshows.
Your company uses the Territory Management feature in Salesforce.
Running a Contact Validation task will update a source database with corrected/normalized data based on parameters you specify in the task.
If you want to validate shipping and billing address fields, what is the best method for setting up the Contact Validation task?
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.
Informatica Cloud users must be assigned which of the following?
Permission
User Group
Role
Configuring object-level permissions allows you to restrict or expand the permissions the user group has for the object.
Which of the following objects cannot be migrated from one Informatica Cloud org to another?
Most Organization have either On-Premise OR Cloud Applications
What Does Hybrid Infrastructure mean?
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
Which one of the following is NOT a Informatica Product
Data Quality
Test Data Management Suite
ERP Integrator
Contact Validation Service
B2B
What does Cloud Connector Toolkit allows you to do?
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
What are the Three Ways you extend Informatica PaaS to achieve Rpid Development, Configuration and Consumption?
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
A mapping defines reusable data flow logic that you can use in mapping configuration tasks.
Following types of Macros could be created using Cloud Mapping Designer
Parallel
Hybrid
Vertical
Horizontal
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
Vertical Macro
Horizontal Macro
Hybrid Macro
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.
You can use the following field mapping options on the Normalizer Field Mapping tab.
Show Fields
Show Lines
Automatch
Action menu
All of these
The Mapping Configuration application generates the following fields for normalized data.
Generated Key
Generated Row Id
Generated Column ID
Which of the following statements are true about the Data Masking transformation. Select all that apply. (Select 4)
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
The Data Masking transformation is a passive transformation.
Which of the following Masking Techniques are available with the Data Masking Transformation. Select all that apply. (Select 4)
Encryption masking
Substitution masking
Key masking
Random masking
IP Address masking
________________produces deterministic results for the same source data and seed value. (select one)
All of the above
Which of the following statements are true? Select all that apply. (select 3)
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
One of the following options that correctly describes, sequence of steps involved to create a Web Services transformation in a mapping is:
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
A web service integrates applications and uses open standards, such as SOAP, WSDL, and XML.
What does WSDL stand for?
Web Services Description Language
Web Services Definition language
Web Services Delegation Language
Web Services Derivation Language
_________ is the communications protocol for Web Services in the Web Service Transformation.
UDDI
SOAP
JSON
WSDL
What of these objects can be found in a bundle? Select all that apply.
Connectors
By default, every Org has the ability to author and publish a bundle?
Bundles are versioned?
Bundles can be managed by the following groups / individuals. Select all that apply. (select 4)
Service Integrators
User Community
OEM's
Informatica
Bundles are automatically upgraded when a newer version is available, users have no control?
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
Representational State Transfer
ReStructuredText
Real-time Embedded Systems Testbed
The different types of parameters that a ReST API may need to process the incoming request are:
Url Request Parameters
Form Request Parameters
Header Request Parameters
One or more of above
What does SOAP Stand for?
Standard object Access Protocol
Simple object Access Protocol
System object Access Protocol
What message format Does SOAP use?
CSV
XML
HTML
What Type of Connector needs to be configured to connect to a WebService?
WebServices
WebServices V2
XMLTarget
What Task needs to be created in Informatica Cloud Services to integrate with a Web Service?
Power Center Task
Data Replication Task
Data Synchronization Task
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”?
What does the Object source drop down represent when a Web Service connector is selected?
Available XML Documents
Other optional Web Services
Web Services Methods
It is impossible to create a Data Filter for Web Service Source objects in Informatica Cloud Services?
How can a Batch Integration job be invoked? Select all that apply.
CDC
User Initiated
On-Demand
Pre-defined Schedule
Informatica Cloud requires a SalesForce object to be designated as replicatable in order to setup CDC on it.
CDC can be enabled for a DSS task.
The advanced properties "Use queryAll" and "Enable Bulk Query" can be used together.
What does a CDC Time Limit of -1 indicate?
Does nothing.
The task run indefinitely.
Reads all source data and stops.
Using Informatica Cloud ReST API,you can perform tasks such as:
create, update, and delete connections
create, update, and delete schedules
start and monitor tasks and task flows
verify the Salesforce API version
What resources are provided by the REST API?
login
job
cloud real time
mapping
connection
The utilities available to access Informatica Cloud ReST API, are : Select one or more:
popular ReST Clients such as POSTMAN , ADVANCE ReST Client
Informatica Cloud Utility available at MarketPlace
cURL
Power Center
What is Informatica Process Developer?
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
Web Services Definition language is required for a BPEL Process
What is Required for WSDL Creation?
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)
What is expression Editor?
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
What is the Sequence for Deploying BPEL Process to Cloud?
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
Contribution ins a deployed Business Process archive manged on the server as a unit of files
Version is achieved using contribution
Contribution have the Following States:
offline pending
offline
Deleted
online
It's always best to Create a .bpr for each BPEL/WSDL in your Orchestration Project
Once you create and deploy a process using Real Time, how can that process be invoked?
As a JSON service
Using the Informatica Cloud API.
By running an Informatica Cloud task.
As a REST/XML or JSON service
Real Time Guides allow business users to create and deploy custom process applications.
Which of the following is not true regarding Real Time Guides?
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
Which is not a feature of the Real Time for Salesforce managed package?
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.
How are Real Time guides displayed on Salesforce pages?
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.
The Managed package cannot be installed in a Sandbox environment.
What does the Guide “Applies To” property control?
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.
Steps are used to guide a user through a process.
What is the primary purpose of a screen step?
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.
What is the purpose of end of guide outcomes?
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.
A user cannot access a guide unless it has been published.
The primary purpose of a Create step is
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
If you select “Screen” as the value of an input field, where does the value come from when the guide runs?
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.
An assignment step cannot be used to set the value of fields on a related object.
A service call step can perform a task automatically. Tasks that can be performed include:
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).
A Service Call Step must have a screen step.
Only a single step can jump to the same target step
What is the benefit of using a Jump step ?
Allows a guide user more flexibility.
Avoids duplication of the same set of steps.
Allows the guide to automatically start a background process
Which statements are true regarding Data Decision steps?
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
Which are advantages of using an embedded guide?
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
An embedded guide must be published before it is run.
How are values passed between the embedding and embedded guides?
Through the use of temporary fields in the embedded guide step.
Via the definition of global variables
Through the use of Guide-level fields
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?
Output
Temporary
Input
When displaying a list of records in an embedded guide step or screen step, how do you define which fields (columns) will display?
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
How can you selectively display a guide – based on a Salesforce user’s role, for example?
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
How can you display a single guide when a user clicks a button or link?
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
How can guides be accessed in the Salesforce1 mobile app?
From the main navigation menu
As a publisher action
From the record detail page
When would you run a process on a local agent (versus Cloud agent):
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.
A process can be invoked from the following (check all that apply):
Using the Informatica Cloud API
From another process
Externally via SOAP or REST
From a Guide
Which of the following are true about the Parallel Path step do (check all that apply)?
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.
A process call step cannot have an input screen.
Select the best definition of a service connector.
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.
Which of the following are available out of the box service connectors (select all that apply):
Salesforce
Big Machines
JDBC
Netsuite
SAP
A Service Connector can define multiple actions.
How does a service connector parse data returned from a service and place it in variables (select all that apply)?
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.
Before you can use a Service Connector in a process or guide, you must (select all that apply):
Publish the service connector.
Register the service connector using the Process Console.
Create a connection using the Service Connector.
What does a connection do?
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.
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?
Process Call
Creat
Service Call
Assignment
Which of the following things can you determine using Process Console (select all that apply)?
Which path a process took.
The user who initiated the process
The start/end date/time for the process
A list of inputs/outputs
