DA0-002 試験問題を無料オンラインアクセス

A data analyst needs to create a combined report that includes information from the following two tables:

Which of the following query methods should the analyst use for this task?

• A.Join
• B.Group
• C.Nested
• D.Union

A data analyst needs to summarize the number of customers who contacted the business in the last year by contact type. The Contact_Type table is in a file and has one million rows. Based on the following sample:

Which of the following is the most efficient for the analyst to use?

• A.Math function
• B.Filter
• C.Pivot table
• D.Query

A data analyst is creating a report that shows the major of each student at the university. The first character of the CategoryCD from the Students table is used to determine the major. Given the following tables:

Which of the following steps should the analyst take first?

• A.Use a string function on the CategoryCD.
• B.Convert the CategoryCD to a numeric value
• C.Join both the tables using the CategoryCD and MajorCD columns
• D.Append the MajorCD to the CategoryCD column

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.Line
• B.Bubble
• C.Hierarchy
• D.Donut

A data analyst troubleshoots a dashboard every day for a week. Which of the following techniques best addresses how to validate the data moving forward?

• A.Inquiring about structure changes
• B.Setting up monitoring alerts
• C.Rebuilding the dashboard
• D.Reaching out to users daily