Its A.

Correct 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"

The best option to minimize effort in performing this task is A. Go to Data Catalog and search for employee_ssn in the search box. Google Cloud’s Data Catalog is a fully managed and scalable metadata management service that empowers organizations to quickly discover, manage, and understand all their data in Google Cloud. It offers a simple and easy-to-use search interface for data discovery. By searching for “employee_ssn” in the Data Catalog, you can quickly find all tables across all datasets and projects that contain this column. This approach is more efficient and requires less effort compared to writing and maintaining scripts or jobs. Please note that access to Data Catalog and the visibility of datasets, tables, and columns are subject to permissions and roles in IAM policy. Make sure you have the necessary permissions to view the metadata.

Can anyone able to send all questions, As I am getting upto 125 only . [email protected]. Thanks in advance

Data Catalog lets you search and tag entries such as BigQuery tables with metadata. Some examples of metadata that you can use for tagging include public and private tags, data stewards, and rich text overview. https://cloud.google.com/data-catalog/docs/tag-bigquery-dataset

I 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. I have exam on next week,pls share Thanks in advance. I would be forever grateful.

I will go for A

The correct answer is A

Answer is A, as it requires the less effort and other options are more time consuming and error prone

The most efficient approach to identify tables that contain an employee_ssn column in BigQuery would be to query the INFORMATION_SCHEMA.COLUMNS view, which provides metadata about all columns in all tables in a given dataset. Therefore, options C and D are both possible solutions. Option A, searching for the column name in Data Catalog, may not be efficient if there are too many datasets to search through manually. Option B, writing a shell script to loop through all the projects in your organization, may work, but it would require more effort and time than options C and D. Also, it would be more error-prone since the script would need to handle authentication and authorization, handle exceptions and errors, and collect the results. Therefore, options C and D are better choices, but option D, using Cloud Dataflow, might be overkill for this specific task. Option C, looping through all projects and querying INFORMATION_SCHEMA.COLUMNS view, is the simplest and most effective solution to minimize effort.

Can anyone send the entire question I am able to see till question 96 send at [email protected]

I 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. I have exam on next week,pls share Thanks in advance. I would be forever grateful.

Hi All, I have my GCP ACE exam scheduled for tomorrow. However, I am only being able to access 96 questions. Can anyone kindly share the entire list of questions as I have hardly anytime left before my exam. [email protected]. Thank you all so much

Can anyone send the entire question I am able to see till question 96 send at [email protected]

I have my exam tomorrow and I could only access 96 questions. If someone has the whole set of questions, can you please send it to [email protected]?

C is IMO the correct answer (https://stackoverflow.com/questions/68746567/big-query-find-all-column-name-containing-surname-across-all-tables)

Answer A is the correct answer. 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 you to discover, understand, and manage your data. It provides search functionality that allows you to search for datasets, tables, columns, and other metadata across your organization. Therefore, you can simply go to Data Catalog and search for "employee_ssn" in the search box to find all datasets that contain this column. This is the most efficient and straightforward solution to the problem. Answers B, C, and D are not ideal solutions. Answer B requires writing a shell script and using the bq command line tool to loop through all the projects, which is time-consuming and error-prone. Answer C requires writing a script that loops through all the projects and runs a query on INFORMATION_SCHEMA.COLUMNS view, which is also time-consuming and error-prone. Answer D involves writing a Cloud Dataflow job, which is unnecessary and OVERKILL for this simple task.