Page 13 of 15 · 294 total questions.
An analyst is looking at the relationship between age and certain health disparities. Which of the following analysis techniques should the analyst use?
The correct answer is D. Option D: Exploratory
An analyst is currently working on a ticket for revamping a company-wide dashboard that has been in use for five years. Which of the following should be the first step in the development process?
The correct answer is A. Option A: Talk to the group that made the request to determine the desired goal.
A business analyst has performed the following steps: • Reviewed research questions and business needs. • Identified data needs and how to collect this information. • Scoped the type of issues of interest based on the data. • Outlined the time frame needed. Which of the following describes what the analyst is trying to develop with this process?
The correct answer is A. Option A: Type of analysis
A company CRM has more than one million email addresses. The company wants to create a new reduced and simplified table that can be exported in a flat file. Which of the following analytics tools is the most appropriate?
The correct answer is D. Option D: SQL
Which of the following best describes the process of examining data for statistics and information about the data?
The correct answer is C. Option C: Profiling
The marketing team has a C-level executive who requires a dashboard that displays real-time sales data and performance metrics. The dashboard needs to be accessible on the executives tablet during board meetings. Which of the following dashboard considerations is the most important?
The correct answer is A. Option A: Audience This option meets the real-time / low-latency performance requirement.
During an interview, a hiring manager asks an analyst about the analyst's experience using programming languages. The analyst has used HTML, Python, and SQL. Which of the following explains what the analyst has most likely used HTML to accomplish?
The correct answer is D. Option D: To develop the front end of a website
A data set was recorded using multimedia technology. Which of the following is a necessary step on the way to interpretation?
The correct answer is B. Option B: Transcription
An analyst is creating a chart that shows the frequencies of values of a variable bucketed into ranges. Which of the following is the most appropriate visual for the analyst to use?
The correct answer is C. Option C: Histogram
Which of the following data types is most commonly used to store address data?
The correct answer is A. Option A: String
Which of the following is a reason to remove duplicate data?
The correct answer is C. Option C: Only unique values are desired.
An analyst wants to test the association between the number of doors in a car and the number of gears in the car. Which of the following is the best test to use?
The correct answer is C. Option C: Chi-squared test
An analyst is currently working with a set of data and obtained the following summary: Which of the following analysis techniques is the analyst using?
The correct answer is C. Option C: Exploratory
An analyst wants to compare a student's test performance to the overall performance of other students. Which of the following statistical methods would be best for this comparison?
The correct answer is B. Option B: Z-score
An analyst needs to develop a visualization that highlights key company aspects. Which of the following visualizations should the analyst create?
The correct answer is C. Option C: Infographic
Which of the following should a company do to allow remote employees to edit information in a secure database?
The correct answer is B. Option B: Utilize an API connection. This option keeps traffic private / properly secured as required.
A sales manager requested a report that contains the first name, last name, and phone number of all of the company's customers and employees. The data engineer needs to return all the records from several tables, even duplicates. Which of the following is the best way to join the two tables?
The correct answer is D. Option D: CROSS JOIN
Which of the following database types is the best to use for transactional SQL?
The correct answer is C. Option C: Relational
A business intelligence manager is redesigning a company's internal dashboards. Which of the following is the best tool for the manager to use to preview the redesign?
The correct answer is B. Option B: Wireframe
A data analyst is building a closed won quarter-over-quarter report for the sales team. Which of the following will be needed to complete this request?
The correct answer is B. Option B: The closed won quarter and the closed dollar amount
Showing questions 241–260 of 294 · Page 13 of 15