GH-300 Microsoft GitHub Copilot Exam Practice Test

About this exam

GH-300 is the Microsoft exam Microsoft GitHub Copilot Exam. Practice material is available as a PDF, an interactive practice test or a bundle of both.

Exam code

GH-300

Vendor

Microsoft

Practice questions

122

Questions with an explanation

122 of 122

Free sample questions

Question bank last updated

14 Sep 2026

Try 1 sample question

Taken from the free sample set for GH-300.

Question 1 (choose 2)

You need to identify the cause of the performance issues on SalesSQLDb1.
Which two dynamic management views should you use? Each correct answer presents part of the
solution.
NOTE: Each correct selection is worth one point.

Option A:
sys.dm_pdw_nodes_tran_locks
Option B:
sys.dm_exec_compute_node_errors
Option C:
sys.dm_exec_requests
Option D:
sys.dm_cdc_errors
Option E:
sys.dm_pdw_nodes_os_wait_stats
Option F:
sys.dm_tran_locks

Show answer and explanation

Correct answer: A, E

SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and

frequent blocking queries.

A: Use sys.dm_pdw_nodes_tran_locks instead of sys.dm_tran_locks from Azure Synapse Analytics

(SQL Data Warehouse) or Parallel Data Warehouse

E: Example:

The following query will show blocking information.

SELECT

t1.resource_type,

t1.resource_database_id,

t1.resource_associated_entity

_id, t1.request_mode,

t1.request_session_id,

t2.blocking_session_id

FROM sys.dm_tran_locks as t1

INNER JOIN sys.dm_os_waiting_tasks as t2

ON t1.lock_owner_address = t2.resource_address

Note: Depending on the system you’re working with you can access these wait statistics from one of

three locations:

sys.dm_os_wait_stats: for SQL Server
sys.dm_db_wait_stats: for Azure SQL Database
sys.dm_pdw_nodes_os_wait_stats: for Azure SQL Data Warehouse
F: sys.dm_tran_locks returns information about currently active lock manager resources in SQL
Server 2019 (15.x). Each row represents a currently active request to the lock manager for a lock that
has been granted or is waiting to be granted.
Instead use sys.dm_pdw_nodes_tran_locks.

Incorrect Answers:

See all 4 free sample questions