Practice Test 3 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test

Question 50

A company uses BigQuery as its main data warehouse. The CTO wants to monitor BigQuery’s usage among users of different departments. Since BigQuery runs queries by allocating slots for performance. She wants to know how many slots are used daily for further billing considerations. How would you fulfill CTO’s requirements?

A. From BigQuery UI, you can view slot allocation. You can share it by exporting the stats to a file.
B. You need to contact Google Cloud support in order to enable slot utilization metrics on BigQuery UI.
C. Use Stackdriver to view slot utilization chart on the dashboard.
D. When you write a query in BigQuery text box, the smart predictor will show how much data will be scanned and the number of slots will be allocated for the query.

Answer

Correct Answer: C

CTO wants “how many slots are used daily”

This means we need a Daily slot utilization report

Slot utilization is derived by dividing the total number of slot-milliseconds (total_slot_ms from INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION) consumed by all jobs on a given day by the number of milliseconds in a day (1000 * 60 * 60 * 24).

——————————-

SELECT
  TIMESTAMP_TRUNC(jbo.creation_time, DAY) AS usage_date,
  jbo.reservation_id,
  jbo.project_id,
  jbo.job_type,
  jbo.user_email,
  -- Aggregate total_slots_ms used for all jobs on this day and divide
  -- by the number of milliseconds in a day. Most accurate for days with
  -- consistent slot usage
  SAFE_DIVIDE(SUM(jbo.total_slot_ms), (1000 * 60 * 60 * 24)) AS average_daily_slot_usage
FROM
  `region-{region_name}`.INFORMATION_SCHEMA.JOBS_BY_ORGANIZATION jbo
GROUP BY
  usage_date,
  jbo.project_id,
  jbo.job_type,
  jbo.user_email,
  jbo.reservation_id
ORDER BY
  usage_date ASC

————————–

However this has not been given in any of the options.

Option C is correct:: Stackdriver is a tool to monitor and manage services, containers, applications, and infrastructure. Stackdriver aggregates metrics, logs, and events from infrastructure, giving developers and operators a rich set of observable signals that speed up root-cause analysis and reduce mean time to resolution (MTTR). Stackdriver doesn’t require extensive integration and it does not lock developers into using a particular cloud provider.

One of the resources Stackdriver supports for monitoring is BigQuery. Stackdriver provides a wide set of metrics to create charts and dashboards for better monitoring of BigQuery such as query execution time, storage and slots allocated to run queries.

From the explanation, option C is a straightforward and recommended solution.

Option A is incorrect: “BigQuery UI, you can view slot allocation”

Here we need Slot Utilization and not Slot Allocation.

Option B is incorrect: You do not need to contact Google Cloud support . We can do ourself. We have multiple ways.

Option D is incorrect: Smart predictor does not show you the number of slots that will be allocated for the query. Additionally, We need Slot Utilization Report and not Slot Allocation Report.

Source(s):

Stackdriver:

https://cloud.google.com/stackdriver/

BigQuery Monitoring Using Stackdriver:

https://cloud.google.com/bigquery/docs/monitoring#slots- available