자격증의 가치는 발급 기관의 공신력에서 나옵니다. IBM InfoSphere Warehouse V9.5처럼 업계에서 널리 인정받는 자격을 목표로 하신다면, 2026년 기준으로 전문가들이 검증한 Fast2test의 C2090-719 학습 자료로 준비하시기 바랍니다.

IBM C2090-719 시험 개요:

IBM C2090-719 시험 요강 주제:

C2090-719 수험생을 위한 핵심 질문과 답변

최신 IBM certifications I C2090-719 무료샘플문제

문제 #1

An administrator has three data flows that will run for different lengths of time. All data flows must be completed before the next step in the control flow can be initiated. Due to an overlap in the data, they cannot be run in parallel. As each data flow completes successfully, a status file is created. What can be used within the control flow to perform a wait for all three data flows to complete?

A. Use a Parallel Container with three File Wait operators that check that the status files do not exist.
B. Use a File Wait operator with three input ports that checks for the existence of the status files.
C. Use a File Wait operator that checks for all three status files to be updated.
D. Use a Parallel Container with three File Wait operators that check for the existence of the status files.

문제 #2

Your warehouse schema is a snowflake design that has two dimension tables with outboard tables and a third dimension table without an outboard table. Five data flows have been created to load these tables. In your control flow, how would you efficiently process these loads?

A. Use one parallel container for the outboard tables" data flows which feeds a second parallel container for the three dimension table loads.
B. Use one parallel container for all five data flows.
C. Use one parallel container which contains a parallel container for the outboard tables and a parallel container for the three data loads.
D. Use one parallel container for the three dimension tables" data flows which feeds a second parallel container for the two outboard table loads.

문제 #3

Which two statements correctly describe the anatomy of a SQW flow? (Choose two.)

A. The anatomy of a data flow and control flow have the same functions.
B. A control flow can have multiple Start and End operators; the Start operator has three exit ports and the End operator has one entry port.
C. In a data flow, the output port of a transform operator can be directed to the input port of another transform operator.
D. A data flow can have one or more Data Flow operators and each operator can have one or more input and output ports.
E. When connecting a Table Source operator to a Distinct operator, these operators can connect at both operator-level and column-level.

문제 #4

You have used the Optimization Advisor of cubing services to suggest MQTs based upon a cube model and the data in the star schema. You would now like to see if the DB2 Design Advisor might suggest alternative MQTs.
How can you accomplish this?

A. Use the SQL log generated by the cube server to find the generated SQL statements to be passed to the DB2 Design Advisor.
B. In the Admin Console, choose to manage OLAP metadata; select the Summary Table Usage pushbutton; specify to pass the results to the DB2 Design Advisor.
C. After having invoked the Optimization Advisor from the Design Studio, export the generated metadata and pass that to the DB2 Design Advisor.
D. Pass the MDX queries used by the applications that will benefit from the MQTs to the DB2 Design Advisor.

문제 #5

Using InfoSphere Warehouse Design Studio, which two are required before you can work on a physical data model? (Choose two.)

A. You need to create a data flow.
B. You need to create a control flow.
C. You need to identify either the source or the target databases.
D. You need to create a data design project.
E. You need to create an ER diagram.

질문과 대답: