Performance & Scalability

Question 1

You are investigating a performance problem in an application, and you wish to identify the busiest routines, and also the lines of code where the busiest routines spend the most amount of time.
Which TWO of the following actions are the most suitable for gathering this information?

a. Use the ^BLKCOL utility from the IRIS command prompt
b. Use the ^%SYS.MONLBL utility from the IRIS command prompt
c. Use the ^JOBEXAM utility from the IRIS command prompt
d. Use the ^PERFMON utility from the IRIS command prompt
e. Use the ^mgstat utility from the IRIS command prompt

Answer 1

b. Use the ^%SYS.MONLBL utility from the IRIS command prompt

d. Use the ^PERFMON utility from the IRIS command prompt

Question 2

Which of the following methods allows you to gather statistics for the current process or job?

a. setSQLStatsFlag()
b. setSQLStatsFlagByNS()
c. setSQLStatsFlagJob()
d. setSQLStatsFlagByPID()

Answer 2

c. setSQLStatsFlagJob()

Question 3

Which keyword can be used in a SELECT, INSERT, UPDATE or DELETE statement to gather performance analysis statistics ?

a. %STATISTICS
b. %SQLSTATSFLAG
c. %SQL
d. %PROFILE

Answer 3

d. %PROFILE

Question 4

If you export Query Performance Statistics, and do not specify an output directory, to which of the following sub-directories will the file be written by default:

a. The Log directory
b. The Mgr directory
c. The SQL directory
d. The Stats directory

Answer 4

b. The Mgr directory

Question 5

Which of the following is NOT a valid output file format for exporting Query Performance Statistics ?

a. P (text)
b. D (comma-separated data)
c. X (XML markup)
d. H (HTML markup)
e. U (User-defined delimiter)

Answer 5

e. U (User-defined delimiter)

The correct value is Z for User-defined delimiter

Question 6

Which of the following will export the Query Plan ?

a. exportSQLStats
b. saveStatsSQL
c. saveSQLStats
d. exportStatsSQL

Answer 6

d. exportStatsSQL

Question 7

RunCount shows the number of times a query has been run since which of the following ?

a. the last time the query was compiled
b. the last time the query was run
c. system start-up
d. the last time that statistics were gathered

Answer 7

a. the last time the query was compiled

Question 8

Which IRIS component enables a distributed caching architecture ?

a. Distributed Cache Protocol (DCP)
b. Enterprise Cache Protocol (ECP)
c. Enterprise Protocol Cluster (EPC)
d. Horizontal Cluster Protocol (HCP)

Answer 8

b. Enterprise Cache Protocol (ECP)