Planning

1. 1A database will be used primarily to identify sales patterns for products sold within the last three years and to summarize sales by region, on a quarterly basis. Which type of system is needed?

   1. AAnalytical
   2. BDB2 pureScale
   3. CData warehouse
   4. DOnline transaction processing (OLTP)
2. 2Which product can be used to tune performance for a single query?

   1. AIBM Data Studio
   2. BIBM Control Center
   3. CIBM Data Administrator
   4. DIBM Workload Manager
3. 3Which two DB2 products are suitable for very large data warehouse applications? (choose two)

   1. ADB2 for i
   2. BDB2 for AIX
   3. CDB2 for z/OS
   4. DDB2 purseScale
   5. EDB2 Express-C
4. 4What is DB2 Workload Manager (WLM) used for?

   1. ATo identify, diagnose, solve, and prevent performance problems in DB2 products and associated applications.
   2. BTo customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system.
   3. CTo respond to significant changes in a database's workload by dynamically distributing available memory resources among several different database memory consumers.
   4. DTo improve the performance of applications that require frequent, but relatively transient, simultaneous user connections by allocating host database resources only for the duration of an SQL transaction.
5. 5Which of the following is NOT a characteristic of a data warehouse?

   1. ASub-second response time
   2. BVoluminous historical data
   3. CHeterogeneous data sources
   4. DSummarized queries that perform aggregations and joins
6. 6Which statement about the DB2 pureScale feature is NOT true?

   1. AThe DB2 pureScale feature provides a database cluster solution for non-mainframe platforms.
   2. BThe DB2 pureScale feature is only available as part of DB2 Advanced Enterprise Server Edition.
   3. CThe DB2 pureScale feature can only work with the General Parallel File System (GPFS) file system.
   4. DThe DB2 pureScale feature is best suited for online transaction processing (OLTP) workloads.
7. 7Which two statements about large object (LOB) locators are true? (Choose two)

   1. AA LOB locator represents a value for a LOB resource that is stored in a database.
   2. BA LOB locator is a simple token value that is used to refer to a much bigger LOB value.
   3. CA LOB locator is a special data type that is used to store LOB data in external binary files.
   4. DA LOB locator represents a value for a LOB resource that is stored in an external binary file.
   5. EA LOB locator is a mechanism that acts similar to an index in the way that it organizes LOB values so they can be quickly located in response to a query.
8. 8Which type of database workload typically involves making changes to a small number of records within a single transaction?

   1. ADecision support
   2. BData warehousing
   3. COnline analytical processing (OLAP)
   4. DOnline transaction processing (OLTP)
9. 9Which of the following is NOT a characteristic of an OLTP database?

   1. ACurrent data
   2. BFrequent updates
   3. CGranular transactions
   4. DOptimized for queries
10. 10Which two platforms support DB2 10.1 pureScale environments? (choose two)

    1. AIBM mainframes running z/OS
    2. BIBM p Series servers running AIX
    3. CIBM p Series servers running Linux
    4. DIBM x Series servers running Linux
    5. EIBM x Series servers running a supported version of Windows

11. 11Which tool can analyze and provide recommendations for tuning individual queries?

    1. AIBM InfoSphere Data Architect
    2. BIBM InfoSphere Optim Query Tuner
    3. CIBM InfoSphere Optim pureQuery Runtime
    4. DIBM InfoSphere Optim Performance Manager Extended Edition
12. 12Which SQL statement will create a table named EMPLOYEE that can be used to store XML data?

    1. ACREATE TABLE employee (empid INT, resume XML)
    2. BCREATE TABLE employee (empid INT, resume XML(2000))
    3. CCREATE TABLE employee (empid INT, resume CLOB AS XML)
    4. DCREATE TABLE employee (empid INT, resume CLOB USING XML)
13. 13Which DB2 product provides a complete data warehousing solution that contains components that facilitate data warehouse construction and administration?

    1. ADB2 pureScale Feature
    2. BDB2 Workload Manger
    3. CIBM InfoSphere Warehouse
    4. DDatabase Partitioning Feature
14. 14Which statement about IBM Data Studio is NOT true?

    1. AThe IBM Data Studio administration client can be installed on servers running Red Hat Linux, SUSE Linux, Windows, and AIX.
    2. BThe IBM Data Studio replaces the DB2 Control Center as the standard GUI interface for DB2 database administration and application development.
    3. CThe IBM Data Studio is an Eclipse-based, integrated development environment (IDE) that can be used to perform instance and database administration.
    4. DThe IBM Data Studio allows users to connect to a DB2 database using a wizard; however, users are rewpuir4ed to provide login credentials before a connection will be established.
15. 15Which statement about inline large objects (LOBs) is NOT true?

    1. AWhen a table contains columns with inline LOBs, fewer rows can fit on a page.
    2. BInline LOBs are created by appending the INLINE LENGTH clause to a LOB column's definition.
    3. CBecause DML operations against inline LOBs are never logged, their use can reduce logging overhead.
    4. DInline LOBs improve query performance by storing LOB data in the same data pages as the rest of a table's rows, rather that in a separate LOB storage object.

Descripción

10.1 DB2 Fundamentals Test sobre Planning, creado por breannapkhuffman el 24/02/2016.

Autor

breannapkhuffman

Idioma

English

Visitas

2

Etiquetas

db2 fundamentals10.1

Valoración

Aún sin valoraciones

Valora este test

Valora este test

Más sobre Data Warehousing and Emerging Database Technologies