Topic 1 Question 17

Associate Cloud Engineer

Topic 1 Question 17
You are analyzing Google Cloud Platform service costs from three separate projects. You want to use this information to create service cost estimates by service type, daily and monthly, for the next six months using standard query syntax. What should you do?
- Export your bill to a Cloud Storage bucket, and then import into Cloud Bigtable for analysis.
- Export your bill to a Cloud Storage bucket, and then import into Google Sheets for analysis.
- Export your transactions to a local file, and perform analysis with a desktop tool.
- Export your bill to a BigQuery dataset, and then write time window-based SQL queries for analysis.
ユーザの投票
コメント(17)
- Solving this by first eliminating the options that don't suit us. By breaking down the question into the key requirements-
  
  Analyzing Google Cloud Platform service costs from three separate projects.
  
  Using standard query syntax. -> (Relational data and SQL)
  
  A. 'Cloud Storage bucket'........'Cloud Bigtable'. Not feasible, mainly because cloud BigTable is not good for Structured Data (or Relational Data on which we can run SQL queries as per the question's requirements). BigTable is better suited for Semi Structured data and NoSQL data. B. 'Cloud Storage bucket'.....'Google Sheets'. Not Feasible because there is no use of SQL in this option, which is one of the requirements. C. Local file, external tools... this is automatically eliminated because the operation we need is simple, and there has to be a GCP native solution for this. We shouldn't need to rely on going out of the cloud for such a simple thing. D. 'BigQuery'.....'SQL queries' -> This is the right answer.
  👍 82
  mohdafiuddin2020/12/27
- Agreed, BigQuery
  
  👍 18
  cesar78162020/03/08
- 正解だと思う選択肢: D
  The correct answer is Option D. Exporting the bill to a BigQuery dataset allows you to use SQL queries to analyze the data and create service cost estimates by service type, daily and monthly, for the next six months. This is an efficient and effective way to analyze the data, especially if you are familiar with SQL syntax.
  
  Option A, importing the bill into Cloud Bigtable, may be more complex and may not offer the same level of flexibility as using SQL queries in BigQuery.
  
  Option B, importing the bill into Google Sheets, may be more suitable for simple analysis, but may not be as efficient for more complex analysis.
  
  Option C, exporting the transactions to a local file and using a desktop tool, may not be as efficient or effective as using a cloud-based solution like BigQuery.
  
  https://cloud.google.com/billing/docs/how-to/export-data-bigquery https://cloud.google.com/bigquery/docs/reference/standard-sql/
  
  👍 4
  Buruguduystunstugudunstuy2022/12/29
シャッフルモード

ユーザの投票

コメント(17)