An analyst is creating a presentation for a corporate meeting. Which of the following is the most important consideration?
A. Engaging visuals
B. Knowing the audience
C. Level of detail
D. Dynamic storytelling
Show Answer
Correct Answer: B
Explanation: Knowing the audience is the most important starting point because it guides the presentation’s content, level of detail, language, visuals, and storytelling approach.
Question 42
A data analyst is reviewing a new data source that contains employee IDs, job titles, dates of birth, addresses, years of service, and employees' birth months. Which of the following inconsistencies should the analyst identify?
A. Redundancy
B. Completeness
C. Outliers
D. Duplication
Show Answer
Correct Answer: A
Explanation: The birth month can be derived from each employee’s date of birth, so storing both fields repeats the same information and creates redundancy.
Question 43
A data analyst needs to generate a list of employees who currently live in Dade, FL. Given the following table:
Which of the following SQL statements should the analyst use to complete this task?
A. SELECT * FROM Employee WHERE emp_city LIKE 'D%';
B. SELECT * FROM Employee WHERE emp_city IN ('Dade', 'FL');
C. SELECT * FROM Employee WHERE emp_city = 'Dade' OR emp_st = 'FL';
D. SELECT * FROM Employee WHERE emp_city = 'Dade' AND emp_st = 'FL';
Show Answer
Correct Answer: D
Explanation: Use AND to require both conditions: the employee’s city is Dade and the state is FL. Option D matches both fields.
Question 44
A company gives users adequate data access permissions to allow them to fulfill their duties but nothing more. Which of the following concepts best describes this practice?
A. Active Directory
B. Hierarchical access
C. Zero Trust
D. Least privilege
Show Answer
Correct Answer: D
Explanation: Least privilege means granting users only the minimum access necessary to perform their assigned duties.
Question 45
A data analyst needs to remove all duplicate values between two tables, "Employees" and "Managers," using SQL SELECT statements. Which of the following should the analyst use for this task?
A. SELECT * FROM Employees UNION ALL SELECT * FROM Managers
B. SELECT * FROM Employees UNION SELECT * FROM Managers
C. SELECT * FROM Employees JOIN SELECT * FROM Managers
D. SELECT * FROM Employees CROSS JOIN SELECT * FROM Managers
Show Answer
Correct Answer: B
Explanation: UNION combines the results of the two SELECT statements and removes duplicate rows. UNION ALL retains duplicates; JOIN and CROSS JOIN perform different kinds of combinations.
Question 46
A data analyst is joining two tables with different content and one common field. Which of the following should the analyst do to most efficiently meet this requirement?
A. Match the records of the related columns and merge the tables.
B. Create a cluster to facilitate data integration between the tables.
C. Explode both tables to identify unique values and reorder the fields in one table.
D. Append the values of the matching columns and concatenate the other data fields.
Show Answer
Correct Answer: A
Explanation: Match records using the common field and merge (join) the tables. This combines related data from both tables; appending would stack rows rather than match records.
Question 47
A reporting team needs to update communication decks that were shared internally so that the decks can be shared with external partners. Which of the following elements is the most important update?
A. Watermark
B. Presentation date
C. Company name
D. Font choice
Show Answer
Correct Answer: A
Explanation: Review and update the watermark so it no longer indicates an internal-only or confidential status when the deck is shared externally. The other options are generally less important to the deck’s sharing status.
Question 48
A data analyst is creating a report that shows the major of each student at the university. The first character of the CategoryCD from the Students table is used to determine the major. Given the following tables:
Which of the following steps should the analyst take first?
A. Convert the CategoryCD to a numeric value
B. Use a string function on the CategoryCD.
C. Append the MajorCD to the CategoryCD column
D. Join both the tables using the CategoryCD and MajorCD columns
Show Answer
Correct Answer: B
Explanation: Use a string function to extract the first character of CategoryCD. That character identifies the major and can then be used to match the corresponding MajorCD.
Question 49
An organization sees an increase in requests to view its online dashboard. Providing access is time-consuming. Which of the following actions should the data team take to provide access and ensure the security of the online portal?
A. Implement a self-service portal with user credentials.
B. Designate one person to handle user requests for portal access.
C. Set up a specific help desk for users to request access.
D. Enable open access to the portal.
Show Answer
Correct Answer: A
Explanation: A self-service portal with user credentials streamlines access requests while requiring authentication to protect the dashboard from unauthorized access.
Question 50
Given the following data set:
Which of the following is the median?
A. 59
B. 67
C. 70
D. 74
Show Answer
Correct Answer: D
Explanation: The ordered data are 35, 45, 72, 76, 83, 91. With six values, the median is the mean of the two middle values: (72 + 76) / 2 = 74.
$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.