Preparing and using data for analysis
Practise only this domain. 74 questions with explanations, 20 at a time.
Start this domainSample questions
- A logistics manager wants a Looker Studio scorecard to reflect shipments as they land in a BigQuery table, with no manual steps in between. Which data source configuration should be chosen?Easy
- An orders table stores each order's line items as an ARRAY column inside a single row. An analyst needs one output row per line item, with the order ID repeated on each row. Which operator accomplishes this?Medium
- A retailer has three years of weekly sales history with yearly peaks around holidays and a gradual upward trend. The team needs a forecast of the next twelve weeks, produced entirely inside BigQuery. Which model should they train?Medium
- An analyst in BigQuery needs a trailing seven-day average of daily revenue for each row, keeping one output row per day. Which expression fits?Hard
- A data scientist building a BigQuery ML regression must rescale a numeric feature to the 0 to 1 range, and the same scaling must be applied automatically whenever the model scores new rows. Which approach achieves this?Medium
- A report statement computes the same expensive window-function subquery in three separate branches, and that work accounts for a large share of slot consumption. Which change reduces the total slot time?Medium
- A retailer's event table stores a TIMESTAMP for every hour of activity, and the finance team wants monthly totals. Which approach is the most efficient way to group the rows?Easy
- A bank drops CSV statements into a Cloud Storage bucket, and some files contain card numbers. The bank wants each new file inspected and sensitive values masked automatically as soon as it arrives. Which design does this?Medium
- A payroll table holds an employee salary column next to job title and department. Analysts should query the rest of the table but must receive an access denial when they select salary. Which configuration achieves this?Medium
- A streaming pipeline must not lose more than 0.1% of its input records. Which metric measures compliance with this requirement?Easy
- A team wants to make PDFs and web pages searchable by meaning for a retrieval-augmented generation assistant. The pipeline must extract the text, split it into passages, and produce vectors that a retriever can search. Which combination of Google Cloud capabilities fits?Medium
- A data engineer must restrict a shared BigQuery table so each analyst sees only the rows for regions assigned to them, with the assignment determined by the analyst's identity. Which BigQuery feature does this?Medium
- A company's business users need daily refreshed charts and reports built on warehouse data, delivered to their inboxes on a schedule without anyone rebuilding the visuals by hand. Which approach fits best?Easy