
Ultimate access to all questions.
As a BigQuery admin supporting a team of data consumers who execute ad hoc queries and perform downstream reporting using tools like Looker, you have all data and users consolidated under a single organizational project. Recently, you have observed slowness in query results and need to troubleshoot the cause of these slowdowns. You suspect that the delays might be due to job queuing or slot contention as users initiate jobs, which hampers timely access to query results. Your task is to investigate the query job information to identify where the performance bottlenecks are occurring. What steps should you take to diagnose and address the performance issues?
A
Use slot reservations for your project to ensure that you have enough query processing capacity and are able to allocate available slots to the slower queries.
B
Use Cloud Monitoring to view BigQuery metrics and set up alerts that let you know when a certain percentage of slots were used.
C
Use available administrative resource charts to determine how slots are being used and how jobs are performing over time. Run a query on the INFORMATION_SCHEMA to review query performance._
D
Use Cloud Logging to determine if any users or downstream consumers are changing or deleting access grants on tagged resources.