Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

Teradata NR0-015 Exam -

Free NR0-015 Sample Questions:

1. When creating an identity column as GENERATED ALWAYS, which statement is true?
A. The column may be used in a join index.
B. The column may be updated by an SQL statement.
C. The column may be used to define the primary index.
D. The column is used to facilitate copying data from one table into another.
Answer: C

2. What type of query population benefits from a sparse index?
A. queries that often redistribute a large table
B. queries that repeatedly use the same subset of the table
C. queries that rarely redistribute a large table in complex join processing
D. queries that often return a large percent of the rows of a large table based on the primary key
E. queries that often eliminate a large percent of the rows of a large table using a superset of the table
Answer: B

3. Which utility supports multiple sources of data coming from multiple platforms concurrently?
B. MultiLoad
C. FastLoad
D. Teradata Warehouse Builder
Answer: D

4. How will a query be affected when run against a table without Fallback if an AMP is down?
A. The query will not execute under these conditions.
B. The query will execute and return data from all AMPs.
C. The query will execute only if it does not require data from the down AMP.
D. The query will always execute and return data from only the AMPs that are available.
Answer: C

5. In which three situations can a backup of your entire database using the ARC utility provide adequate data protection? (Choose three.)
A. when there is a loss of data on an AMP for non-Fallback tables
B. when there are accidentally dropped tables, views, or macros
C. when there is a loss of the data on multiple AMPs within the same cluster
D. when global temporary tables are in use at the time of the archive operation
Answer: ABC

6. Why is it important to have columns follow consistent data types administered at the domain level? (Choose two.)
A. avoids data conversions
B. reduces data redistribution
C. eliminates data compression
D. eliminates need for constraints
E. reduces data storage requirements
Answer: AB

7. When designing a Teradata table, what two data demographics should be considered? (Choose two.)
A. nulls per row
B. nulls per column
C. numeric columns per row
D. rows per value in a column
E. number of character columns per row
Answer: BD

8. Which three factors are considered when choosing a column as a primary index? (Choose three.)
A. sample data
B. distinct values
C. frequency of change
D. minimum rows per value
E. maximum rows per value
Answer: BCE

9. Which three factors are considered when choosing a column as a primary index? (Choose three.)
A. data type
B. frequency of access
C. stability of the data values
D. distribution across the AMPs
Answer: BCD

10. Which two factors are considered in Usage Demographics of a column? (Choose two.)
A. frequency of change
B. frequency of loading data
C. frequency of join access in SQL queries
D. frequency of value access in SQL queries
Answer: CD

11. When analyzing volatility as a factor for choosing indexes, what are you measuring?
A. how unique the column values are
B. how frequently the column value changes
C. how frequently the column is used for access
D. the difference between the maximum and minimum values
Answer: B

12. Referential Integrity (RI) is defined on a table WITH CHECK option. An implicit transaction with multiple inserts is submitted against the table.
What happens when one insert violates the RI?
A. All the rows inserted are rolled back and an abort message is issued.
B. An error table is created with a copy of offending column(s) that violated RI.
C. All rows are inserted. An error message informs the user of which row is the problem row that needs to be fixed.
D. All rows except the one violator are inserted. An error message informs the user which row did not get inserted.
Answer: A

13. A row is inserted into a referencing table and foreign key columns are defined to be NOT NULL.
What does the system verify?
A. It verifies if a row exists in the referenced table that is NOT NULL.
B. It verifies if a row exists in the reference index subtable with a zero count.
C. It verifies if a row exists in the referenced table with the same value(s) as that in the foreign key column(s).
D. It verifies if a row exists in the referenced table with the same values as those in the primary key of the referencing table.
Answer: C

14. Which two statements are true for "soft" Referential Integrity (RI)? (Choose two.)
A. The RI is enforced by the database.
B. The RI is presumed to be enforced outside of the database.
C. Redundant joins between soft RI defined tables are eliminated.
D. The PK columns can appear anywhere in the WHERE clause.
Answer: BC

15. Which three rules apply to a column defined as a foreign key in the referencing table compared to the primary key in the referenced table? (Choose three.)
A. The data type must be the same.
B. The case sensitivity must be the same.
C. The compression values must be the same.
D. No column in the foreign key (referencing) can be an identity column.
Answer: ABD

16. What are two reasons for choosing a NUPI? (Choose two.)
A. It allows clustering of data rows.
B. It allows duplicate rows in a set table.
C. It is a closer match for the primary key.
D. It allows the user to generate a much larger table.
E. It facilitates AMP-local joins of matching sets.
Answer: AE

17. Which two statements are true for primary keys as compared to primary indexes? (Choose two.)
A. The data values may not be null.
B. The data values may change over time.
C. The first objective is to control row distribution.
D. They are logical constructs which ensure uniqueness.
Answer: AD

18. What are two reasons for the primary index columns to be different from the primary key columns? (Choose two.)
A. join performance
B. to increase volatility
C. known access paths
D. to enforce uniqueness
Answer: AC

19. What are two characteristics of highly non-unique primary index values? (Choose two.)
A. maximize parallel processing
B. cause efficient distribution among AMPs
C. cause multiple data blocks to be used and incur multiple I/Os
D. cause database full condition on AMPs where excessive number of rows are stored
Answer: CD

20. What are three criteria in choosing a primary index? (Choose three.)
A. must be primary key
B. volatility of data values
C. reasonable distribution
D. must ensure row uniqueness
E. most frequently accessed column(s)
Answer: BCE

21. Joining tables on their primary index allows the Optimizer to choose which three highly effective join plans? (Choose three.)
A. Hash Join
B. Cross Join
C. Merge Join
D. Nested Join
E. Product Join
Answer: ACD

22. Which statement is true of row inserts into a table with an identity column?
A. Serialization is guaranteed.
B. Numbering gaps can occur.
C. Generated numbers reflect row insertion sequence.
D. Values will be unique if the GENERATED BY DEFAULT option is used.
Answer: B

23. When would you use identity columns? (Choose three.)
A. when more even data distribution is needed
B. to reduce the need to generate keys outside of Teradata
C. to facilitate moving applications from other systems to Teradata
D. when users need key values with hidden significance or intelligence
Answer: ABC

24. What are two performance benefits of using global temporary tables? (Choose two.)
A. They share data between user sessions.
B. They allow reuse of intermediate results.
C. Referential Integrity rules can be enforced.
D. There are no locks placed on any objects when they are materialized or dropped.
Answer: BD

25. Which type of table allows sharing of data across user sessions?
A. derived
B. volatile
C. permanent
D. global temporary
Answer: C

26. Which two statements are true about a dimensional data model? (Choose two.)
A. It is extremely flexible.
B. It often implements fewer tables.
C. It requires significantly less ETL activity.
D. It reduces the need for summary tables.
E. It can be adapted to optimize performance.
Answer: BE

27. Which three statements are true about data compression? (Choose three.)
A. CPU path length associated with the I/Os saved is substantial.
B. It reduces the overhead for storing variable character data.
C. The actual uncompressed values are stored in the table header.
D. It can achieve substantial reduction of space for both numeric and character data.
Answer: ACD

28. What are two reasons for considering Partitioned Primary Index (PPI) on a table? (Choose two.)
A. to reduce the amount of I/O needed to process queries
B. to reduce the number of columns in a table to those needed by most queries
C. to eliminate ranges of data values from a query and thereby reduce scan time
D. to reduce response time by placing all data in the same partition on the same AMP
Answer: AC

© 2014, All Rights Reserved