GCP Professional Data Engineer Questions and Answers Rated A

Document Content and Description Below

GCP Professional Data Engineer 1. You are developing an application that will only recognize and tag specific business to business product logos in images. You do not have an extensive background w... orking with machine learning models, but need to get your application working. What is the current best method to accomplish this task? 2. Your organization is streaming telemetry data into BigQuery for long-term storage (2 years) and analysis, at the rate of about 100 million records per day. They need to be able to run queries against certain time periods of data without incurring the costs of querying all available records. What is the preferred method for doing so? 3. You are an administrator for several organizations in the same company. Each organization has data in their own BigQuery table within a single project. For application access reasons, all of the tables must remain in the same project. You think each organization should be able to view and run queries against their own data without exposing the data of organizations to unauthorized viewers. What should you recommend? 4. Your company is making the move to Google Cloud and has chosen to use a managed database service to reduce overhead. Your existing database is used for a product catalog that provides real-time inventory tracking for a retailer. Your database is 500 GB in size. The data is semi-structured and does not need full atomicity. You are looking for a truly no-ops/serverless solution. What storage option should you choose? 5. How can you set up your Dataproc environment to use BigQuery as an input and output source? 6. In AI Platform, what does the CUSTOM tier allow you to configure? Choose the best answer. 7. You are building a data pipeline on Google Cloud. You need to prepare source data for a machine-learning model. This involves quickly deduplicating rows from three input tables and also removing outliers from data columns where you do not know the data distribution. What should you do? [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages