4.1 Preparing Data for Visualization PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   A data analyst frequently creates dashboards that compute the ratio of revenue to number of orders for each product. The calculation is complex and used in many queries. What is the best way to simplify the dashboard queries and ensure consistency?

   • AUse a calculated field in the BI tool (e.g., Looker, Tableau) to define the ratio.
   • BCreate a materialized view that stores the ratio for each product.
   • CPrecompute the ratio in a separate table using a scheduled query.
   • DCreate a SQL view that computes the ratio and use it in the dashboard queries.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which data masking technique replaces a value with a consistent, non-reversible substitute, such as replacing a credit card number with a token?

   • AEncryption
   • BTokenization
   • CRedaction
   • DMasking
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A financial services company runs a daily report that aggregates transactions by customer and month. The report is run by multiple analysts throughout the day, and each run scans the entire transactions table, which is large and costly. The team wants to reduce cost and improve performance for these repeated queries. What is the most effective solution?

   • APartition the transactions table by transaction date.
   • BUse BigQuery BI Engine to cache the transactions table.
   • CCreate a materialized view that precomputes the monthly customer aggregates.
   • DCreate a regular view that encapsulates the aggregation query.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A data analyst wants to connect Tableau Desktop to BigQuery to build interactive dashboards. Which authentication method is commonly used for this connection?

   • AUsername and password
   • BOAuth 2.0
   • CAPI key
   • DService account key
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A healthcare company uses Data Studio to create dashboards for different departments. The data engineering team wants to ensure that each department can only see data for its own patients. They have a single BigQuery dataset with a table containing all patient records. What is the most appropriate way to control access?

   • ACreate a separate dataset for each department and copy the relevant rows into each.
   • BCreate a separate view for each department that filters by department ID, and grant each department's service account access to only its view.
   • CUse BigQuery column-level security to restrict access to the department ID column.
   • DGrant each department's service account the BigQuery Data Viewer role on the entire table.
   Reveal Solution Discussion Select an answer first