Free CompTIA DA0-002 Exam Dumps Questions & Answers

A data analyst is evaluating all conditions in a query. Which of the following is the best logical function to accomplish this task?

• A.IF
• B.OR
• C.NOT
• D.AND

A sales manager wants to understand how sales are trending year over year. Which of the following chart types is the most appropriate to display the information?

• A.Hierarchy
• B.Line
• C.Bubble
• D.Donut

A data analyst wants to use the following tables to find all the customers who have not placed an order:
Customers table
ID
Name
Address
Products table
ID
Name
Customer_ID
Which of the following SQL statements is the best way to accomplish this task?

• A.SELECT * FROM PRODUCTS AS P INNER JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE (SELECT COUNT(P.) = 0)
• B.SELECT * FROM PRODUCTS AS P LEFT JOIN CUSTOMERS AS C ON P.Customer_ID = C.ID WHERE P.Customer_ID IS NOT NULL
• C.SELECT * FROM CUSTOMERS AS C LEFT JOIN PRODUCTS AS P ON C.ID = P.Customer_ID WHERE P.Customer_ID IS NULL
• D.SELECT * FROM CUSTOMERS AS C INNER JOIN PRODUCTS AS P ON C.ID = C.ID WHERE COUNT(P.) = 0

A user needs a report that shows the main causes of customer churn rate in a three-year period. Which of the following methods provides this information?

• A.Prescriptive
• B.Predictive
• C.Inferential
• D.Descriptive

Which of the following AI types is the best option for time-series forecasting?

• A.Generative AI
• B.Natural language processing
• C.Robotic process automation
• D.Foundational models