|
Question 1.
What would be an alternative archive method for a table that takes too long to execute a full archive?
A. BTEQ Export
B. use Fast Export to unload the data and Fast Load to reload the data
C. cluster data table archive with a full archive of the Data Dictionary
D. cluster data table archive
Answer: C
Question 2.
In which of the following situations should you consider using value-ordered NUSIs?
A. when you have a high number of concurrent queries
B. when you have a high number of updated rows
C. when you have a high number of joins in queries
D. when you have a high number of range constraint queries
Answer: D
Question 3.
When you are com paring Multi Load and TPump, which are three statements that you find to be true? (Choose three.)
A. Multi Load uses table locks; TPump uses row hash locks.
B. Multi Load uses multiple statement requests to improve performance; TPump uses multiple
sessions to improve performance.
C. Multi Load updates tables from a work table; TPump updates tables from CLI parcels directly.
D. Multi Load performs better as volume of changes increases; TPump performs better on low
volume of changes.
Answer: A, C, D
Question 4.
You are a database administrator at Com pany.com who is using the Statistics Wizard.
From which two of the following can you define a workload? (Choose two.)
A. DBQL statements
B. workload monitor
C. TDQM statements
D. statement text
Answer: A, D
Question 5.
When you choose a primary index, what are three requirements that must be met?
(Choose three.)
A. volatility of data values
B. must be primary key
C. must ensure row uniqueness
D. most frequently accessed column(s)
E. reasonable distribution
Answer: A, D, E
Question 6.
You are a Teradata administrator at Com pany.com .
What are two questions you must consider when organizing the system into databases?
(Choose two.)
A. How frequently are the archives of the tables needed?
B. Which views are needed to have extended privileges such as update and delete?
C. Which views are needed to be used by the same users?
D. Which users will be doing the Fast Loads of multiple tables?
Answer: B, C
Question 7.
The primary index columns will differ from the primary key columns for what two reasons?
(Choose two.)
A. known access paths
B. join performance
C. to increase volatility
D. to enforce uniqueness
Answer: A, B
Question 8.
Which of the following is a characteristic of Permanent Journals?
A. Permanent Journals allow you to create and store comments using the COM MENT ON
statement.
B. Permanent Journals (AFTER images) allow the user to recover changes lost when tables are
restored.
C. Permanent Journals may be used to roll back or roll forward changes after an ALTER TABLE
operation.
D. Permanent Journals (BEFORE and AFTER images) may be used to roll back or roll forward
changes after a RENAME TABLE operation.
Answer: B
Question 9.
Which are two available options when tuning for tactical queries in Priority Scheduler?
(Choose two.)
A. place the users submitting tactical queries in Allocation Groups with the highest weight
B. place the users submitting tactical queries in Resource Partition 0
C. place the users submitting tactical queries in Allocation Group 0
D. reserve AMP Worker Tasks for tactical queries
Answer: A, D
Question 10.
When writing update applications, which are three areas that should be taken into consideration?
(Choose three.)
A. number of mini-cyl packs performed
B. processing window
C. spool space limits for external users
D. when users are accessing the data
E. data timeliness requirements
Answer: B, D, E
Question 11.
Which are two features of the Multi Load utility? (Choose two.)
A. Up to ten tables can be specified in a single execution.
B. The upset function is supported.
C. Insert, update, and delete are all supported.
D. It uses macros to improve performance.
E. The processing rate can be controlled.
Answer: B, C
Question 12.
Which two of the following statements are correct in relation to data marts? (Choose two.)
A. Dependent data marts are isolated entities entirely separate from the enterprise data
warehouse.
B. A data mart is generally a relatively small application-specific subset of the data warehouse.
C. A logical data mart is a form of dependent data mart that is constructed virtually from the
physical data warehouse.
D. Independent data marts are derived from the enterprise data warehouse.
Answer: B, C
Question 13.
A Partitioned Primary Index (PPI), NUSIs, and a USI is defined on Table X. which two of the following can you employ for daily maintenance? (Choose two.)
A. Multi Load
B. TPump
C. Fast Load into an empty Table Y, then INSERT/SELECT into Table X
D. Teradata Warehouse Builder Load Operator
Answer: B, C
Question 14.
Which three of the following should be included in an analysis that defines TDQM restrictions?
(Choose three.)
A. a list of users whose access must be above restriction
B. a listing of the requirements for critical applications and the times of day that are most critical
C. the client resources available during the peak periods
D. an understanding of the timing requirements for maintenance of specific tables or databases
E. a projection of the growth pattern for major tables in the database
Answer: A, B, D
Question 15.
What are you calculating when you analyze volatility as a factor for selecting indexes?
A. how unique the column values are
B. how frequently the column value changes
C. the difference between the maximum and minimum values
D. how frequently the column is used for access
Answer: B
Question 16.
An empty target table is required by which two utilities when loading data? (Choose two.)
A. Fast Export
B. Fast Load
C. Multi Load
D. Teradata Warehouse Builder Load operator
Answer: B, D
Question 17.
A RAID configuration for system availability has what advantage?
A. If a node fails, the AMPs running on that node migrate to the other nodes in a different clique.
B. If a single drive fails, work can proceed because the disk controller can reconstruct the data.
C. If multiple drives fail in the same drive group, work can proceed using the redundant copies.
D. A disk array cabinet failure does not interrupt operation since RAID forces redundancy across
RAID cabinets.
Answer: B
Question 18.
If you are defining Roles in Teradata, what are two questions that you should ask yourself?
(Choose two.)
A. Will this user need more than just SELECT access to the data?
B. From which network path will this user access Teradata?
C. What characteristics are important for this user's password controls?
D. Will this user be assigned to perform more than one job function?
Answer: A, D
Question 19.
For which two reasons would you choose a NUPI? (Choose two.)
A. It allows clustering of data rows.
B. It facilitates AMP-local joins of matching sets.
C. It is a closer match for the primary key.
D. It allows the user to generate a much larger table.
E. It allows duplicate rows in a set table.
Answer: A, B
Question 20.
Fast Export is best described by which three of the following? (Choose three.)
A. exports from multiple tables
B. uses Support Environment
C. uses multiple sessions
D. exports data to multiple files without use of OUTMOD
Answer: A, B, C
|
Question 1. Which of the following memory types has a clock speed of 400MHz? A. PC133 B. PC2700 C. PC3200 D. PC10600 Answer: C Explanation: Question 2. A technician receives a Windows laptop that has not been operating correctly since a user changed some registry settings by mistake. Which of the following should be attempted FIRST? A. Reset the CMOS B. Rollback to a restore point C. Boot into Safe Mode D. Reconfigure the BIOS Answer: B Explanation: Question 3. A technician encounters an IP address of 191.15.20.1. The IP address is a member of which of the following classes? A. Class A B. Class B C. Class C D. Class D Answer: B Explanation: Question 4. Which of the following cables allows for the transfer of video and sound? A. VGA B. S-Video C. DVI D. HDMI Answer: D Explanation: Question 5. Which of the following is placed directly on the CPU in a new computer system to aid in the cooling process? A. Heatsink B. Fan C. Liquid cooling system D. Thermal compound Answer: D Explanation: Question 6. When determining a customer's specific issue, which of the following is the BEST approach? A. Ask the customer to speak with someone else that may be able to help. B. Ask open-ended questions to narrow the scope of the problem. C. Ask a co-worker what the customer is trying to explain. D. Ask focused questions that lead the customer with yes or no answers. Answer: B Explanation: Question 7. Which of the following printer types is the BEST for a technician to recommend to a company needing to print 10,000 black and white pages per month? A. Laser B. Thermal C. Inkjet D. Dot Matrix Answer: A Explanation: Question 8. Which of the following keyboard combinations will lock a Windows XP workstation? A. Windows Key + L B. CTRL + ALT + Delete C. Windows Key + CTRL + Backspace D. Windows Key + CTRL + Escape Answer: B Explanation: Question 9. A customer wants to be able to search the Internet wirelessly with their laptop, from any location. Which of the following devices would be MOST effective in achieving this? A. Bluetooth card B. 802.11 a/b/g WiFicard C. 802.11n WiFi card D. Cellular WAN card Answer: D Explanation: Question 10. A customer wants to connect an external projector to a laptop. The projector is plugged into the external video port but no video is shown on the projector. Which of the following will correct the problem? A. Upgrade the BIOS. B. Release the LCD cutoff switch. C. Toggle the WiFi switch. D. Toggle the Fn key. Answer: D Explanation:
Copyright © 2004 CertsBraindumps.com Inc. All rights reserved.