Topic 1 Question 93
Your company uses BigQuery for data warehousing. Over time, many different business units in your company have created 1000+ datasets across hundreds of projects. Your CIO wants you to examine all datasets to find tables that contain an employee_ssn column. You want to minimize effort in performing this task. What should you do?
Go to Data Catalog and search for employee_ssn in the search box.
Write a shell script that uses the bq command line tool to loop through all the projects in your organization.
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.
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.
ユーザの投票
コメント(17)
Its A.
👍 36poogcp2020/06/10Correct is A.
I tested on my account following this procedure: https://cloud.google.com/bigquery/docs/quickstarts/quickstart-web-ui?authuser=4 I created a data set and through Data Catalog I easily and effortlessly searched for the column name "gender"👍 29filco722020/07/23I am preparing for the GCP-ACE exam, I was able to access 96 questions only, if anyone has the entire questions please share them with my [email protected] address. Thanks in advance. I would be forever grateful.
👍 3CELx_122022/11/04
シャッフルモード