exam questions

Exam Associate Cloud Engineer All Questions

View all questions & answers for the Associate Cloud Engineer exam

Exam Associate Cloud Engineer topic 1 question 96 discussion

Actual exam question from Google's Associate Cloud Engineer
Question #: 96
Topic #: 1
[All Associate Cloud Engineer Questions]

Your company implemented BigQuery as an enterprise data warehouse. Users from multiple business units run queries on this data warehouse. However, you notice that query costs for BigQuery are very high, and you need to control costs. Which two methods should you use? (Choose two.)

  • A. Split the users from business units to multiple projects.
  • B. Apply a user- or project-level custom query quota for BigQuery data warehouse.
  • C. Create separate copies of your BigQuery data warehouse for each business unit.
  • D. Split your BigQuery data warehouse into multiple data warehouses for each business unit.
  • E. Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project.
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
CPBach
Highly Voted 4 years, 2 months ago
I'd say B and E. So either you do B or E to reduce costs.
upvoted 46 times
KC_go_reply
1 year, 5 months ago
The question says 'which two methods should you use', implying that you want to use *both*. Using quotas together with the flat-rate pricing doesn´t make any sense. Besides that, E is wrong imo. Why? Because flat-rate pricing is very expensive, you pay a fixed high price for something that likely won´t be used enough by the average business unit. You need to allocate different 'slots' which is inflexible and complex. It would make more sense to rely on quotas, which means you have an upper limit for costs, but don´t necessarily pay the maximum.
upvoted 1 times
...
...
Jignesh_Gamdha
Highly Voted 3 years, 10 months ago
B & E Refer below link - first of all you can define quotas on project or user level and 2nd one is you can change from on demand to flat rate model and define the parameters based on your requirement --- https://cloud.google.com/bigquery/docs/custom-quotas https://cloud.google.com/bigquery/pricing#flat_rate_pricing
upvoted 25 times
...
Jayz1992
Most Recent 2 months, 1 week ago
Selected Answer: BE
Flat-rate pricing Note: The BigQuery flat-rate pricing model is no longer offered as of July 5, 2023. It is described here for customers who have existing flat-rate commitments. this is from official Google cloud documentation page
upvoted 1 times
...
dgmon174
7 months, 4 weeks ago
What happens if you only choose one here? Do you get half the points of 0 points?
upvoted 1 times
...
BAofBK
10 months ago
The correct answer is BE
upvoted 1 times
...
Captain1212
1 year ago
Selected Answer: BE
BE seems more legit
upvoted 1 times
...
Neha_Pallavi
1 year ago
BE is correct Answer
upvoted 1 times
...
FCADAM
1 year ago
B, after reading the specs of BigQuery pricing. C and E doesn't meet the cost requirements. E, Google is no longer offering the flat-rate anymore. E, doesn't meet the criteria and B offers the option to set User-level and project-level custom cost controls.
upvoted 3 times
...
danieeerll
1 year ago
Flat rate is no longer available for Big Query.
upvoted 5 times
...
kasperm
1 year, 1 month ago
BigQuery Flat-Rate Model is no longer sold as of July 5, 2023 "Only available to customers with fixed priced flat-rate prior to end of sale" https://cloud.google.com/bigquery/pricing
upvoted 4 times
...
_F4LLEN_
1 year, 3 months ago
Anyone who needs the full PDF message me @dive_into_dev Instagram.
upvoted 2 times
...
_F4LLEN_
1 year, 4 months ago
Inorder to get the rest of questions you can type" Google cloud Ace exam question 97" in Google and get it.till 197 is there I guess
upvoted 2 times
pritampanda1988
1 year, 4 months ago
That's not right. I have got contributor access and I can assure that this is not the way you can get all the questions and answers.
upvoted 2 times
...
...
SoumyaRM
1 year, 5 months ago
BE BOTH ARE CORRECT
upvoted 1 times
...
RIZI23
1 year, 5 months ago
Hi guys, I am sitting this exam next Monday, Is it possible that anyone can email me the rest of the questions - [email protected] I would really appreciate it!!!
upvoted 1 times
...
Cecilia_33
1 year, 6 months ago
Dear friends, I am wondering if anyone could kindly send the rest of the questions as pdf to my email: [email protected] Thank you!
upvoted 1 times
...
Buruguduystunstugudunstuy
1 year, 6 months ago
Selected Answer: BE
The two methods that should be used to control BigQuery query costs are: B. Apply a user- or project-level custom query quota for BigQuery data warehouse: Setting a custom query quota will limit the amount of data a user or project can query within a given period, which helps in controlling costs. E. Change your BigQuery query model from on-demand to flat rate. Apply the appropriate number of slots to each Project: With a flat-rate pricing model, the user pays a fixed monthly fee based on the number of slots used. This enables better cost control and also ensures better query performance as the slots are reserved for the user's exclusive use. Answers A, C, and D are not recommended as they would require a lot of effort and maintenance for managing multiple projects or data warehouses.
upvoted 5 times
...
GabrielDr
1 year, 6 months ago
B and E seem to be correct.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago