answer needed for the questions

Database
New Member

answer needed for the questions

hi, teratom,.

pls give the correct answers !!!

 

QUESTION 102
One reason for creating a multilevel partitioned table would be:
A. to increase table level locks B. to improve primary index retrievals C. to add value-ordered secondary indexes D. to create multiple access paths to the data
Correct Answer: B

QUESTION 103
What are two advantages of using a NoPI table? (Choose two.)
A. MultiLoad and TPump are supported. B. SELECT and DELETE will be faster than on a table with a primary index. C. The sort phase is eliminated when using FastLoad. D. Data will not be redistributed when performing an INSERT SELECT.
Correct Answer: AD

accurate answer.
QUESTION 104
Which two items describe a row in a relational table? (Choose two.)
A. A single entity in a table B. An input from a single data source C. A value for every column in the table D. One instance of all the columns in a table
Correct Answer: AC


QUESTION 105
What is an advantage of using row processing instead of set processing for a large table?
A. Increased synchronized scanning B. Decreased locking contention C. Increased read-ahead capabilities D. Decreased resources required when updating many rows
Correct Answer: D

QUESTION 106
Which feature may be used to enable data encryption?
A. Roles B. Profiles C. column-level security D. user defined functions (UDF) E. X views in the Data Dictionary
Correct Answer: C


QUESTION 107
What are two benefits to defining a sparse join index? (Choose two.)
A. Faster to scan B. Take up less disk space C. Store roll-up values for dimensions D. Corresponds to a single row in its referenced base table
Correct Answer: AC


QUESTION 109
Which two activities are supported by active events? (Choose two.)
A. Prioritizing mixed workloads B. Invoking downstream applications C. Detecting business conditions and invoking triggers D. Providing fresh-enough data to support customer interactions
Correct Answer: AC


QUESTION 110
Which function is performed by the Archive/Recovery Utility (ARC)?
A. Archive TASM settings for backup B. Archive a clusters of AMPs for backup C. Archive triggers to copy to a different system D. Archive fallback data to copy to a different node
Correct Answer: C


QUESTION 111
What are two advantages of a normalized relational database? (Choose two.)

  1. Eliminates composite primary keys B. Supports intelligent keys for automated data retrieval C. Able to respond to changing business conditions quickly D. Easier to add attributes without impacting existing applications E. Designed to leverage hardware technology to optimize performance
    Correct Answer: BD


QUESTION 112
Which statement is true about Algorithmic Compression (ALC)?
A. ALC allows users to define compression algorithms. B. Administrators can set ALC as the default at the system level. C. ALC allows users to compress row-level security constraint columns. D. Administrators can set ALC as the default for users at the profile level.
Correct Answer: C


QUESTION 113
Which statement is true about a relational database?
A. It is a collection of attributes. B. It is a collection of logically related tables. C. It is a collection of physically linked tables. D. It is a collection of related files and attributes.
Correct Answer: D


QUESTION 114
Which TPT operator supports the loading of near real-time data?
A. Load B. Update C. TPump D. Stream
Correct Answer: B

QUESTION 115
What are two key differentiators of columnar storage versus row storage? (Choose two.)
A. A table partitioned by column can have either a unique or non-unique primary index. B. Each column partition of a table partitioned by column can be composed of a single column or multiple columns. C. A table partitioned by column can alternatively store a specific column in multiple containers for improved data access. D. A table partitioned by column can have physical rows with ROW format, called subrows, that are used to implement row-storage.
Correct Answer: AD


QUESTION 116
Which two statements are true about fallback? (Choose two.)
A. It automatically restores data changed when an AMP is offline. B. A down AMP Recovery Journal opens in the event of an AMP failure. C. It takes a before image of the row then discards it upon transaction completion. D. When one system goes down, fallback rows automatically migrate to the fallback clique.

Correct Answer: BD


QUESTION 117
Which statement is true about using FastLoad to load a NoPI table?
A. The table will be distributed by row hash. B. Data blocks will be stored on random AMPS. C. The primary key would default to the first column. D. FastLoad I/O performance is the same as MultiLoad.
Correct Answer: D


QUESTION 118
What are two reasons to define a UPI rather than a NUPI on a SET table? (Choose two.)
A. To ensure even row distribution B. To minimize query answer set size C. To improve duplicate row checking performance D. To improve performance of queries using ranges
Correct Answer: BC


QUESTION 119
When using a mainframe-aftached computer, which software component serves as the interface between the Teradata Database and CLIv2?

  1. TDP B. MOSI C. MTDP D. BYNET
    Correct Answer: B


    QUESTION 120
    Which two functionalities are available through the BTEQ tool? (Choose two.)
    A. Supports ad hoc queries B. Is checkpoint restartable C. Utilizes ODBC connectivity D. Runs scripted batch queries E. Uses command-line only interface
    Correct Answer: CD


QUESTION 121
Which two support multilevel partitioned primary indexes? (Choose two.)
A. NoPltables B. permanent tables C. column-partitioned tables D. non-compressed join indexes
Correct Answer: CD


QUESTION 122
What are two benefits of the Teradata database? (Choose two.)
A. There are special versions tuned for the appliances. B. It automatically detects and recovers from software failures. C. It guarantees linear performance for cursor-based processing. D. It provides centralized management and control regardless of system size. E. It can be accessed by either channel-attached or network-attached systems.
Correct Answer: AB


QUESTION 123
Which two will occur when a node fails in a system with a hot standby node? (Choose two.)
A. PE Vdisks migrate for fiber attached connections. B. PE Vprocs migrate for channel attached connections. C. Vproc migration occurs for AMPs on the failed node. D. A restart is required to bring the hot standby node into the configuration. E. A restart is required to bring the recovered node back into the configuration.
Correct Answer: BC


QUESTION 124
Which two communication interfaces can FastLoad use? (Choose two.)
A. CLIv2 B. JDBC

 

  1. ODBC D. OLEDB
    Correct Answer: BD


QUESTION 125
Which two components or features in the Teradata architecture influence scalable parallelism? (Choose two.)
A. BYNET B. AMP migration C. data distribution D. Parsing Engine (PE)
Correct Answer: AB

QUESTION 126
What are two benefits achieved with an Active Enterprise Data Warehouse? (Choose two.)
A. Timely availability of data B. Integrated view of the data C. Single copy of each transaction D. Actively load large volumes of data during production hour