Question 1

A data analyst needs to remove all duplicate values between two tables, "Employees" and "Managers," using SQL SELECT statements. Which of the following should the analyst use for this task?

Options :

A : SELECT * FROM Employees UNION ALL SELECT * FROM Managers

B : SELECT * FROM Employees UNION SELECT * FROM Managers

C : SELECT * FROM Employees JOIN SELECT * FROM Managers

D : SELECT * FROM Employees CROSS JOIN SELECT * FROM Managers

Answer: B

Question 2

A data analyst encounters an issue with new software and a code that they are using. The analyst includes print statements in the code to try to identify the issue, without success. An informal peer review of the code also produces the same result. The analyst confirms that the software is updated to the latest version and compatible with the code. Which of the following troubleshooting steps should the analyst take next?

Options :

A : Use the old software and preexisting code, since both were functional.

B : Contact the IT department and inform them that the software has a bug.

C : Escalate to the department manager and ask for assistance.

D : Research the issue online and see if a solution is available.

Answer: D

Question 3

Which of the following best describes an assessment a data analyst would use to validate that the number of records in a dataset matches the expected results?

Options :

A : Source control

B : Unit test

C : Stress test

D : Health check

Answer: B

Question 4

A data analyst team needs to segment customers based on customer spending behavior. Given one million rows of data like the information in the following sales order table: Customer_ID Region Amount_spent Product_category Quantity_of_items 00123 East 20000 Baby 4 00124 West 30000 Home 6 00125 South 40000 Garden 7 00126 North 50000 Furniture 8 00127 East 60000 Baby 10 Which of the following techniques should the team use for this task?

Options :

A : Standardization

B : Concatenate

C : Binning

D : Appending

Answer: C

Question 5

The human resources department wants to know the number of employees who earn $125,000 or more. However, the department is concerned about duplicates in the dataset. Given the following table: Employee_ID Level Salary 001 1 10000 2 20000 003 2 256000 004 2 125000 001 1 10000 2 20000 Which of the following SQL statements resolves this issue?

Options :

A : SELECT DISTINCT Employee_ID FROM Employee WHERE Salary >= 125000

B : SELECT COUNT(DISTINCT Employee_ID) FROM Employee WHERE Salary >= 125000

C : SELECT DISTINCT Employee_ID FROM Employee WHERE Salary > 125000

D : SELECT COUNT(Employee_ID) FROM Employee WHERE Salary >= 125000

Answer: B

Free DA0-002 Mock Exam – Practice Online Confidently

Buying Options: