Your Organization Has Been Collecting and Analyzing Data in Google

question 125

Multiple Choice

Your organization has been collecting and analyzing data in Google BigQuery for 6 months. The majority of the data analyzed is placed in a time-partitioned table named events_partitioned . To reduce the cost of queries, your organization created a view called events , which queries only the last 14 days of data. The view is described in legacy SQL. Next month, existing applications will be connecting to BigQuery to read the data via an ODBC connection. You need to ensure the applications can connect. Which two actions should you take? (Choose two.)

• A) Create a new view over events using standard SQL
• B) Create a new partitioned table using a standard SQL query
• C) Create a new view over events_partitioned using standard SQL
• D) Create a service account for the ODBC connection to use for authentication
• E) Create a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared "events"

---

Definitions:

Filing Jointly

Filing jointly refers to a tax filing status that allows married couples to combine their income and deductions on a single tax return, potentially leading to tax benefits.

Net Book Value

The value of an asset or liability according to a company's balance sheet, deducting depreciation or amortization.

Accumulated Depreciation

Accumulated depreciation is the total amount of depreciation expense that has been recorded against a fixed asset over its useful life to date.

Depreciation Expense

The allocation of the cost of a tangible fixed asset over its useful life, reflecting the consumption or wear and tear of the asset.