CompTIA Data+ - DA0-002 模擬練習
An engineer needs to build an ETL process to calculate the average sales of individual stores.
Each store sends their sales data as .csv files. Which of the following would the engineer most likely do to the data?
Each store sends their sales data as .csv files. Which of the following would the engineer most likely do to the data?
正解: A
解説: (PassTest メンバーにのみ表示されます)
Which of the following is a NoSQL database?
正解: D
Which of the following situations best describes an unclear and inconsistent column definition that can lead to an enabled analysis process?
正解: B
解説: (PassTest メンバーにのみ表示されます)
An analyst is developing a form to collect data from clients. Which of the following techniques should the analyst use to best ensure data integrity?
正解: A
解説: (PassTest メンバーにのみ表示されます)
A company reports on seven years of data in a sales dashboard. The dashboard pulls from a sales database that has 30 years of data. The dashboard performance is slow. Which of the following is the best way to improve the dashboard's performance?
正解: C
A data analyst needs to combine the results of two separate queries that have similar data and the same number of columns. The output must also have distinct rows. Which of the following should the data analyst use?
正解: D
解説: (PassTest メンバーにのみ表示されます)
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
解説: (PassTest メンバーにのみ表示されます)
Which of the following is the best way to ensure a procedure performs appropriately during heavy use?
正解: D
解説: (PassTest メンバーにのみ表示されます)
A company's entire server environment is located at the company's headquarters. Which of the following describes this type of environment?
正解: A
解説: (PassTest メンバーにのみ表示されます)
A data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfaction for next year?
正解: C
解説: (PassTest メンバーにのみ表示されます)
A product goes viral on social media, creating high demand. Distribution channels are facing supply chain issues because the testing and training models that are used for sales forecasting have not encountered similar demand. Which of the following best describes this situation?
正解: D
解説: (PassTest メンバーにのみ表示されます)
Giving the following values:
47
59
83
33
51
39
52
Which of the following is the mean?
47
59
83
33
51
39
52
Which of the following is the mean?
正解: A
解説: (PassTest メンバーにのみ表示されます)
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?
正解: B
Given the following tables:
Which of the following data privacy practices is being used to protect employees' email addresses when creating a report?
Which of the following data privacy practices is being used to protect employees' email addresses when creating a report?
正解: D
解説: (PassTest メンバーにのみ表示されます)
Which of the following makes data unreadable without a required key?
正解: A
解説: (PassTest メンバーにのみ表示されます)