👉Get Full PDF
| Question 76 What is the name of a column or field used to uniquely identify each row of a table? A. Primary key B. Foreign key C. Native key D. Unique key |
76. Click here to View Answer
Answer is (A) Primary key
Primary keys uniquely identify each row of a table, and match the foreign keys in related data tables.
| Question 77 Which of the following statements is NOT true regarding the use of merged tables instead of data models? A. Merging creates redundant data B. Merging uses more memory C. Merging uses more processing power D. Merging keeps metrics and dimensions in separate tables |
77. Click here to View Answer
Answer is (D) Merging keeps metrics and dimensions in separate tables
Merging data by pulling all the attributes into the fact table itself creates redundant data and utilizes significantly more memory and processing power than creating relationships between multiple small tables.
| Question 78 In a one-to-many relationship cardinality, what is the “many” attached to? A. Primary key B. Foreign key C. Index column D. Lookup table |
78. Click here to View Answer
Answer is (B) Foreign key
Cardinality refers to the uniqueness of values in a column, and whenever there is only one instance of each value, then it is a primary key, if there are many instances then it is a foreign key.
| Question 79 Which of the following statements is true regarding filter flow? A. By default, the filter direction will point from the “one” side of the relationship to the “many” side B. When you filter a table, the filter context is passed along to all related “downstream” tables. C. Filters cannot flow “upstream” D. All of the above |
79. Click here to View Answer
Answer is (D) All of the above
The filter directions (arrows) in each relationship will point from the “one” side of the relationship (lookups) to the “many” side (data) by default. When you filter a table, that filter context is passed along to all related “downstream” tables (following the direction of the arrow). Filters cannot flow “upstream” (against the direction of the arrow).
| Question 80 Which of these functions can be used to activate inactive relationships? A. RELATED B. RELATEDTABLE C. USERELATIONSHIP D. ACTIVATE |
80. Click here to View Answer
Answer is (C) USERELATIONSHIP
The USERELATIONSHIP function allows you to determine which relationship to use between to tables, including inactive relationships.