CompTIA DA0-002 Online Practice Questions and Exam Preparation

CompTIA DA0-002 Online Questions & Answers

• Question 41:

  Given the following tables:

  Individual table

  ID FirstName LastName John Doe

  Output ID FullName JohnDoe

  Which of the following is the best option to display output from FirstName and LastName as FullName?

  A. Concatenate
  B. Filter
  C. Join
  D. Group
  A. Concatenate

• Question 42:

  An analyst has been asked to validate data quality. Which of the following are the BEST reasons to validate data for quality control purposes? (Choose two.)

  A. Retention
  B. Integrity
  C. Transmission
  D. Consistency
  E. Encryption
  F. Deletion
  B. Integrity

• Question 43:

  A data analyst learns that a report detailing employee sales is reflecting sales only for the current month. Which of the following is the most likely cause?

  A. Lack of permissions
  B. An error in SQL code
  C. Report refresh failure
  D. Connectivity issues
  B. An error in SQL code

• Question 44:

  Which one of the following programming languages is specifically designed for use in analytics applications?

  A. Python.
  B. R
  C. C++
  D. Java.
  B. R

• Question 45:

  A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

  A. January 1, 2020 to April 1, 2020
  B. January 1, 2020 to April 7, 2020
  C. January 1, 2020 to April 8, 2020
  D. January 1, 2020 to April 9, 2020
  D. January 1, 2020 to April 9, 2020

• Question 46:

  A data analyst is following up on a recent, company-wide data audit of customer invoice data. Which of the following is the best option for the analyst to use?

  A. PCI DSS
  B. GDPR
  C. ISO
  D. PII
  B. GDPR

• Question 47:

  The human resources department wants to understand the relationship between the ages and incomes of all employees. Which of the following graphics is the most appropriate to present the analysis?

  A. Scatter plot
  B. Area plot
  C. Bar chart
  D. Pie chart
  A. Scatter plot

• Question 48:

  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. Inferential
  B. Descriptive
  C. Prescriptive
  D. Predictive
  B. Descriptive

• Question 49:

  SIMULATION

  The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following: County outages Status Overall trend of outages

  INSTRUCTIONS:

  Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.

  If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

  

  A. Power outages
  B. PlaceHolder
  C. PlaceHolder
  D. PlaceHolder
  A. Power outages

  ---

  Explanation

  This is a simulation question that requires you to create a dashboard with visualizations that meet the director's needs. Here are the steps to complete the task: Drag and drop the visualization that shows the county outages on the top left space of the dashboard. This visualization is a map of the state with different colors indicating the number of outages in each county. You can choose any color scheme that suits your preference, but make sure that the colors are consistent and clear. For example, you can use a gradient of red to show the counties with more outages and green to show the counties with less outages. Drag and drop the visualization that shows the status of the outages on the top right space of the dashboard. This visualization is a pie chart that shows the percentage of outages that are active, restored, or pending. You can choose any color scheme that suits your preference, but make sure that the colors are distinct and easy to identify. For example, you can use red for active, green for restored, and yellow for pending. Drag and drop the visualization that shows the overall trend of outages on the bottom space of the dashboard. This visualization is a line graph that shows the number of outages over time. You can choose any color scheme that suits your preference, but make sure that the color is visible and contrasted with the background. For example, you can use blue for the line and white for the background. Select appropriate titles and labels for each visualization. Titles and labels may be used more than once. For example, you can use ''County Outages'' as the title for the map, ''Status'' as the title for the pie chart, and ''Trend'' as the title for the line graph. You can also use ''County'', ''Number of Outages'', ''Active'', ''Restored'', ''Pending'', ''Time'', and ''Number of Outages'' as labels for the axes and legends of the visualizations.

• Question 50:

  A database administrator needs to implement security triggers for an organization's user information database. Which of the following data classifications is the administrator most likely using? (Select two).

  A. Public
  B. Open
  C. Sensitive
  D. Non-Sensitive
  E. Private
  F. Encrypted
  C. Sensitive
  E. Private