Enterprise Middleware Platforms and SAS Programming
Questions about IBM Cognos Planning, webMethods Integration Server/Broker, IBM MQ, and SAS programming languages and concepts
Questions
The default port at which MQ listener runs:
- 80
- 1414
- 1415
- 1416
data null; y = "Run"; y = "My Friend"; run; proc print; run; Output of print procedure?
- My Friend
- Run
- My
- Error
data a; first= 1; last=2; run; data b; first=1; last=1; run; data c; merge a(in=a) b(in=b); by first; if a; run; Dataset C contains?
- first =1 last =2
- first =1 last =1
- first =2 last =1
- first =2 last =2
data a; one=1; run; data b; set a(in=a) a(in=b); if a and b; run; How many observations in dataset b?
- 0
- 1
- 2
- Error
Data a;x= "My Name";X= "My Office";run;proc print data =a;run;What is output of print statement?
- x= "My Name", X= "My Office"
- Error
- x= My Offi
- X= "My Office"
Data B; X=1; S=X*5; Rename S=Multiply; Keep Multiply; Run; How many variables in dataset B?
- 2
- 0
- 3
- 1
If the webMethods Integration Server is started with from the server root directory with this command, "bin\server.bat -debug 9 -log none", what does this tell the server to do?
- Start in level 9 debug mode but does not write any server log information
- Start in level 9 debug mode and write all server log information to the screen
- Start in level 9 debug mode and write all of the server log information to the Unix syslog or NT event log
- There is no level 9 debug mode so the server will fail to start
For a REPEAT operation to execute as long as the specified repeat condition remains true, the count parameter needs to be set to:
- -1
- 0
- 1
- NULL
You are tasked to create a BRANCH which will execute a service only if a string named "partNo" begins with "WEBM". With the evaluate labels parameter set to "true", what is the correct syntax for the label of the service?
- %partNo%=="WEBM*"
- %partNo%==/^WEBM/
- %partNo%==/$WEBM/
- %partNo%!=/WEBM.*/
The Integration Server requires access to the Java classes for each JDBC driver that it will use. Typically, where must such Java classes be placed?
- webMethods6\IntegrationServer\lib
- webMethods6\IntegrationServer\lib\jars
- webMethods6\IntegrationServer\bin\jars
- webMethods6\IntegrationServer\bin
Which of the following is a valid reference to an Integration Server service named "quoteService" inside the folder "stock" within the parent folder "bank"?
- bank.stock.quoteService
- bank/stock:quoteService
- bank/stock.quoteService
- bank.stock:quoteService
What is the default port for the Broker Server?
- 5000
- 5649
- 6849
- 6869
Which is the correct format for referencing a service called "process" within the within a folder named "Database" that is contained within a Package called "MyCompany"?
- MyCompany:Database.process
- Database:process
- MyCompany.Database/process
- Database.process
The Integration Server WmPublic package comes with many useful services. Some of the services in the pub.schema Folder can be used to:
- Validate objects and the pipeline
- Generate services that interact with external databases
- Perform string manipulation and substitution operations
- Convert DTD files to XSD schemas
Using webMethods Integration Server, there are 2 languages which can be used to query XML documents. They are:
- XSL and WSL
- XQL and WSL
- WQL and XQL
- XSLT and XPATH
Communications with the webMethods Integration Server is handled via listeners. On which ports can the webMethods Integration Server have an active listener?
- 5555, 8021, 80, and/or 443 only
- Port numbers greater than or equal to 1000 only
- Any valid port number not already in use
- Ports 21, 80, 443, and any port number above 1000
What status can no longer process report requests but can accept and process control requests?
- stopped
- standby
- paused
- unknown
What can an administrator use to transfer security data from one location to another using Series 7 namespaces?
- Local authentication cache (.lac) file
- Configuration specification (.ccs) file
- Settings (.csa) file
- Local authentication export (.lae) file
what the Planning administration console service does?
- manages communications with Contributor Web and Contributor Add-in for Excel users.
- manages communications with the Planning Job Server subsystem
- manages communication with the Contributor Administration Console
- manages communications for real-time reporting from Contributor plan data in IBM Cognos 8.
What is created after the administrator initializes the metric store?
- a relational database
- a metric package
- a metric extract
- an object extract