For recovery purposes, it is desired to keep the output of several data flow operators after the execution has ended. This can be done in two different ways. Which two types of operators and properties would you use to keep the output? (Choose two.)
A. A Data Station operator with a type of temporary table and a table name.
B. A Data Station operator with a type of view and a view name.
C. A Data Station operator with a type of file and a file name.
D. A Data Station operator defined as pass through.
E. A Data Station operator with a type of persistent table and a table name.
正解:C,E
質問 2:
A warehouse application contains a process that in turn contains an activity that references a variable with a final phase of EXECUTION_INSTANCE. When going through the schedule wizard, which object is actually scheduled?
A. a process profile
B. the process
C. the activity
D. the warehouse application
正解:A
質問 3:
Your company's business analysts want to analyze ERP data with an OLAP tool. You have decided to build a data warehouse and use Cubing Services to create a cube that the tool will access. What is the process to build the data warehouse from the ERP database and then create the cube?
A. Create a Data Warehouse project to build the data warehouse; create the OLAP metadata andthe cube from the data warehouse.
B. Create an OLAP project to build the data warehouse; create the OLAP metadata and the cube.
C. Create a Data Development project to create the data warehouse; create the OLAP metadata and the cube from the data warehouse.
D. Create a Data Warehouse project to create the data warehouse and an OLAP project; create the OLAP metadata and the cube from the data warehouse.
正解:D
質問 4:
Customer Relationship Management (CRM) requires business insights that enable firms to offer specific, personalized services, and products to their customers. Which mining method is used for customer segmentation CRM applications?
A. Association
B. Sequencing
C. Clustering
D. Regression
正解:C
質問 5:
What does a Data Design Project within Design Studio contain?
A. data mining flows
B. logical data model
C. SQW work flows
D. physical data model
正解:D
質問 6:
What are three valid control flow components?
A. process flow, subflow, flow charts
B. sources, transformers, targets
C. stored procedures, triggers, subprocess
D. operators, variables, connections
正解:D
質問 7:
When connecting an Output Port of a Table Source to the Names Port of a Sequences Operator, what are two valid methods of mapping columns? (Choose two.)
A. by Position
B. by Key
C. by Index
D. by Attribute
E. by Name
正解:A,E
質問 8:
A high-quality physical database design is one that meets which two goals? (Choose two.)
A. Compresses the data.
B. Improves the efficiency of database management.
C. Minimizes I/O.
D. Minimizes the need for database backups.
E. Creates design features that optimizes query performance regardless of impact on maintenance operations.
正解:B,C
Gotou -
基本情報技術者の資格取得に関心があり、手に取りました。本C2090-719試験は非常に簡単なので頑張ってください。