WorksheetsData Version 298-308
Total questions: 10
Worksheet time: 10mins
You need to fix the problem to resume the migration process. What should you do?
You need to connect multiple applications with dynamic public IP addresses to a Cloud SQL instance. You configured users with strong passwords and enforced the SSL connection to your Cloud SQL instance. You want to use Cloud SQL public IP and ensure that you have secured connections. What should you do?
Add CIDR 0.0.0.0/0 network to Authorized Network. Use Identity and Access Management (IAM) to add users.
Add all application networks to Authorized Network and regularly update them.
Leave the Authorized Network empty. Use Cloud SQL Auth proxy on all applications.
Add CIDR 0.0.0.0/0 network to Authorized Network. Use Cloud SQL Auth proxy on all applications.
You are preparing an organization-wide dataset. You need to preprocess customer data stored in a restricted bucket in Cloud Storage. The data will be used to create consumer analyses. You need to comply with data privacy requirements.
What should you do?
What should you do?
You are managing a Dataplex environment with raw and curated zones. A data engineering team is uploading JSON and CSV files to a bucket asset in the curated zone but the files are not being automatically discovered by Dataplex. What should you do to ensure that the files are discovered by Dataplex?
Move the JSON and CSV files to the raw zone.
Enable auto-discovery of files for the curated zone.
Use the bg command-line tool to load the JSON and CSV files into BigQuery tables.
Grant object level access to the CSV and JSON files in Cloud Storage.
What data model should you use?
You currently have transactional data stored on-premises in a PostgreSQL database. To modernize your data environment, you want to run transactional workloads and support analytics needs with a single database. You need to move to Google Cloud without changing database management systems, and minimize cost and complexity. What should you do?
Migrate and modernize your database with Cloud Spanner.
Migrate your workloads to AlloyDB for PostgreSQL.
Migrate to BigQuery to optimize analytics.
Migrate your PostgreSQL database to Cloud SQL for PostgreSQL.
You want to ensure that there is minimal latency when reading the data. What should you do?
What should you do?
