You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises.
You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?
A. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.
You are designing a database architecture for a global application that stores information about public parks worldwide. The application uses the database for read-only purposes, and a centralized batch job updates the database nightly. You want to select an open source, SQL-compliant database. What should you do?
You are running a transactional application on Cloud SQL for PostgreSQL in Google Cloud. The database is running in a high availability configuration within one region. You have encountered issues with data and want to restore to the last known pristine version of the database. What should you do?
Using import/export from last week is slow for large scale databases and will restore database from last week.
You want to migrate your PostgreSQL database from another cloud provider to Cloud SQL. You plan on using Database Migration Service and need to assess the impact of any known limitations. What should you do? (Choose two.)
An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?
To read data out of Cloud SQL for SQL Server, you need to use a service account with the roles/cloudsql.viewer role on the Cloud SQL instance. This role grants the service account permission to read data from the instance. Whereas roles/cloudsql.instanceUser will only allow to login to cloud SQL instance. No resource will be allowed to view.
Emily Brown
9 days agoRonald Lopez
11 days agoGary Mitchell
19 days agoMichelle King
22 days agoAshley Lee
1 month agoMagdalene
2 months agoEliz
2 months agoMarguerita
2 months agoShannan
3 months agoRolande
3 months agoLashonda
3 months agoLorriane
3 months agoAzzie
4 months agoDevorah
4 months agoFrancine
4 months agoEve
4 months agoMarylou
5 months agoJohnetta
5 months agoPercy
5 months agoShenika
5 months agoLeota
6 months agoSon
6 months agoMeghann
6 months agoDaniela
6 months agoNana
7 months agoShenika
7 months agoEric
7 months agoFelton
7 months agoAnjelica
8 months agoLindsey
8 months agoChauncey
8 months agoYasuko
8 months agoApolonia
8 months agoDean
9 months agoRupert
9 months agoRosalia
11 months agoSharen
12 months agoBettina
1 year agoKimberlie
1 year agoSherron
1 year agoRaelene
1 year agoFredric
1 year agoCarmela
1 year agoJerry
1 year agoAlaine
1 year agoDottie
1 year agoJame
1 year agoRebecka
1 year agoKeena
1 year agoRhea
1 year agoLinsey
1 year agoAlex
1 year agoJame
1 year agoGracie
1 year agoFelicitas
1 year agoDana
2 years agoTiara
2 years agoGerman
2 years agoBerry
2 years agoMaybelle
2 years agoLinn
2 years agoShayne
2 years agoDenise
2 years agoAntione
2 years agoJulie
2 years agoNathan
2 years agoKati
2 years agoLynelle
2 years agoStephen
2 years agoMelina
2 years agoPete
2 years agoSabine
2 years agoJamal
2 years agoLai
2 years agoAlpha
2 years agoDesiree
2 years agoReyes
2 years agoHelga
2 years agoAnnmarie
2 years ago