What Are Two Methods That Can Be Used to Denormalize

question 17

Multiple Choice

What are two methods that can be used to denormalize tables in BigQuery?

• A) 1) Split table into multiple tables; 2) Use a partitioned table
• B) 1) Join tables into one table; 2) Use nested repeated fields
• C) 1) Use a partitioned table; 2) Join tables into one table
• D) 1) Use nested repeated fields; 2) Use a partitioned table

---

Definitions:

Unilateral Control

The exclusive power or authority one entity or country holds over another, without requiring consent or cooperation from the latter.

Significant Influence

The power to participate in the financial and operating policy decisions of an investee, without having control over those policies.

Fair Value

The price that would be received to sell an asset or paid to transfer a liability in an orderly transaction between market participants at the measurement date.

Jointly Controlled Operation

A joint operation where the parties that have joint control of the operation have rights to the assets, and obligations for the liabilities, relating to the arrangement.