Question: A query is how you retrieve information from a database, so which of these paths demonstrates the journey of a query?
- Table with Data > Query > Database
- Query > Table with Data > Database
- Table with Data > Database > Query
- Query > Database > Table with Data
Explanation
A query is the request sent to a database to retrieve matching information. The database evaluates the request against stored data structures. Results are returned from the relevant table or tables that contain the requested data. This sequence reflects the basic data access pattern used by SQL-based services such as BigQuery.
Why the other options are incorrect
Table with Data > Query > Database starts with stored data instead of the retrieval request.
Query > Table with Data > Database skips the database layer that evaluates the request.
Table with Data > Database > Query places the query after the data source, which reverses the retrieval flow.
Source for verification
https://cloud.google.com/bigquery/docs/introduction
https://cloud.google.com/bigquery/docs/running-queries
The answer(s) to the question is highlighted in the BOLD text above. You can also find more questions and answers related to the exams on the "Google Cloud Platform Business Professional" page.