ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam
Go to Exam

Exam Professional Cloud Database Engineer topic 1 question 17 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 17
Topic #: 1
[All Professional Cloud Database Engineer Questions]

You are building an application that allows users to customize their website and mobile experiences. The application will capture user information and preferences. User profiles have a dynamic schema, and users can add or delete information from their profile. You need to ensure that user changes automatically trigger updates to your downstream BigQuery data warehouse. What should you do?

  • A. Store your data in Bigtable, and use the user identifier as the key. Use one column family to store user profile data, and use another column family to store user preferences.
  • B. Use Cloud SQL, and create different tables for user profile data and user preferences from your recommendations model. Use SQL to join the user profile data and preferences
  • C. Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
  • D. Use Firestore in Datastore mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by fredcaram at Dec. 20, 2022, 8:02 p.m.

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
Submit Cancel
BenMS
Highly Voted 1 year, 7 months ago
Selected Answer: C
Dynamic schema indicates this is a NoSQL solution (ruling out Cloud SQL) and the application use case specifically suits Firestore (the question even refers to storing data in documents) as opposed to BigTable. Firestore in Native supports realtime client updates, which is needed for the analytics requirement: https://cloud.google.com/firestore/docs/firestore-or-datastore#feature_comparison
upvoted 6 times
...
dynamic_dba
Highly Voted 1 year, 7 months ago
C. A dynamic schema means the database backend cannot be relational. That eliminates B. No criteria is mentioned that would justify Bigtable (low latency or massive data volume), so eliminate A. That leaves Firestore options which make sense since it’s a NoSQL database. Since “website” and “mobile” are both mentioned in the question, Firestore in Native mode must be the correct answer.
upvoted 5 times
...
abhinav45852
Most Recent 9 months, 3 weeks ago
Selected Answer: A
Firestore in native mode and Bigtable both seems to be correct answer but weightage can be given to Bigtable on the basis of replication to BigQuery via change streams is easier.
upvoted 2 times
...
Shadab
1 year, 6 months ago
Selected Answer: C
Use Firestore in Datastore mode for new server projects. Firestore in Datastore mode allows you to use established Datastore server architectures while removing fundamental Datastore limitations. Datastore mode can automatically scale to millions of writes per second. Use Firestore in Native mode for new mobile and web apps. Firestore offers mobile and web client libraries with real-time and offline features. Native mode can automatically scale to millions of concurrent clients.
upvoted 3 times
...
pk349
1 year, 10 months ago
C: Use Firestore in Native mode, and store user profile data as a document. Update the user profile with preferences specific to that user and use the user identifier to query.
upvoted 2 times
...
GCP72
1 year, 10 months ago
Selected Answer: C
C is the correct Answer
upvoted 2 times
...
range9005
1 year, 10 months ago
Selected Answer: C
Firestore introduces new features such as: A new, strongly consistent storage layer A collection and document data model Real-time updates Mobile and Web client libraries . https://cloud.google.com/datastore/docs/firestore-or-datastore#in_native_mode
upvoted 3 times
...
fredcaram
1 year, 10 months ago
Selected Answer: C
Seems like a better use for firestore and since it needs to reflect changes downstream in real time the native one would be better.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago