Q11. A consultant for an aircraft engine manufacture is migrating their IBM Case Foundation system to a new set of hardware in order to handle an increased load in engineering drawings and their associated approval processes. Company policy does not allow the use of a graphical interface for application installations on their AIX servers. When the installation completes, what file should the con
Certify your Skills
Accelerate your Career
As the top company in the IT industry, IT has identified the standards of product experts through its certification, and it can be said that IT's reputation in the industry and IT's market share increase its certified engineers' gold content. In the United States, an IT certified engineer gets 60% -80% more than an average engineer in an excellent business, with an average salary of 30% to 50%. Fortune 500 companies, more than 2/3 of the enterprises choose IT e-commerce software products as its core use.
If you get IT certification, even in a competitive environment, you can also stand out. IT Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precisely and logically. Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precisely and logically.
Q1. The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column? A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person) B. CREATE UNIQUE INDEX sales_idx ON sales (s
Q21. Which action should you take to improve the performance of authorization checking for stored procedures or user-defined functions? A. Set subsystem parameter EXTSEC to YES. B. Increase the value of subsystem parameter SECQTY. C. Increase the value of subsystem parameter AUTHCACH. D. Increase the value of subsystem parameter CACHERAC. Answer: D Explanation:Reference:http://www.redbooks.
Q11. During a proof of concept, you successfully install and configure Optim to archive data from a DB2 LUWtest application database running on an AIX server. . A test archive (without deleting data) is initiated from the Optim Server running on a Windows 2003 server and runs successfully the first day. . The Optim directory is on a non-application database on the Windows 2003 server. . During
Q51. What is the correct order of installation for IBM Maximo Asset Management V7.5 (Maximo) products? A. Maximo V7.5. latest fix pack interim fix. latest fix pack B. Maximo V7.5, latest fix pack, latest fix pack interim fix C. Maximo V7.5. latest fix pack interim fix, all industry solutions being implemented D. Maximo V7.5. all industry solutions being implemented, latest fix pack interim fi
Q1. Review the Screenshot presented. What type of application navigation element can be expected to correspond with the element highlighted by the red box? A. Selection B. Menu C. Tab D. Navigation E. Shortcut-Tab Answer: B Q2. Which of the following statements about handcrafted service layer classes is true? A. Google Guice dispatches events to listeners B. The Persistence Infrastruct
Q31. Which command restores a Tivoli Enterprise Portal Server configuration on a UNIX system from a backup?A. tacmd cq "runscript.sh migrate-import.sh"B. itmcmd cq "runscript.sh migrate-import.sh"C. tacmd execute cq "runscript.sh migrate-import.sh"D. itmcmd execute cq "runscript.sh migrate-import.sh"Answer: DQ32. A Windows server has four network interfaces and only one must be used to connect t
Q11. Which statement is true about summarization and pruning? A. Summarization runs after pruning completes. B. Pruning writes all pruned data to a pruning log file. C. Summarized data can be skewed because of duplicate data records. D. A backup of the Tivoli Data Warehouse is taken before pruning starts. Answer: D Q12. Which statement is true regarding IBM Performance Management for Appli
Q61. What is the new name for the V3.1 release of IBM Tivoli Integrated Portal? A. Tivoli Dashboard Hub B. Dashboard Tivoli Portal Hub C. Tivoli Integrated Portal Dashboard D. Dashboard Application Services Hub Answer: D Q62. Which user permission allows the user to create new navigator views as well as edit and delete them in Tivoli Enterprise Portal? A. Action> Modify B. Custom Navi
Q31. A customer has a z13 machine with CPACF feature installed on the machine. They want to add Trusted Key Entry Workstation to support a new security project. Which z13 feature card is required to support this requirement? A. OSA Express5S 1000BaseT B. FICON Express16S C. Crypto Express5S D. OSA Express5S 10GB Answer: C Reference: http://www.redbooks.ibm.com/technotes/tips1257.pdf(page 6
Q31. What could be done if the report does not run after the category codes change? A. Rebuild the cube and publish a new package. B. Perform a Clean House. C. Modify the report to point to the updated member. D. Manually change the category codes within the model. Answer: C Q32. Where can a developer change relationships to create a structure different from what the data suggests? A. Cat
Q41. What is the preferred method for reclaiming unused storage in a DMS table space? A. Perform an ALTER TABLESPACE...REDUCE operation. B. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation. C. Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation. D. Perform a REORG on each table
Q21. What is required before you begin your installation of DB2 11? A. Data sets for catalog and directory tables must be user-managed. B. Data sets for only the catalog tables must be SMS-managed and include a data class for allocating the data sets in extended format. C. Data sets for only the directory tables must be SMS-managed and include a data class for allocating the data sets in exten
Q1. Which product replaced the Control Center used in versions prior to DB2 v10? A. IBM Data Studio B. IBM Administrator C. IBM Data Manager D. IBM Command Center Answer: A Explanation: Q2. If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database? A. 4 B. 8 C. 16 D. 32 Answer: A Explanation: Q3. What is used in conjunction with
Q21. A customer has a requirement to write data back to their relational database (e.g., Oracle). Which function should be executed in TurboIntegrator to accomplish this? A. ODBCExecute B. ODBCStatement C. ODBCOutput D. ODBCInput Answer: C Q22. What are three features of the TM1 Operations Console? (Choose three.) A. Adding new groups B. Monitoring multiple TM1 servers C. Scheduled log
Q51. What is the size, in bytes, of the Long data type in IBM LotusScript? A. 2 B. 4 C. 8 D. 16 Answer: B Q52. Julia wants to display the contents from a column in an IBM Domino view on a mobile page. Which control should Julia add to her mobile XPage to be the container for the Domino view? A. View B. Data View C. Mobile View D. Dynamic View Answer: B Q53. How many of the JavaServe
Q31. Which of the following comprises an initial Liberty profile server process?A. A single JVM, the Liberty kernel, and feature manager.B. A single JVM, an OSGI framework and an object request broker.C. An OSGI framework, a web container and an EJB container.D. An administrative agent, the Liberty kernel and shared libraries.Answer: CExplanation: Reference: https://www-01.ibm.com/support/knowled
Q41. An end user is presented with fields to gather specific or additional data when creating a service request from the Self Service Center. Where are these fields presented to the service desk agent when working the ticket?A. Activities tabB. Specification tabC. Solutions Details tabD. Service Request tab in the Details sectionAnswer: BQ42. In order to respect the dependencies between componen
Q11. A system administrator needs to design a solution for transferring confidential data from a financial institution that is using MQ network to another institution that is using non-MQ network and FTP/SFTP protocols. The data must be protected while the messages are on the queues on the MQ network and during the transfer. How can the system administrator do this? A. Use IBM MQ Managed File T
Q21. An insurance company has offices worldwide and makes use of the content cache areas for frequently accessed document content. Recently, the encryption key for encrypted storage area at this insurance company was compromised and a new key needs to be created. Which of the following is true for the original content in the content cache areas? A. If the original content is not encrypted, the