Question 1
Question
What information is contained in the Audit Log?
Answer
-
Field-level mapping changes.
-
User Logins.
-
Both User Logins and Create/Update/Delete operation on objects.
-
Informatica Cloud Task Errors.
Question 2
Question
Where are the detailed error logs for tasks located?
Answer
-
\main\logfiles from the root of the Secure Agent filepath
-
\main\rdtmDir\error from the root of the Secure Agent filepath
-
Informatica Cloud Admin Console
-
These are only available in the Informatica Cloud Application.
Question 3
Question
Configuring object-level permissions allow you to restrict or expand the permissions the user group has for the object.
Question 4
Question
What is the purpose of the Cloud Connector Toolkit?
Answer
-
To develop native connectors for the Informatica Cloud
-
To establish connectivity to custom salesforce objects
-
To connect integration templates to multiple targets
-
None of these
Question 5
Question
Which of the following could be used to invoke ICS REST API?
Answer
-
Java
-
force.com
-
JavaScript
-
cUrl
-
All of the above
Question 6
Question
Where can a user define parameters for use in Data Synchronization tasks?
Answer
-
Parameters are not definable for use in the Informatica Cloud
-
In the secure agent directory path /main/rdtmDir/files
-
In the parameters tab within the Informatica Cloud UI
-
In the secure agent directory path /main/rdtmDir/userparameters
Question 7
Question
What format is used in a parameter file for Data Synchronization tasks?
Answer
-
parameter=value
-
$$parameter=value
-
$value=parameter
-
parameter==value
Question 8
Question
If you make changes to an embedded guide, the changes will be propagated to all guides that use the embedded guide.
Question 9
Question
The embedded guide and the embedding guide must both be published in order to work together.
Question 10
Question
Connections can be created for which of the following?
Answer
-
Published service connectors.
-
Licensed Informatica Cloud connectors that are real-time enabled.
-
Deployed connectors created in BPEL using Informatica Process Developer
-
All of the above.
Question 11
Question
A Secure Agent is ___.
Answer
-
a 32- bit of 64-bit hosted instance of PowerCenter running in Amazon or Azure instance.
-
a lightweight 32-bit or 64-bit application that clients can chose to upgrade ad-hoc
-
a lightweight 32-bit or 64-bit application hosted by Informatica for customers to use
-
a lightweight 32-bit or 64-bit self upgrading program that runs on a machine in the customers network or an Amazon or Azure instance
Question 12
Question
In an assignment step, if you want the input fields to be populated with a numeric value, select a data source of:
Question 13
Question
You have a child object, a contact record that belongs to an account that's already in Salesforce but you don't have the external id to match it to. You do have the account name on the incoming contact record so you can match the incoming account name on the account name already stored in Salesforce. What feature or transformation do you need to use in the Data Synchronization Service to match those values together?
Answer
-
On Step 5 of the Data Synchronization Wizard use the 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 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.
Question 14
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:
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 15
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 16
Question
Which of the following is not a valid incoming field rule type?
Question 17
Question
You want to load account records from a .csv source file where 'BillingState' =NY AND 'Annual Revenue' >=1000000000, you should use a simple filter to do this.
Question 18
Question
Which of the following could you use a field expression to do?
Answer
-
Trimming blank spaces from a source field.
-
Mapping multiple source fields to a single target field
-
Insert a value into a target field for all records
-
Covert date to the correct format for target field
Question 19
Question
How are data filters within Data Synchronization tasks used?
Answer
-
They filter source data using valid SQL or SOQL
-
They determine deltas in source data.
-
They filter data after the field-level mapping has been completed.
Question 20
Question
Salesforce Bulk API jobs run in parallel mode (batches are written to the target at the same time) by default.
Question 21
Question
Which of the following are supported pre-processing or post-processing commands?
Answer
-
SQL Command
-
Unix Command
-
Valid DOS or batch file
Question 22
Question
Which of the following can be used to write to multiple targets?
Answer
-
Mapplets
-
Mappings
-
Connections.
Question 23
Question
When adding parameters to a Cloud Mapping Designer mapping, it is a good idea to add them:
Answer
-
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.
-
In the mapping configuration task.
Question 24
Question
Active transformations do not change the number of rows that pass to the next step of the mapping.
Question 25
Question
What is the purpose of the field mapping in the Target transformation?
Answer
-
Allows fields from source to be mapped to fields in the Target.
-
Allows new fields to be created in the Target to match Source
-
Allows source fields to be deleted if they do not exist in Target
-
None of the above
Question 26
Question
Which transformation is used to define how data from 2 different sources can be combined?
Answer
-
Aggregator
-
Filter
-
Joiner
-
Expression
Question 27
Question
Which 'passive' transformation would you use to create a new field?
Question 28
Question
How do you specify the set of fields that flow from one shape in the mapping to the next?
Answer
-
Draw a line for each field going out of a shape into the next shape
-
Specify a set of incoming field rules in the receiving shape
-
Select the set of fields in the line linking the two shapes
-
Fields cannot be selected. All fields leaving a shape flow into the subsequent shape
Question 29
Question
John has "SKU number" coming in from his Source data containing Order information. Each "SKU number" corresponds to product description, price. The details of the product description and price for particular "SKU number" exists in another database. In order to read this product information and augment that to the order details, what transformation would John be using?
Answer
-
Normalizer
-
Lookup
-
Filter
-
Aggregator
Question 30
Question
Jayden would like to build a mapping, but run it against 3 different sets of Sources and Targets, one each for Dev/Test/Prod. Which of the following is the best way for him to achieve this?
Answer
-
Define a single mapping with the Source and Target connections parameterized. Configure 3 MCTs, one for each set of Sources and Targets: Dev/Test/Prod
-
Create 3 copies of the mapping, one for each set of Sources and Targets: Dev/Test/Prod
-
Define a single mapping with the Source and Target Objects parameterized. Create 3 copies of this mapping for this different Source and Target connection
-
None of the above.
Question 31
Question
Once a MCT is defined, any further changes to the mapping will not affect the mapping configuration task until:
Answer
-
The mapping is deployed.
-
The mapping is Saved.
-
The mapping is Deleted.
-
The mapping is executed.
Question 32
Question
Which of the following is an Active transformation?
Answer
-
Expression
-
Filter
-
Aggregator
-
None of the above
Question 33
Question
In a Filter transformation, can the value to filter the data by be defined as a parameter that can be configured at runtime?
Question 34
Question
Jennifer is working on creating a report. She has Sales data for all regions. She would like to determine the total Sales per region. She would also like to get the average deal size per region. Which transformation should she be using?
Answer
-
Aggregator
-
Expression
-
Filter
-
Lookup
Question 35
Question
Which of these statements is true?
Answer
-
A Cloud Mapping Designer mapping can only move data from a single Source to a single Target.
-
A Cloud Mapping Designer mapping can only be used to build integrations between Cloud applications.
-
A Cloud Mapping Designer mapping can integrate data from multiple Cloud and On-Premise Sources with multiple Cloud and On-Premise Targets.
-
None of the above.
Question 36
Question
Sources and Targets in a mapping can be __.
Answer
-
Relational databases
-
Cloud applications
-
Files
-
Any of the above.
Question 37
Question
A mapping has 2 parameters. A MCT has been defined with values for the 2 parameters. The MCT is scheduled to run every night at 10pm. The mapping designer modified the mapping to add another parameter and deploys his changes to the dependent MCT. What is to be expected at the next scheduled execution of the task?
Answer
-
The task will ignore the changes until it has been un-scheduled
-
The task will be rendered incompatible and must be deleted and re-created.
-
A mapping has 2 parameters. A MCT has been defined with values for the 2 parameters.
-
The task will fail with a notification that additional configuration is needed. Once the task is edited and the value for the newly added parameter is configured, it will run successfully.
Question 38
Question
Name the feature used to sequentially run tasks in a specified order
Answer
-
PowerCenter Service
-
Workflows
-
Task Flows
-
Plug-ins
Question 39
Question
A Related Object is an object that is related to another object based on a relationship defined in Informatica Cloud.
Question 40
Question
Which operation would be best to use when synchronizing data between two systems?
Question 41
Question
Where can you find Informatica Cloud log files?
Answer
-
On the agent machine, in the Secure Agent installation directory, under rdtmDir
-
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 42
Question
Incremental Processing is built into Data Replication for all source types.
Question 43
Question
What source data types are valid for use in a Data Replication Service?
Answer
-
Salesforce data
-
Salesforce and database data
-
Salesforce, flat files, and database data
-
Database and flatfile data
Question 44
Question
Where does the data get processed?
Answer
-
In the Informatica Cloud servers
-
In the Informatica Cloud Secure Agent (typically behind customer firewall)
-
In the informatica cloud repository
Question 45
Question
How does the Secure Agent communicate with Informatica Cloud?
Answer
-
All communication is outbound through HTTPS protocol (port 443)
-
Communication is initiated over telnet
-
There is no communication between the secure agent and Informatica Cloud
-
Communication is initiated by Informatica
Question 46
Question
Which statement best describes the Secure Agent?
Answer
-
Included templates for building jobs in the Informatica Cloud
-
A group of services without a user interface that executes jobs that were created using the Informatica Cloud web based interfaces.
-
Holds security modules for a client running in the Informatica Cloud
-
Allows clients to run Data Quality Mappings in the Cloud.
Question 47
Question
Within the Guide Designer, you can view the following report(s) on guide usage:
Answer
-
Outcome Chart
-
Detailed Activity
-
Current Activity
Question 48
Question
By default, only Admin profiles have access to the Guide Designer tab:
Question 49
Question
Guide execution details are only available for a guide if the Guide Execution Logging property is enabled
Question 50
Question
When you view the Outcome Chart for a guide, it displays data about the end of guide outcomes:
Question 51
Question
Service connectors can be used to access (pick 2)
Question 52
Question
A data decision step almost always has an Otherwise answer
Question 53
Question
Data decision steps can perform tests for which of the following?
Answer
-
Text values
-
Numeric values
-
Date values
-
All of the above
Question 54
Question
Customization of the guide themes is possible in the following ways:
Question 55
Question
In order to install Real Time in your Salesforce org, you must:
Answer
-
Have the managed package link
-
Have the Professional edition of Salesforce
-
Be a system administrator
Question 56
Question
Screen steps are typically used to ___.
Answer
-
Present different answers.
-
Display instructions.
-
Show data to the user and to have the user update data.
-
Accomplish tasks automatically.
Question 57
Question
What types of Objects can a Screenflow guide read/write?
Answer
-
Standard Objects
-
Custom Objects
-
Junction Objects
-
All of the above
Question 58
Question
What happens in a screenflow guide if there is a validation rule defined in Salesforce?
Answer
-
The Screenflow Guide uses the validation rule without notifying the user.
-
The Screenflow Guide ignores the validation rule.
-
The Screenflow Guide does not advance until the user corrects the input data for the validation rule.
-
The Screenflow Guide crashes.
Question 59
Question
If you want a guide to perform a hand-off from one person to another, use a milestone step.
Question 60
Question
If you want to prevent a user from stepping backwards in a guide, be sure to disable the following option(s).
Question 61
Question
With a Screenflow Guide, which of the following options are available to make fields required?
Answer
-
Make the field required in Salesforce Administrative setup.
-
You never need required fields with Screenflow Guides.
-
Screenflow guides ignore required fields in Salesforce.
-
Make the field required at any step in a Screenflow Guide.
Question 62
Question
How do you make a Screenflow Guide launch from a button on a Salesforce page?
Question 63
Question
With mobile guides, we recommend setting the Applies To:
Answer
-
Home
-
Any Object
-
Event
-
Content
Question 64
Question
Without Real Time Apps in Salesforce1, users are limited to single-step actions.
Question 65
Question
If you want to use the same guide on smart phones and on desktop/tablets, you need to create two version of the guide.
Question 66
Question
Customer integration data is stored in the Informatica Cloud Application.