[Data Concepts and Environments] A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?
Correct Answer: C
Explanation:
The first step in troubleshooting a report that was working before a database upgrade is to confirm whether the report can still connect to the database. Database upgrades often cause connection issues due to changes in endpoints, credentials, or drivers. Before checking deeper issues like schema changes or permissions, it is best practice to first ensure the data source connection is still valid. If the connection works, then further investigation into structural changes can follow.
Question 2
[Data Acquisition and Preparation] Which of the following best describes the semi-structured data that is gathered when web scraping?
Correct Answer: D
Explanation:
Web scraping collects data directly from web pages, and those pages are originally written in HTML, which is considered semi-structured because it has a flexible tag-based format rather than a strict tabular structure. While scraped data is often later converted into formats like JSON, the actual source format being extracted from websites is HTML. CSV is structured data, CSS is for styling web pages, and JSON is a structured/semi-structured format but not the raw format typically gathered during scraping.
Question 3
[Data Acquisition and Preparation] Which of the following best describes the semi-structured data that is gathered when web scraping?
Correct Answer: D
Explanation:
Web scraping collects data directly from web pages, and those pages are originally written in HTML, which is considered semi-structured because it has a flexible tag-based format rather than a strict tabular structure. While scraped data is often later converted into formats like JSON, the actual source format being extracted from websites is HTML. CSV is structured data, CSS is for styling web pages, and JSON is a structured/semi-structured format but not the raw format typically gathered during scraping.
Demo Practice Mode
You are viewing only the questions marked as Demo.