CompTIA Data+ v1.0
Question 1
A data analyst is querying the Customers table, which contains a name column. Which of the following is the best way to return the customers who have the letters ANT at the beginning of their names?
-
A.
-
B.
-
C.
-
D.
Answer : D
Question 2
Which of the following data repositories stores unstructured and structured data?
- A. Data store
- B. Data silo
- C. Data mart
- D. Data lake
Answer : D
Question 3
Which of the following data sources makes online data consumption easier?
- A. Data mart
- B. Web scraping
- C. Database
- D. Application programming interface
Answer : D
Question 4
A data analyst receives a report from a dashboard user stating that their report is taking longer than usual to load. The user needs five components for the dashboard. However, upon investigating, the analyst notices ten components that are attempting to load. Which of the following steps should the analyst take to correct this issue?
- A. Check the refresh rate on the report server.
- B. Check with the network team for stale network connections.
- C. Check with administrators to review the logs of the report server.
- D. Check the filters to include only the required information.
Answer : D
Question 5
A financial firm gives an analyst a set of requirements for a sales dashboard. The analyst creates a product using sample data and other components to show the firm how the product will most likely look. Which of the following best explains the analyst's approach?
- A. Designing a mock-up to gather feedback and ensure requirements are understood
- B. Creating an accessibility product to ensure the firm can access the sales dashboard
- C. Developing a sample dashboard to show the level of detail required for the product
- D. Ensuring that all of the colors and graphics align with the firm's requirements
Answer : A
Question 6
A data analyst is querying a database. However, the analyst is unfamiliar with the table names, field names, data types, and field definitions. Which of the following is the best place to look for this information?
- A. Data dictionary
- B. Data explainability report
- C. Data lineage
- D. Data flow diagram
Answer : A
Question 7
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. Group
- B. Join
- C. Union
- D. Nested
Answer : C
Question 8
A data analyst is creating a statistical table that contains basic information about the data set. Which of the following is the best statistical method for this scenario?
- A. Descriptive
- B. Predictive
- C. Inferential
- D. Prescriptive
Answer : A
Question 9
Which of the following is the best example of a slowly changing dimension for a data warehouse?
- A. A customer table that is overwritten every morning without keeping history
- B. A piece of historical customer data that is removed from the table
- C. A new table created each day with updated customer data
- D. An address from the customer table that is overwritten when changed
Answer : D
Question 10
Given the following tables:
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
Answer : A
Question 11
A data analyst calculated the average score per student without making any changes to the following table:
Which of the following exploration techniques should the analyst have considered before calculating the average?
- A. Duplication
- B. Redundancy
- C. Binning
- D. Grouping
Answer : A
Question 12
A manager requests a report that returns results based on a user’s profile. Which of the following best describes this type of report?
- A. Real-time
- B. Static
- C. Dynamic
- D. Snapshot
Answer : C
Question 13
A data analyst is creating a document that covers the guidelines and transformation of the suite of sales dashboards that they are responsible for delivering. Which of the following is the analyst most likely creating?
- A. Data flow diagram
- B. Data lineage
- C. Data dictionary
- D. Data versioning
Answer : B
Question 14
A data analyst needs to join together a table data source and web API data source using Python. Which of the following is the best way to accomplish this task?
- A. Convert the data from the API and database to a varchar format and convert them to pandas DataFrames that are then merged together
- B. Convert the data from the API and database to a JSON format and convert them to pandas DataFrames that are then merged together.
- C. Convert the data from the API and database to a TXT format and convert them to pandas DataFrames that are then merged together.
- D. Convert the data from the API and database to a string format and convert them to pandas DataFrames that are then merged together.
Answer : B
Question 15
HOTSPOT -
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 -
select each visualization to fit the appropriate space on the dashboard. Once you have selected all visualizations, use the drop-down menus to select the appropriate dashboard titles and axis labels, if applicable.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.
Answer : 