A table contains several rows of cellular numbers with call timestamps, call durations, called numbers, and carriers of the called number. Which of the following allows a data analyst to sort the cellular numbers based on the carriers of the called numbers and include the total call durations?
A.
B.
C.
D.
Show Answer
Correct Answer: C
Explanation: Grouping by cellular number and called-number carrier lets SUM(call_duration) total each pair’s calls. ORDER BY called_number_carrier sorts the results by carrier.
Question 72
Given the following tables:
Which of the following data privacy practices is being used to protect employees' email addresses when creating a report?
A. Anonymization
B. Hashing
C. Masking
D. Encryption
Show Answer
Correct Answer: C
Explanation: Masking hides some or all of an email address in a report while leaving enough information for the data to remain useful. For example, j*****@company.com.
Question 73
A sales analyst is using the following table to produce a report on January sales data:
Which of the following inconsistencies is present in the data set?
A. Duplication
B. Redundancy
C. Missing values
D. Outliers
Show Answer
Correct Answer: C
Explanation: The inconsistency is missing values: some data fields are blank or incomplete.
Question 74
Which of the following programming languages are the most efficient at performing data mining and statistical analysis? (Choose two.)
A. Java
B. R
C. Python
D. Ruby
E. Julia
F. C++
Show Answer
Correct Answer: B, C
Explanation: R is designed for statistical computing and analysis. Python offers extensive libraries for data mining, statistics, and machine learning. Here, “efficient” refers to their suitability and tooling for these tasks, not raw execution speed.
Sources:
https://www.guvi.in/blog/statistical-programming-languages
https://www.rswebsols.com/big-data-programming-languages
Question 75
A data analyst is gathering data from multiple tables in a database. The analyst needs certain columns from each table. Which of the following is the best method to accomplish this task?
A. Aggregate
B. Union
C. Nest
D. Join
Show Answer
Correct Answer: D
Explanation: A JOIN combines related tables using a shared key, allowing the analyst to retrieve selected columns from each table. UNION combines rows, while aggregation summarizes data.
Question 76
A data company needs a visualization that shows the availability zones from the last ten years and any future availability zones that the company will be using in the next five years. Which of the following is the most appropriate visualization to display this information?
A. Bar chart
B. Mosaic plot
C. Map
D. Pie chart
Show Answer
Correct Answer: C
Explanation: Availability zones are geographic locations, so a map is the most appropriate way to display existing zones and planned future zones.
Question 77
A data analyst needs to derive a new field that flags sales within the month of January from the following sales table:
Which of the following types of functions should the analyst use to achieve the desired results?
A. Logical
B. Date
C. Aggregate
D. String
Show Answer
Correct Answer: A
Explanation: A logical function can test whether each sale date falls in January and return a flag such as Yes or No.
Question 78
Which of the following is a data warehouse term for a data set specifically created for drill-down reports?
A. Dimension
B. Measure
C. Cube
D. Cluster
Show Answer
Correct Answer: C
Explanation: A cube is a multidimensional data set used in data warehousing and OLAP, enabling users to analyze data across dimensions and drill down into detail.
Question 79
A data analyst's code is failing when the analyst attempts a large batch upload to a cloud database. The analyst checks the following:
The database key is correct and embedded in the code.
All classes and objects have been defined and called.
The coding format in a text editor ensures syntax uniformity.
Built-in and user-defined exceptions are responding appropriately.
Print statements correctly identify the line where an error occurs.
Online coding forums do not contain similar issues with resolutions.
Which of the following is the most appropriate next step to continue troubleshooting?
A. Developing a new code for this process
B. Asking a senior engineer for peer review of the code
C. Scheduling a team meeting and getting help from the entire group
D. Converting the code to a different language
Show Answer
Correct Answer: B
Explanation: Since the analyst has already checked configuration, syntax, exceptions, and error locations without resolving the issue, the most appropriate next step is a focused code review by a senior engineer. They may spot a logic or implementation issue that the analyst has overlooked.
Question 80
A data engineer needs to create a reporting solution that has predefined filters and the ability to download .csv files. Which of the following is the best solution?
A. Developing a dynamic dashboard that refreshes daily
B. Generating a weekly executive summary
C. Creating a self-service portal on the company's intranet
D. Building an email template to request ad hoc reports
Show Answer
Correct Answer: C
Explanation: A self-service portal can provide reports with predefined filters and let users download the results as CSV files, without requiring manual report requests.
$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.
