Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
Your organization uses a custom on-premises visualization tool to generate business intelligence reports. The tool currently connects to relational databases using standard SQL protocols and does not natively support the BigQuery API.
You need to integrate this tool with BigQuery to analyze large datasets. Security policies mandate that the connection must not traverse the public internet, and BigQuery resources must be protected from data exfiltration by restricting access strictly to your hybrid network environment.
How should you securely integrate the on-premises tool with BigQuery?
This approach uses the BigQuery Data Transfer Service to export data out of Google Cloud and into a local on-premises database, allowing the BI tool to query the data locally.
The organization had a strict regulatory requirement that all analytical data must physically reside in an air-gapped on-premises data center, and they only used BigQuery for temporary upstream processing before downloading the final results.
The Simba JDBC and ODBC drivers for BigQuery allow legacy or custom applications that rely on standard SQL protocols to connect to BigQuery without requiring native API integration. Private Google Access (or Private Service Connect) allows on-premises networks connected via Cloud VPN or Cloud Interconnect to reach Google APIs using internal IP addresses. VPC Service Controls creates a secure perimeter around Google Cloud resources to mitigate data exfiltration risks.
This architecture seamlessly integrates legacy BI tools with modern cloud data warehouses while adhering to strict zero-trust and private networking mandates. It leverages purpose-built drivers for application compatibility and native Google Cloud networking security controls to ensure end-to-end protection.
This approach correctly identifies the use of JDBC/ODBC drivers but attempts to use VPC Network Peering and Identity-Aware Proxy (IAP) for network routing and security.
The organization needed to connect an on-premises network to a custom internal web application hosted on a Compute Engine VM in a peered VPC, and wanted to enforce user-level authentication via IAP.
This approach involves rewriting the custom visualization tool to natively call the BigQuery REST API and attempting to secure the public endpoint using IP allowlisting via Google Cloud Armor.
The organization was building a brand-new web application deployed on a Google Cloud Load Balancer and needed to protect the frontend from DDoS attacks while querying BigQuery in the backend over the internet.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated