Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
A. Design Advisor
B. Visual Explain
C. Performance Advisor
D. Configuration Assistant
Which of the following tools can be used to schedule a backup operation that is to be run every Sunday evening?
A. Journal
B. Task Center
C. Activity Monitor
D. Command Line Processor
Which of the following is the major difference between relational data and XML data?
A. Relational data is self-describing; XML data is not
B. Relational data has inherent ordering; XML data does not
C. Relational data must be tabular; XML data does not have to be tabular
D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
Which of the following products is used to shred extensible markup language documents?
A. DB2 AVI Extender
B. DB2 Text Extender
C. DB2 XML Extender
D. DB2 Spatial Extender
Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?
A. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system
B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects
C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe
D. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography
Which of the following is NOT a characteristic of an OLTP database?
A. Granular transactions
B. Current data
C. Optimized for queries
D. Frequent updates
Which of the following is true about XML columns?
A. XML columns are used to store XML documents as a hierarchical set of entities
B. OnlyXQuery can be used to retrieve an XML document from an XML column
C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved
Which of the following is NOT a characteristic of a data warehouse?
A. Summarized queries that perform aggregations and joins
B. Heterogeneous data sources
C. Voluminous historical data
D. Sub-second response time
What is the SQL Performance Monitor used for?
A. To examine the health of a DB2 Database Manager instance
B. To visually construct complex DML statements and examine the results of their execution
C. To schedule tasks, run tasks, and send notifications about completed tasks to other users
D. To analyze database operations performed against a DB2 for i5/OS database
Which two of the following allow you to perform administrative tasks against database objects?
A. Control Center
B. Journal
C. Command Line Processor
D. Task Center
E. Health Center
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-730 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.