You want to archive data in Cloud Storage. Because some data is very sensitive, you want to use the ''Trust No One'' (TNO) approach to encrypt your data to prevent the cloud provider staff from decrypting your dat
a. What should you do?
Your companyâ€™s on-premises Apache Hadoop servers are approaching end-of-life, and IT has decided to migrate the cluster to Google Cloud Dataproc. A like-for-like migration of the cluster would require 50 TB of Google Persistent Disk per node. The CIO is concerned about the cost of using that much block storage. You want to minimize the storage cost of the migration. What should you do?
Your company is using WHILECARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:
# Syntax error : Expected end of statement but got â€œ-â€œ at [4:11]
age != 99
AND_TABLE_SUFFIX = â€˜1929â€™
Which table name will make the SQL statement work correctly?
You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the applicationâ€™s interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?
You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
The user profile: What the user likes and doesnâ€™t like to eat
The user account information: Name, address, preferred meal times
The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schem
a. Which Google Cloud Platform product should you use?