You work for a global financial services company that trades stocks 24/7. You have a Cloud SGL for PostgreSQL user database. You need to identify a solution that ensures that the database is continuously operational, minimizes downtime, and will not lose any data in the event of a zonal outage. What should you do?
You manage a large amount of data in Cloud Storage, including raw data, processed data, and backups. Your organization is subject to strict compliance regulations that mandate data immutability for specific data types. You want to use an efficient process to reduce storage costs while ensuring that your storage strategy meets retention requirements. What should you do?
You are migrating data from a legacy on -premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?
You created a customer support application that sends several forms of data to Google Cloud. Your application is sending: 1. Audio files from phone interactions with support agents that will be accessed during trainings. 2. CSV files of users’ personally identifiable information (Pll) that will be analyzed with SQL. 3. A large volume of small document files that will power other applications. You need to select the appropriate tool for each data type given the required use case, while following Google -recommended practices. Which should you choose?
You are designing an application that will interact with several BigQuery datasets. You need to grant the application’s service account permissions that allow it to query and update tables within the datasets, and list all datasets in a project within your application. You want to follow the principle of least privilege. Which pre -defined IAM role(s) should you apply to the service account?
Your company is setting up an enterprise business intelligence platform. You need to limit data access between many different teams while following the Google -recommended approach. What should you do first?
