Associate-Data-Practitioner 무료 덤프문제 온라인 액세스

Your team is building several data pipelines that contain a collection of complex tasks and dependencies that you want to execute on a schedule, in a specific order. The tasks and dependencies consist of files in Cloud Storage, Apache Spark jobs, and data in BigQuery. You need to design a system that can schedule and automate these data processing tasks using a fully managed approach. What should you do?

• A.Create directed acyclic graphs (DAGs) in Cloud Composer. Use the appropriate operators to connect to Cloud Storage, Spark, and BigQuery.
• B.Create directed acyclic graphs (DAGs) in Apache Airflow deployed on Google Kubernetes Engine. Use the appropriate operators to connect to Cloud Storage, Spark, and BigQuery.
• C.Use Cloud Tasks to schedule and run the jobs asynchronously.
• D.Use Cloud Scheduler to schedule the jobs to run.

Your team uses the Google Ads platform to visualize metrics. You want to export the data to BigQuery to get more granular insights. You need to execute a one-time transfer of historical data and automatically update data daily. You want a solution that is low-code, serverless, and requires minimal maintenance. What should you do?

• A.Export the historical data to BigQuery by using BigQuery Data Transfer Service. Use BigQuery Data Transfer Service for daily automation.
• B.Export the historical data as a CSV file. Import the file into BigQuery for analysis. Use Cloud Composer for daily automation.
• C.Export the historical data to Cloud Storage by using Storage Transfer Service. Use Pub/Sub to trigger a Dataflow template that loads data for daily automation.
• D.Export the historical data to BigQuery by using BigQuery Data Transfer Service. Use Cloud Composer for daily automation.

You are designing an application that will interact with several BigQuery datasets. You need to grant the application's service account permissions that allow it to query and update tables within the datasets, and list all datasets in a project within your application. You want to follow the principle of least privilege. Which pre- defined IAM role(s) should you apply to the service account?

• A.roles/bigquery.user and roles/bigquery.filteredDataViewer
• B.roles/bigquery.connectionUser and roles/bigquery.dataViewer
• C.roles/bigquery.admin
• D.roles/bigquery.jobUser and roles/bigquery.dataOwner

You need to design a data pipeline that ingests data from CSV, Avro, and Parquet files into Cloud Storage.
The data includes raw user input. You need to remove all malicious SQL injections before storing the data in BigQuery. Which data manipulation methodology should you choose?

• A.ETL
• B.ELT
• C.EL
• D.ETLT

Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards.
You need to implement a solution quickly and efficiently. What should you do?

• A.Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
• B.Apply a filter to only show products with a positive profit margin.
• C.Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
• D.Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.