Audit Queries Max User | Dataford Interview Questions

Read queries from a text file (audit.txt with userid, timestamp, tablename, query text) and give the maximum queried user, in Python and Spark

Asked in the Technical Round 2 stage. For this SQL exercise, use the audit log table as the source.

Output

audit_queries

Column	Type	Description
audit_idPK	INTEGER	Unique audit record identifier
userid	INTEGER	Identifier of the user who issued the query
query_timestamp	TIMESTAMPTZ	Timestamp when the query was issued
tablename	VARCHAR(100)	Table referenced by the query
query_text	TEXT	SQL text recorded in the audit log

Your question is Audit Queries Max User. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Read queries from a text file (audit.txt with userid, timestamp, tablename, query text) and give the maximum queried user, in Python and Spark

Asked in the Technical Round 2 stage. For this SQL exercise, use the audit log table as the source.

audit_queries

Column	Type	Description
audit_idPK	INTEGER	Unique audit record identifier
userid	INTEGER	Identifier of the user who issued the query
query_timestamp	TIMESTAMPTZ	Timestamp when the query was issued
tablename	VARCHAR(100)	Table referenced by the query
query_text	TEXT	SQL text recorded in the audit log

Your question is Audit Queries Max User. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.