000-349 Exam Questions
63 real 000-349 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1Performance Monitoring and Tuning
Out of all the available settings for the location of the workspace, which one of the following is the most optimal setting for performance when processing small transactions such...
workspace settingsmemory workspaceMQ messagesperformance - Question #2Performance Monitoring and Tuning
One way to modify a type tree to increase performance is to:
type tree optimizationcontiguous elementsblob mappingWTX performance - Question #3Installation and Configuration
If the application developer wants to read a 2GB file that contains two million records of 1KB each and ensure that no data is processed unless all the input data is valid. What ar...
card settingsFetchAs BurstScope Mapdata validation rollback - Question #4Performance Monitoring and Tuning
Referring to the Exhibit, which map rule function takes the most time to run?
map rule functionsLOOKUP functionperformance analysisWTX profiling - Question #5Performance Monitoring and Tuning
One way to modify a type tree to increase performance is to:
type tree optimizationgroup specificationWTX performanceschema design - Question #6Troubleshooting and Problem Determination
A map has been designed to append to an audit log when a validation error occurs. The map is being run using the Command Server. At runtime, the map intermittently fails. After som...
map retryCommand Serveraudit log concurrencyRUN function - Question #7System Management
An application developer has a file which consists of fixed length records. The first record is a header record followed by some number of detail records. The number of detail reco...
component rulefixed length recordsheader counttype tree definition - Question #8System Management
Refer to Exhibit. Which one of the following statements is true with regards to the type trees created using the XML Schema Importer.
XML Schema Importertype treeXerces validationXSDL Hints - Question #9Troubleshooting and Problem Determination
The Analyze Tree results contain the message: L201 Different data objects of COMPONENT 1 are not distinguishable in TYPE file Data (warning) What action do you need to take?
Analyze Treecomponent distinguishabilitytype tree warningdata definition - Question #10System Management
Which of the following statements are true of a component rule? A component rule:
component ruledata validationoptional componenttype tree - Question #11System Management
Complex objects in a data stream:
complex objectsdata streamobject hierarchytype tree - Question #12System Management
Which statement about syntax items is true:
syntax itemsrestriction listtype treedata definition - Question #13System Management
The size of an object defined as a text item in a type tree:
text item sizeinitiator terminatortype treeobject sizing - Question #14Design
The example below shows 3 records of a file. Each record is terminated with a <NL> character. The file is not limited to a specific number of records. CMS Business Systems S3009346...
type treeformat propertiescomponent syntaxNL delimiter - Question #15Design
What is the primary difference between a choice group and a partitioned group.
choice grouppartitioned groupgroup typesdata distinguishability - Question #16Configuration
Refer to the Exhibit. A large corporation manufactures beds in different colors. The inventory file consists of three record types, a header, a detail, and bed color. The record ty...
restart attributeerror handlingrecord typestype tree - Question #17Design
Which of the following statements are true of syntax items. Syntax items:
syntax itemsseparatorscharacter databinary data - Question #18Design
If you had to create a type tree that contained numerous infix delimited groups, and numerous unsigned integer elements, what would be the easiest way to create the type tree? Crea...
type treecategoriesinfix delimiterunsigned integer - Question #19Design
The structure of the following file has been partially defined in a type tree: ~Smith~Robert~Programmer<NL> ~Doe~John~Manager<NL> The properties of the types have not been complete...
prefix delimitertilde characterrecord typetype tree - Question #20Design
Refer to the Exhibit. The Exhibit shows the group view for an input type tree that defines a purchase order (PO) file. The component rule on the Record component:
component rulegroup viewpurchase ordertype tree - Question #21Development
Refer to the Exhibit. The Exhibit shows the components of a purchase order. The application requires that the total number of items (TotalItems) in the Trailer Record equals the su...
component ruletrailer recordvalidationpurchase order - Question #22Development
Which one of the following statements is correct with regards to cross referencing information in a database?
database querySQLcomponent rulemap rule - Question #23Troubleshooting
A developer is loading the following records into a database: A,A,A,A B,B,B,B A,A,A,A C,C,C,C The database record has four fields each field will contain one letter from the file a...
database adapterupdate keyrollbackMDQ file - Question #24Configuration
In order to allow WebSphere Transformation Extender to integrate with an e-mail provider, choose all the correct statements:
email adapterImporter WizardWebSphere TXadapter integration - Question #25Development
What is the first thing that must be done in order to create a map to use a database as a source in an input card? Create:
MDQ filedatabase inputinput cardmap creation - Question #26Configuration
What the best method to create a backup of bad input data?
backupOnErrormap settingserror handling - Question #27Configuration
What additional parameter is needed when using a database for an input, that is not used when using a database for output?
database inputquery parameterinput cardadapter - Question #28Troubleshooting
A map has 10 input cards and 5 output cards. The map fails with the message one or more inputs was invalid. What is the next step to take to determine the cause of the error?
content tracemap failureinput validationtroubleshooting - Question #29Troubleshooting
Refer to the Exhibit. Using the map debugger, when the breakpoint is encountered in the following figure and Step-In is selected, what will happen?
map debuggerbreakpointStep-Infunctional map - Question #30Configuration
Which map setting should be used to create a list of data errors (including error codes and data values) during map execution?
data auditerror codesmap settingsexecution audit - Question #31Troubleshooting
The application developer is trying to build a map rule but cannot get the syntax right. What is the next troubleshooting step?
map rulesyntax errorrule debuggingDesign Studio - Question #32Troubleshooting
Refer to the Exhibit. Consider the audit log fragment below: level="2" size="243" status="E07">CustomerOrder</object> level="3" size="36" status="E07">Detail Record</object> level=...
audit logONERROR functioncomponent ruleerror status - Question #33Troubleshooting
A map fails with the following error message: INPUT 1 exists, but its type is in error. An input content is trace is generated. The following excerpts contain all the lines in the...
content tracemap failureitem subclasstype validation - Question #34Design
What Design Studio function cannot be completed using command line utilities?
Design Studiocommand line utilitiestype treestext file importer - Question #35Architecture
Select the item that applies to the following two statements: Pre-built templates that comply with the latest standards and data validation Decrease implementation time
Industry Packspre-built templatesdata validationstandards compliance - Question #36Design
Which tool defines relationships and manages collections of runtime maps at design time?
Integration Flow Designerruntime mapsdesign timemap management - Question #37Configuration
If a map contains two input cards with default settings and the second card fails validation, what happens to the map execution?
input cardscard validationmap executiondefault settings - Question #38Architecture
What WebSphere Transformation Extender component would be needed in a production environment in addition to the adapters?
Transformation Engineproduction environmentadaptersWTE components - Question #39Architecture
Which WebSphere Transformation Extender stand-alone engine has the following characteristics: Can be run on a variety of platforms Can be triggered by a time event Can run multiple...
Launcherstand-alone enginetime eventsmultiple instances - Question #40Configuration
Which setting has the most negative impact on map performance?
map performanceMap TraceAudit Logmap settings - Question #41Development
A map is being developed to process input data that contains invoices and purchase orders. The first 5 records of the data is provided below. 177735,PO,Acme Products,1000.23,101020...
EXTRACT functiondata filteringconditional processingfunctional maps - Question #42Development
Given the following scenario: There is one input file (SOHeader), which contains 200,000 records. The records in SOHeader file are comprised of three fields: SONumber, SOOrdType, a...
LOOKUP functionsearch efficiencysorted datarecord lookup - Question #43Troubleshooting
The following map rule returns the incorrect results; however the map rule does return the expected results when each LOOKUP is run independently. =IF(PRESENT(Name:.:AddressFile),...
LOOKUP functionseries objectsIF PRESENTmap rule debugging - Question #44Development
What is the difference between the INT function and the ROUND function? The INT function always discards the decimal, and the ROUND function:
INT functionROUND functiondecimal handlingnumeric functions - Question #45Development
An application developer needs to split a file consisting of 10 records into 10 output files each with one record. The file name of the output files must contain the record number...
INDEX functionRUN functionfile splittingdynamic filenames - Question #46Development
What is the method for indicating a reference to a specific occurrence of an input object in a map rule?
occurrence referencemap rule syntaxarray indexinginput objects - Question #47Troubleshooting
A map executes with the completion message of, input type contains errors. Which one of the following statements is always true?
input validationRESTART attributeerror messagesmap execution - Question #48Development
Which of the following statements are true of the REJECT function? The REJECT function:
REJECT functioninvalid datacomponent rulesmap rules - Question #49Development
An application developer is creating a map to produce a report which will include literal text concatenated with a numeric item named TotalCount. Which map rule should the develope...
FROMNUMBER functionnumber formattingtext concatenationmap rules - Question #50Design
A Referenced Map is a map that:
Referenced Mapmap sourceindirect referencesmap types