Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A retail organization wants to share standardized daily inventory and sales metrics from BigQuery with hundreds of external vendor partners. The organization has established the following operational and governance requirements:
Which Google Cloud sharing mechanism should the organization implement?
Analytics Hub is a fully managed data exchange service built on top of BigQuery that allows organizations to securely discover, share, and govern datasets at scale across organizational and project boundaries.
Analytics Hub is purpose-built for multi-organization data sharing and data democratization. It eliminates the maintenance burden, synchronization latency, and storage replication costs associated with traditional file-based exports or direct table replication.
Database Migration Service (DMS) is a fully managed service designed to migrate relational databases (such as MySQL, PostgreSQL, and Oracle) to Cloud SQL or AlloyDB with minimal downtime.
You needed to migrate an on-premises PostgreSQL or MySQL transactional database into a managed Cloud SQL instance in Google Cloud.
This approach uses scheduled queries or export commands to extract BigQuery tables into flat files (such as CSV or JSON) and saves them into a Cloud Storage bucket configured with IAM read access for external partners.
The requirement specifically called for delivering raw, unmanaged files to external legacy platforms that do not use Google Cloud or SQL data warehouses.
This approach applies direct Identity and Access Management (IAM) dataset-level permissions (roles/bigquery.dataViewer) to external user accounts or Google Groups within the publisher's GCP project.
You needed to quickly grant ad-hoc, internal query permissions to a single colleague or internal service account within the same organization.
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