Cause all that matters here is passing the IBM C2090-614 exam. Cause all that you need is a high score of C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) exam. The only one thing you need to do is downloading Pass4sure C2090-614 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q11. Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?
A. One composite block index and one unique index.
B. One composite clustering index and one dimension block index.
C. One index that serves as both the dimension block index and the composite block index.
D. One index that serves as both the dimension block index and the composite clustering index.
Answer: C
Topic 2, Volume B
Q12. What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?
A. AUDIT
B. VALIDATE
C. EXECUTE
D. CONTEXT
Answer: C
Q13. Which statement about data type mappings is true in a federated system?
A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.
B. Data types can be mapped in both directions between a remote and local data type.
C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.
D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.
Answer: B
Q14. Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
A. Create a replicated summary table for the SALES table using the table space TS_REPL.
B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
D. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
Answer: B
Q15. Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge offline backups to build full offline table space backups.
B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
Answer: B
Q16. Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?
A. The MON_GET_CONTAINER table function.
B. The SNAP_GET_TBSP_PART table function.
C. The SNAPTBSP_RANGE administrative view.
D. The TS_GET_CONTAINER administrative view.
Answer: A
Q17. A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?
A. The first time the database is accessed after the migration.
B. The first time the CREATE STOGROUP statement is executed.
C. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.
D. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.
Answer: B
Q18. Where is the HADR_TARGET_LIST configuration parameter set?
A. On the primary database only.
B. On all participating databases.
C. On the tertiary standby databases.
D. On the auxiliary standby databases only.
Answer: B
Q19. A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?
A. ORGANIZE BY DIMENSIONS
B. ORGANIZE BY INSERT TIME
C. ORGANIZE BY TIME PERIOD
D. ORGANIZE BY KEY SEQUENCE
Answer: B
Q20. 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 (sales_id, sales_date, sales_person)
C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
Answer: D