Which of the following file formats uses curly brackets to surround objects?
A. XML
B. JSON
C. CSV
D. TXT
Show Answer
Correct Answer: B
Explanation: JSON uses curly braces `{}` to enclose objects, for example `{"name":"Ali"}`.
Question 52
A Chief Executive Officer (CEO) reviews the results of a sales report and notices that the company's performance decreased in the last quarter. The CEO needs additional information to understand the reason. Which of the following is the best analysis method for a data analyst to use?
A. Prescriptive
B. Descriptive
C. Diagnostic
D. Predictive
Show Answer
Correct Answer: C
Explanation: The CEO already knows what happened (sales declined) and wants to understand why. Diagnostic analysis investigates causes and contributing factors behind an outcome.
Question 53
A data analyst needs to access data from the last ten years to develop a report. Which of the following should the analyst do to develop the report without affecting the system’s performance?
A. Connect to the production database and create a query that retrieves only the required data
B. Create a snapshot of the selected period and work on the data analysis in an isolated environment
C. Restore annual backups of the database in a local computer and query the current year's data in production
D. Download data from each month as independent flat files and create a local repository for further review
Show Answer
Correct Answer: B
Explanation: A snapshot of the ten-year period can be analyzed in an isolated environment, avoiding resource-intensive queries on the production system and reducing the risk of affecting its performance.
Question 54
A developer builds an online survey that requires all questions to have an answer. Which of the following inconsistencies does this setting prevent?
A. Missing values
B. Duplication
C. Data corruption
D. Completeness
Show Answer
Correct Answer: A
Explanation: Requiring an answer for every question prevents respondents from leaving fields blank, reducing missing values in the survey data.
Question 55
A grocery store wants to view the revenue from the previous year, highlighting individual departments. Which of following is the most appropriate chart to communicate this information?
A. Gantt
B. Pie
C. Area
D. Line
Show Answer
Correct Answer: B
Explanation: A pie chart shows how the previous year’s total revenue is divided among departments, making each department’s share easy to compare.
Question 56
Which of the following is the best way to ensure a procedure performs appropriately during heavy use?
A. Requirements test
B. Stress test
C. Network throughput test
D. User acceptance test
Show Answer
Correct Answer: B
Explanation: A stress test evaluates whether a procedure or system continues to perform appropriately under heavy or extreme use.
Question 57
A data analyst is creating a report that provides information to parents and residents about the school distinct and its individual schools. Which of the following statistical methods is best suited for reporting this information?
A. Predictive
B. Prescriptive
C. Descriptive
D. Inferential
Show Answer
Correct Answer: C
Explanation: Descriptive statistics summarize and present existing data about the school district and its individual schools. They do not predict future outcomes or prescribe actions.
Question 58
Which of the following is the best reason for a company to use a CSV file to share data instead of an Excel file?
A. CSV files can store different types of encoding
B. CSV files are not vendor specific
C. CSV files are smaller in size
D. CSV files are easier to change in text editors
Show Answer
Correct Answer: B
Explanation: CSV is a plain-text, widely supported format that is not tied to a particular software vendor, making it a good choice for sharing data across different systems.
Question 59
A data analyst deployed a report for public access. A user states that the report is not showing the latest information, even though the user updated the source an hour ago. Which of the following should the data analyst check first?
A. Event log
B. User privileges
C. Database connection
D. Report corruption
Show Answer
Correct Answer: C
Explanation: Check the database connection first to confirm the report can access the source and retrieve its latest data. User privileges affect access, while event logs and report corruption are less direct first checks.
Question 60
Which of the following best describes the purpose of a primary key?
A. To provide a helper index that allows the database to find subsets of data easily
B. To organize data so that the database has an efficient way to find data in a table
C. To eliminate the need to join tables
D. To create a unique way to identify each row in a table
Show Answer
Correct Answer: D
Explanation: A primary key uniquely identifies each row in a table. It may also be indexed for efficient lookups, but its defining purpose is unique row identification.
$19
Get all 146 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.