Answer-first summary for fast verification
Answer: Go to Data Catalog and search for employee_ssn in the search box.
The correct answer is A: Go to Data Catalog and search for employee_ssn in the search box. Data Catalog is a fully managed and scalable metadata management service that allows quick discovery and management of data within Google Cloud. It provides an easy-to-use search interface for data discovery, making it the most efficient and least effortful approach for finding the employee_ssn column across multiple datasets and projects. Other options, like writing scripts or using Cloud Dataflow, are more time-consuming and error-prone.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company utilizes Google BigQuery for its data warehousing needs. Over the years, various business units within the organization have generated more than 1000 datasets spanning across hundreds of projects. The Chief Information Officer (CIO) has requested that you review all these datasets to identify tables that include a column named employee_ssn. You aim to complete this task with minimal effort. What approach should you take?
A
Go to Data Catalog and search for employee_ssn in the search box.
B
Write a shell script that uses the bq command line tool to loop through all the projects in your organization.
C
Write a script that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find the employee_ssn column.
D
Write a Cloud DataFlow job that loops through all the projects in your organization and runs a query on INFORMATION_SCHEMA.COLUMNS view to find employee_ssn column.
No comments yet.