Enterprise Middleware Platforms and SAS Programming

Questions about IBM Cognos Planning, webMethods Integration Server/Broker, IBM MQ, and SAS programming languages and concepts

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

The default port at which MQ listener runs:

  1. 80
  2. 1414
  3. 1415
  4. 1416
Question 2 Multiple Choice (Single Answer)

data null; y = "Run"; y = "My Friend"; run; proc print; run; Output of print procedure?

  1. My Friend
  2. Run
  3. My
  4. Error
Question 3 Multiple Choice (Single Answer)

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?

  1. first =1 last =2
  2. first =1 last =1
  3. first =2 last =1
  4. first =2 last =2
Question 4 Multiple Choice (Single Answer)

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?

  1. 0
  2. 1
  3. 2
  4. Error
Question 5 Multiple Choice (Single Answer)

Data a;x= "My Name";X= "My Office";run;proc print data =a;run;What is output of print statement?

  1. x= "My Name", X= "My Office"
  2. Error
  3. x= My Offi
  4. X= "My Office"
Question 6 Multiple Choice (Single Answer)

Data B; X=1; S=X*5; Rename S=Multiply; Keep Multiply; Run; How many variables in dataset B?

  1. 2
  2. 0
  3. 3
  4. 1
Question 7 Multiple Choice (Single Answer)

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?

  1. Start in level 9 debug mode but does not write any server log information
  2. Start in level 9 debug mode and write all server log information to the screen
  3. Start in level 9 debug mode and write all of the server log information to the Unix syslog or NT event log
  4. There is no level 9 debug mode so the server will fail to start
Question 8 Multiple Choice (Single Answer)

For a REPEAT operation to execute as long as the specified repeat condition remains true, the count parameter needs to be set to:

  1. -1
  2. 0
  3. 1
  4. NULL
Question 9 Multiple Choice (Single Answer)

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?

  1. %partNo%=="WEBM*"
  2. %partNo%==/^WEBM/
  3. %partNo%==/$WEBM/
  4. %partNo%!=/WEBM.*/
Question 10 Multiple Choice (Single Answer)

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?

  1. webMethods6\IntegrationServer\lib
  2. webMethods6\IntegrationServer\lib\jars
  3. webMethods6\IntegrationServer\bin\jars
  4. webMethods6\IntegrationServer\bin
Question 11 Multiple Choice (Single Answer)

Which of the following is a valid reference to an Integration Server service named "quoteService" inside the folder "stock" within the parent folder "bank"?

  1. bank.stock.quoteService
  2. bank/stock:quoteService
  3. bank/stock.quoteService
  4. bank.stock:quoteService
Question 12 Multiple Choice (Single Answer)

What is the default port for the Broker Server?

  1. 5000
  2. 5649
  3. 6849
  4. 6869
Question 13 Multiple Choice (Single Answer)

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"?

  1. MyCompany:Database.process
  2. Database:process
  3. MyCompany.Database/process
  4. Database.process
Question 14 Multiple Choice (Single Answer)

The Integration Server WmPublic package comes with many useful services. Some of the services in the pub.schema Folder can be used to:

  1. Validate objects and the pipeline
  2. Generate services that interact with external databases
  3. Perform string manipulation and substitution operations
  4. Convert DTD files to XSD schemas
Question 15 Multiple Choice (Single Answer)

Using webMethods Integration Server, there are 2 languages which can be used to query XML documents. They are:

  1. XSL and WSL
  2. XQL and WSL
  3. WQL and XQL
  4. XSLT and XPATH
Question 16 Multiple Choice (Single Answer)

Communications with the webMethods Integration Server is handled via listeners. On which ports can the webMethods Integration Server have an active listener?

  1. 5555, 8021, 80, and/or 443 only
  2. Port numbers greater than or equal to 1000 only
  3. Any valid port number not already in use
  4. Ports 21, 80, 443, and any port number above 1000
Question 17 Multiple Choice (Single Answer)

What status can no longer process report requests but can accept and process control requests?

  1. stopped
  2. standby
  3. paused
  4. unknown
Question 18 Multiple Choice (Single Answer)

What can an administrator use to transfer security data from one location to another using Series 7 namespaces?

  1. Local authentication cache (.lac) file
  2. Configuration specification (.ccs) file
  3. Settings (.csa) file
  4. Local authentication export (.lae) file
Question 19 Multiple Choice (Single Answer)

what the Planning administration console service does?

  1. manages communications with Contributor Web and Contributor Add-in for Excel users.
  2. manages communications with the Planning Job Server subsystem
  3. manages communication with the Contributor Administration Console
  4. manages communications for real-time reporting from Contributor plan data in IBM Cognos 8.
Question 20 Multiple Choice (Single Answer)

What is created after the administrator initializes the metric store?

  1. a relational database
  2. a metric package
  3. a metric extract
  4. an object extract