최신 IBM Mastery P2090-018 무료샘플문제:
1. Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?
A) The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
B) The IMPORT utility is now deprecated and INGEST is the recommended alternative.
C) The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
D) The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
2. Which one of the following statements is TRUE about DB2 Workload Management (WLM)?
A) DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
B) DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
C) DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.
D) DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
3. Which one of the following options contains a benefit of the Java Generic Table Functions?
A) Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
B) Java Generic Table Functions can be implemented in any programming language.
C) Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
D) Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
4. Which one of the following statements is FALSE about DB2 Workload Management (WLM)?
A) DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.
B) DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
C) DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
D) When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
질문과 대답:
질문 # 1 정답: A | 질문 # 2 정답: B | 질문 # 3 정답: A | 질문 # 4 정답: C |