Cloud Data Integration Specialist Certification

Question

Informatica Cloud allows business users to integrate data across both cloud-based applications and on-premise applications and databases.*

Answer 1

Data Synchronization

Answer 2

Mapping Configuration

Answer 3

Data Replication

Answer 4

In the Informatica Cloud Repository

Answer 5

In the Informatica Cloud Secure Agent (behind customer firewall)

Answer 6

In the Informatica Cloud servers

Answer 7

Source and Target Metadata

Answer 8

Saved Queries

Answer 9

Informatica Cloud Agent Console

Answer 10

Organization settings page

Answer 11

Agent Log File

Answer 12

There is no communication between the secure agent and Informatica Cloud

Answer 13

All communication is outbound through HTTPS protocol (port 443)

Answer 14

Communication is initiated over telnet

Answer 15

Salesforce, FTP/SFTP, Netsuite

Answer 16

MS Dynamics CRM, Amazon Redshift, Zuora

Answer 17

Flat File, SAP, Web Service

Answer 18

Trusted IP Range

Answer 19

Security Token

Answer 20

Either Security Token or Trusted IP Range

Answer 21

On the agent machine, in the Secure Agent installation directory, under

Answer 22

Error rows preview and job log file can be accessed from the activity log and job details pages in Informatica Cloud

Answer 23

By logging into the IC Repository

Answer 24

Salesforce ID

Answer 25

Foreign Key

Answer 26

External ID

Answer 27

Date-Based Filtering

Answer 28

Incremental Processing

Answer 29

Pre-Processing Command

Answer 30

Insert a value into a target field for all records

Answer 31

Convert date to the correct format for target field

Answer 32

Mapping multiple source fields to a single target

Answer 33

Trimming blank spaces from a source field

Answer 34

Flat files

Answer 35

Database tables

Answer 36

Salesforce objects

Answer 37

Limit or qualify the data that is being pulled from a source

Answer 38

Complicated join of multiple tables

Answer 39

Aggregations in SQL

Answer 40

Use the SQL COUNT function

Answer 41

Use a SELECT statement

Answer 42

Do not use conversion functions (like TO_CHAR, etc)

Answer 43

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.

Answer 44

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.

Answer 45

On Step 5 of the Data Synchronization Wizard use the lookup function to match the records and return the Salesforce Id field.

Answer 46

Run the task off hours so that performance is not impacted by normal intraday processing.

Answer 47

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.

Answer 48

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.

Answer 49

Data back-up

Answer 50

Synchronizing data between systems

Answer 51

Offline Reporting

Answer 52

Create Target

Answer 53

Download Mapping XML

Answer 54

Reset Target

Answer 55

10 minutes

Answer 56

Task Flows

Answer 57

Work Flows

Answer 58

Connections

Answer 59

IE version 8

Answer 60

Delete all of the date fields from the source.

Answer 61

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.

Answer 62

Configure a simple filter condition to exclude fields with data type of Date/Time.

Answer 63

Expression

Answer 64

Integration Templates

Answer 65

In the mapping configuration task.

Answer 66

After the mapping has been configured and tested with specified objects or filters, then parameters can be added to replace those objects or filters

Answer 67

During the initial configuration of the mapping.

Answer 68

Import the new mapping from PowerCenter.

Answer 69

Save and deploy to mapping configuration tasks.

Answer 70

Save updates as a new mapping (retaining the previous version of the mapping).

Answer 71

On the Informatica Secure Agent machine under the userparameters directory

Answer 72

The parameters are passed in by the developer at run time

Answer 73

On the Informatica Cloud under the Configuration tab

Answer 74

SQL Command

Answer 75

Unix Command

Answer 76

Valid DOS or batch file

Answer 77

Salesforce Trigger

Answer 78

Salesforce Outbound Messaging

Answer 79

Third Party Scheduler

Answer 80

You are using APEX triggers which require that you load one record at a time to function properly.

Answer 81

You want to avoid writing duplicate data from your source.

Answer 82

You are loading a million or more rows of data from your source.

Answer 83

SQL Server source data loaded and masked into Salesforce target

Answer 84

Oracle data masked in place

Answer 85

Salesforce source data loaded and masked into separate Salesforce target

Answer 86

Substitution Masking

Answer 87

Key Masking

Answer 88

Random Masking

Answer 89

Your company sends direct mail marketing pieces.

Answer 90

Your company purchases lead lists from tradeshows.

Answer 91

Your company uses the Territory Management feature in Salesforce.

Answer 92

Map the shipping and billing address fields separately.

Answer 93

Check the multiple source object option.

Answer 94

Create two Contact Validation tasks - one for each set of address fields.

Answer 95

Permission

Answer 96

User Group

Answer 97

Connections

Answer 98

Business Users have to Use Excel and Access to do Analytics

Answer 99

None of the Above

Answer 100

Companies having JAVA , .NET or PL/SQL to accomplish Data Integration needs in their organizations

Answer 101

Companies have On-Premise Data Sources and SaaS Applications that require integration

Answer 102

Data Quality

Answer 103

Test Data Management Suite

Answer 104

ERP Integrator

Answer 105

Contact Validation Service

Answer 106

Toolkit allows you to give you training to your business users

Answer 107

It provides Data out of your ERP Systems

Answer 108

JAVA Framework to create standardized integrations to your SaaS Applications

Answer 109

it allows Integration between Powercenter and ICS

Answer 110

Powercenter, Data Quality and Cloud MDM

Answer 111

Create a Java Framework and Create standardized Flat Files

Answer 112

Cloud ICC, Cloud Integration Templates and Cloud Connector ToolKit

Answer 113

Developer, ILM & Test Data Management

Answer 114

Horizontal

Answer 115

Vertical Macro

Answer 116

Horizontal Macro

Answer 117

Hybrid Macro

Answer 118

Show Fields

Answer 119

Show Lines

Answer 120

Action menu

Answer 121

All of these

Answer 122

Generated Key

Answer 123

Generated Row Id

Answer 124

Generated Column ID

Answer 125

Create masked data for software development, testing, training, and data mining

Answer 126

The Data Masking transformation provides masking rules based on the source datatype and masking type you configure for a port

Answer 127

You cannot maintain data relationships in the masked data and maintain referential integrity between database tables

Answer 128

Masking transformation modifies source data based on masking rules that you configure for each column

Answer 129

Use the Data Masking transformation to change sensitive production data to realistic test data for non- production environments

Answer 130

Encryption masking

Answer 131

Substitution masking

Answer 132

Key masking

Answer 133

Random masking

Answer 134

IP Address masking

Answer 135

Random masking

Answer 136

Substitution masking

Answer 137

None of the Above

Answer 138

All of the above

Answer 139

Key masking

Answer 140

The Mapping Configuration application processes SOAP messages with document/literal encoding.

Answer 141

The Web service request/response messages in the transformation are in JSON format

Answer 142

Web Service operations include requests for information, requests to update data and requests to perform tasks.

Answer 143

WSDL is the is an XML file that describes the operations of a Web Service

Answer 144

Define a Business Service, Create a Web Services Consumer connection, Configure the Web ServicesTransformation in the mapping

Answer 145

Create a Web Services V2 connection, Define a Business Service, Configure the Web Services Transformation in the mapping.

Answer 146

Create a Web Services Consumer connection, Define a Business Service, Configure the Web ServicesTransformation in the mapping.

Answer 147

Define a Business Service, Create a Web Services V2 connection, Configure the Web ServicesTransformation in the mapping

Answer 148

Web Services Description Language

Answer 149

Web Services Definition language

Answer 150

Web Services Delegation Language

Answer 151

Web Services Derivation Language

Answer 152

Connectors

Answer 153

Integration Templates

Answer 154

Service Integrators

Answer 155

User Community

Answer 156

Informatica

Answer 157

Representational State Transfer

Answer 158

ReStructuredText

Answer 159

Real-time Embedded Systems Testbed

Answer 160

Url Request Parameters

Answer 161

Form Request Parameters

Answer 162

Header Request Parameters

Answer 163

One or more of above

Answer 164

Standard object Access Protocol

Answer 165

Simple object Access Protocol

Answer 166

System object Access Protocol

Answer 167

WebServices

Answer 168

WebServices V2

Answer 169

Power Center Task

Answer 170

Data Replication Task

Answer 171

Data Synchronization Task

Answer 172

Available XML Documents

Answer 173

Other optional Web Services

Answer 174

Web Services Methods

Answer 175

User Initiated

Answer 176

Pre-defined Schedule

Answer 177

Does nothing.

Answer 178

The task run indefinitely.

Answer 179

Reads all source data and stops.

Answer 180

create, update, and delete connections

Answer 181

create, update, and delete schedules

Answer 182

start and monitor tasks and task flows

Answer 183

verify the Salesforce API version

Answer 184

All of the above

Answer 185

cloud real time

Answer 186

connection

Answer 187

popular ReST Clients such as POSTMAN , ADVANCE ReST Client

Answer 188

Informatica Cloud Utility available at MarketPlace

Answer 189

Power Center

Answer 190

Informatica's Methodolgy for Developer to follow a Best Practice(Process)

Answer 191

Eclipse Based tool to developer BPEL Processes for Informatica Cloud

Answer 192

Create a Process in Informatica Cloud to be invoked by SFDC

Answer 193

Developer Resource required to create Real-Time Orchestration

Answer 194

Create a Participant and Have XML Schema attached to it

Answer 195

Create a Participant(Consumer or Provider)

Answer 196

Flat File with Header Records for Input/output

Answer 197

Only know the Type of WSDL (Synchronous or Asynchronous)

Answer 198

Regex Expression Builder

Answer 199

Ways to Bind values to Output Variable Responses

Answer 200

Allows you to write Powercenter Expression Functions

Answer 201

Constructs data using WS-BPEL and other extension Functions

Answer 202

Export Eclipse Workspace Project to BPR and Deploy that to Admin Console

Answer 203

Import Business Process Archive , Create a Process Deployment Descriptor and Import it in Process Developer

Answer 204

Create a valid BPEL Process, Create PDD, Create BPR

Answer 205

None of the Above

Answer 206

offline pending

Answer 207

As a JSON service

Answer 208

Using the Informatica Cloud API.

Answer 209

By running an Informatica Cloud task.

Answer 210

As a REST/XML or JSON service

Answer 211

Can be built by non-technical business users

Answer 212

Require an on-premise Informatica Agent to run

Answer 213

Automate processes and methodologies

Answer 214

Can retrieve data from/write data to Salsforce or other applications

Answer 215

Provides built-in support for reading data from/writing data to Salesforce objects.

Answer 216

Allows you to access all of the same features as Service & Process Designer.

Answer 217

Includes support for running guides on the Salesforce1 mobile platform.

Answer 218

Includes service and process monitoring within Salesforce.

Answer 219

Includes Visualforce Pages for displaying guides within the Salesforce UI.

Answer 220

A custom button must be created.

Answer 221

A Visualforce page must be added to the page layout.

Answer 222

The user viewing the page must be a System Administrator.

Answer 223

Which Salesforce users can access the guide

Answer 224

The subcategory the guide will be displayed under in the Guides list

Answer 225

Whether or not the guide can be accessed from the Service & Process Designer

Answer 226

Which object the guide will operate on and have access to.

Answer 227

Display instructions and allow a user to enter data

Answer 228

Display a list of records to a user.

Answer 229

Include HTML formatting and images in the guide.

Answer 230

Ask the user a question.

Answer 231

Allow you to track guide results for reporting purposes.

Answer 232

Allow you to provide options to guide users.

Answer 233

To display different results, depending on guide path taken.

Answer 234

Help you control the possible outcomes for users.

Answer 235

To create a new record of any type

Answer 236

To create a new user

Answer 237

To create a guide log event

Answer 238

To create a new guide outcome

Answer 239

The value is entered by the guide user

Answer 240

The value is determined by a formula.

Answer 241

The value is hard-coded and remains the same each time the guide is run.

Answer 242

The value is determined by the value of the selected field.

Answer 243

Tasks defined in the Salesforce System Administrator.

Answer 244

Sending an Email, Converting a Lead, and Submitting a Record for Approval.

Answer 245

Tasks available in Salesforce only.

Answer 246

Tasks available in Integrated Services and Applications, and tasks defined in service connections (created in Service and Process Designer).

Answer 247

Allows a guide user more flexibility.

Answer 248

Avoids duplication of the same set of steps.

Answer 249

Allows the guide to automatically start a background process

Answer 250

Allows a guide to take different paths depending on the value of a field

Answer 251

The order of the branches is not important

Answer 252

Tests for a condition

Answer 253

Each condition has a branch

Answer 254

Allow you to have multiple versions of the same guide

Answer 255

Allow you to repeat steps on multiple records

Answer 256

Allow you to avoid creating the same set of steps

Answer 257

Allow you to make changes in one place

Answer 258

Through the use of temporary fields in the embedded guide step.

Answer 259

Via the definition of global variables

Answer 260

Through the use of Guide-level fields

Answer 261

Edit the Guide properties and select the fields

Answer 262

You cannot control which fields display in a list of records

Answer 263

Edit the field properties and select the Display Fields

Answer 264

Define different page layouts for different user roles

Answer 265

Edit the Guide’s Applies To property

Answer 266

In the Guide’s Advanced properties, define a Boolean expression

Answer 267

In the Guide’s Advanced properties, list the user roles who can access the guide

Answer 268

Create a Visualforce page for the guide

Answer 269

Create a custom page layout for the guide

Answer 270

Edit the Guide Properties and select the button or link

Answer 271

Edit the Record Detail page layout for the guide’s Applies To object

Answer 272

From the main navigation menu

Answer 273

As a publisher action

Answer 274

From the record detail page

Answer 275

If the process will connect to more than one application or service.

Answer 276

If the process includes input and output fields.

Answer 277

If the process needs to access an on-premise resource that resides behind a firewall.

Answer 278

Using the Informatica Cloud API

Answer 279

From another process

Answer 280

Externally via SOAP or REST

Answer 281

From a Guide

Answer 282

Each path waits for a result, then the next branch is executed.

Answer 283

It executes multiple branches at the same time.

Answer 284

It is unique to processes (not available in guides).

Answer 285

A jump step can only jump to a step in the same branch.

Answer 286

An object that holds the details for connecting to an application or service – including username and password.

Answer 287

An object that defines the interaction between a Process Designer and a service – how the service will send and receive data.

Answer 288

An out-of-the-box connector that can be leveraged using Real Time.

Answer 289

Salesforce

Answer 290

Big Machines

Answer 291

Output values must be automatically generated using the XML response.

Answer 292

Data can be extracted using xQuery.

Answer 293

Data can be mapped directly to an output field using XML tag names or JSON properties.

Answer 294

Publish the service connector.

Answer 295

Register the service connector using the Process Console.

Answer 296

Create a connection using the Service Connector.

Answer 297

Defines a connection to a data source.

Answer 298

Stores a username and password for Salesforce.

Answer 299

Determines if you are licensed for a specific service or application.

Answer 300

Process Call

Answer 301

Service Call

Answer 302

Assignment

Answer 303

Which path a process took.

Answer 304

The user who initiated the process

Answer 305

The start/end date/time for the process

Answer 306

A list of inputs/outputs

	Criado por James McLean quase 9 anos atrás

Próximo

Cloud Data Integration Specialist Certification

Descrição

Resumo de Recurso

Questão 1

Questão 2

Questão 3

Questão 4

Questão 5

Questão 6

Questão 7

Questão 8

Questão 9

Questão 10

Questão 11

Questão 12

Questão 13

Questão 14

Questão 15

Questão 16

Questão 17

Questão 18

Questão 19

Questão 20

Questão 21

Questão 22

Questão 23

Questão 24

Questão 25

Questão 26

Questão 27

Questão 28

Questão 29

Questão 30

Questão 31

Questão 32

Questão 33

Questão 34

Questão 35

Questão 36

Questão 37

Questão 38

Questão 39

Questão 40

Questão 41

Questão 42

Questão 43

Questão 44

Questão 45

Questão 46

Questão 47

Questão 48

Questão 49

Questão 50

Questão 51

Questão 52

Questão 53

Questão 54

Questão 55

Questão 56

Questão 57

Questão 58

Questão 59

Questão 60

Questão 61

Questão 62

Questão 63

Questão 64

Questão 65

Questão 66

Questão 67

Questão 68

Questão 69

Questão 70

Questão 71

Questão 72

Questão 73

Questão 74

Questão 75

Questão 76