How can the developer use SQL Runner to troubleshoot quickly?

A user is seeing an error in the Explore that indicates the primary key defined for a one- million-row table is not unique.

How can the developer use SQL Runner to troubleshoot quickly?
A . Create a query that selects all the fields from the table, and sort by primary key.
B . Create a query that selects the primary key from the base view, and look forduplicates.
C . Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.
D . Create a query that concatenates two columns to create a compound primary key.

View Answer

Answer: D

Explanation:

Reference: https://help.looker.com/hc/en-us/articles/360037732513-Error-Non-Unique-value-primary-key-or-sql-distinct-key-value-overflow-or-collision-when-computing-sum