You need to join three tables together in a data flow. The Table Join operator is placed onto thework area and only has two input ports defined. Which technique should you use to join the three tables?
A. Add an additional input port to the Table Join operator.
B. Use the SQL Merge operator to join all three tables.
C. Use the Table Join operator to join two of the tables and then use the properties view to change the generated SQL.
D. Use the Table Join operator to join two of the tables and then use a second Table Joinoperator to outer join the third.
正解:A
質問 2:
Which components are used to run a Cubing Services Server?
A. Cubing Services Server, Design Studio, Admin Console, Cubing Services multidimensional database
B. Cubing Services Server, Admin Console, Alphablox, DB2
C. Cubing Services Server, Design Studio, Admin Console, Alphablox
D. Cubing Services Server, Design Studio, Admin Console, DB2
正解:D
質問 3:
Which data-mining operator can be used to create set-valued XML documents that can be processed by some of the mining algorithms?
A. Item Aggregator
B. Correlations Extractor
C. Associations
D. Dictionary Lookup
正解:A
質問 4:
What are two ways MDCs provide features that facilitate the roll-in and roll-out of data?
(Choose two.)
A. Inserts are faster because the block index is only updated once the block is deleted.
B. There is no need to REORG data after roll-in and roll-out.
C. Inserts are faster because MDC can quickly create new empty blocks.
D. There is only a need to REORG data after roll-out.
E. Locking is reduced for inserts because they occur at a block level rather than at a row level.
正解:B,E
質問 5:
OLAP metadata for a star schema has been defined in the Design Studio and exported as an XML document. Which step(s) are required to deploy the cube to a cube server?
A. Import the cube to the cubing services repository.
B. Import the cube to the cubing services repository, associate the cube with a data source, add it to a cube server, and enable the cube.
C. Import the cube to the cubing services repository and associate the cube with a data source.
D. Import the cube to the cubing services repository, associate the cube with a data source, and add it to a cube server.
正解:D
質問 6:
Which two functions can the SQW tool perform for a data flow? (Choose two.)
A. business processes such as secure command and secure FTP
B. operators for row compression, roll-in, and roll-out
C. range partitioning for staging tables
D. parallel process execution
E. filtering and sorting for operator properties such as table columns
正解:C,E
質問 7:
For text analytics, the technique that uses a dictionary to do searching is known as which type of information extraction?
A. natural language processing
B. list-based
C. regular expression
D. rule-based
正解:B
質問 8:
A customer adds transactional data daily and rolls off historical transactional data monthly to archive. Which partitioning strategy should they use to accomplish this time-cyclical data management for their warehouse data?
A. Specify database partitioning on day and a table partitioning key for month.
B. Specify a MDC for month and a table partitioning key for day.
C. Specify a MDC on day and a table partitioning key for month.
D. Specify database partitioning on month and a table partitioning key for day.
正解:C
Tamaki -
C2090-719自習効果は高いと思います。
予備試験の答案も奇をてらわない無難な構成のものが掲載されており、Pass4Test高印象です。