Free Professional-Data-Engineer Exam Braindumps

- (Exam Topic 6)
You work for a shipping company that uses handheld scanners to read shipping labels. Your company has strict data privacy standards that require scanners to only transmit recipients’ personally identifiable information (PII) to analytics systems, which violates user privacy rules. You want to quickly build a scalable solution using cloud-native managed services to prevent exposure of PII to the analytics systems. What should you do?

1. A. Create an authorized view in BigQuery to restrict access to tables with sensitive data.
2. B. Install a third-party data validation tool on Compute Engine virtual machines to check the incoming data for sensitive information.
3. C. Use Stackdriver logging to analyze the data passed through the total pipeline to identify transactions that may contain sensitive information.
4. D. Build a Cloud Function that reads the topics and makes a call to the Cloud Data Loss Prevention AP
5. E. Use the tagging and confidence levels to either pass or quarantine the data in a bucket for review.

Correct Answer: A

- (Exam Topic 6)
You work for a mid-sized enterprise that needs to move its operational system transaction data from an on-premises database to GCP. The database is about 20 TB in size. Which database should you choose?

1. A. Cloud SQL
2. B. Cloud Bigtable
3. C. Cloud Spanner
4. D. Cloud Datastore

Correct Answer: A

- (Exam Topic 1)
You want to use Google Stackdriver Logging to monitor Google BigQuery usage. You need an instant notification to be sent to your monitoring tool when new data is appended to a certain table using an insert job, but you do not want to receive notifications for other tables. What should you do?

1. A. Make a call to the Stackdriver API to list all logs, and apply an advanced filter.
2. B. In the Stackdriver logging admin interface, and enable a log sink export to BigQuery.
3. C. In the Stackdriver logging admin interface, enable a log sink export to Google Cloud Pub/Sub, and subscribe to the topic from your monitoring tool.
4. D. Using the Stackdriver API, create a project sink with advanced log filter to export to Pub/Sub, and subscribe to the topic from your monitoring tool.

Correct Answer: B

- (Exam Topic 6)
You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application’s interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?

1. A. Create groups for your users and give those groups access to the dataset
2. B. Integrate with a single sign-on (SSO) platform, and pass each user’s credentials along with the query request
3. C. Create a service account and grant dataset access to that accoun
4. D. Use the service account’s private key to access the dataset
5. E. Create a dummy user and grant dataset access to that use
6. F. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

Correct Answer: C

- (Exam Topic 2)
Flowlogistic’s CEO wants to gain rapid insight into their customer base so his sales team can be better informed in the field. This team is not very technical, so they’ve purchased a visualization tool to simplify the creation of BigQuery reports. However, they’ve been overwhelmed by all the data in the table, and are spending a lot of money on queries trying to find the data they need. You want to solve their problem in the most cost-effective way. What should you do?

1. A. Export the data into a Google Sheet for virtualization.
2. B. Create an additional table with only the necessary columns.
3. C. Create a view on the table to present to the virtualization tool.
4. D. Create identity and access management (IAM) roles on the appropriate columns, so only they appear in a query.

Correct Answer: C