IT Certification Exam Questions & Answers

QUESTION 120
A data analyst needs to get an accurate idea of how data components are automated. Which of the following types of documentation should the analyst review first?

QUESTION 121
Which of the following best describes an assessment a data analyst would use to validate that the number of records in a dataset matches the expected results?

QUESTION 122
A data analyst created a dashboard to illustrate the traffic volume and mean response time for a call center.
The traffic data is current, but the mean response time has not updated for more than an hour. Which of the following is the best way to verify the data’s freshness?

QUESTION 123
A Chief Executive Officer requests a report that must:
* Summarize the company metrics in a simple way.
* Be clear and concise.
* Be easily understood by all company levels.
* Be accessible and updated without manual intervention.
Which of the following communication approaches best meets these requirements?

QUESTION 124
A data analyst wants to analyze sales data for possible customer patterns. Which of the following should the analyst use to complete this task?

QUESTION 125
A data analyst is creating a user sentiment analysis for a new product. Which of the following is the best method to acquire the data?

QUESTION 126
A marketing firm wants to find the average age of its consumers to better promote its products. Given the following dataset:
Name
Date of birth
Age
Jane
March 24
34
John
July 17
11
Joe
November 29
29
Ann
December 13
14
Robert
December 14
63
Which of the following is the mean of the consumer ages?

QUESTION 127
A data analyst is creating a forecast for a product line introduced early last year. Which of the following should the analyst use to create projected sales and customer satisfaction for next year?

QUESTION 128
A data analyst is creating a document that covers the guidelines and transformation of the suite of sales dashboards that they are responsible for delivering. Which of the following is the analyst most likely creating?

QUESTION 129
A data analyst needs to create and deliver a dashboard that displays the company’s financial transactions as they are updated. Which of the following delivery methods should the analyst consider? (Select two).

QUESTION 130
Given the following tables:

Which of the following data privacy practices is being used to protect employees’ email addresses when creating a report?

QUESTION 131
A data analyst is querying the Customers table, which contains a name column. Which of the following is the best way to return the customers who have the letters ANT at the beginning of their names?

QUESTION 132
A data analyst learns that a report detailing employee sales is reflecting sales only for the current month.
Which of the following is the most likely cause?

QUESTION 133
A data analyst is analyzing the following dataset:
Transaction Date
Quantity
Item
Item Price
12/12/12
11
USB Cords
9.99
11/11/11
3
Charging Block
8.89
10/10/10
5
Headphones
50.15
Which of the following methods should the analyst use to determine the total cost for each transaction?

QUESTION 134
Which of the following AI types is the best option for time-series forecasting?

QUESTION 135
A sales manager wants a dashboard that shows sales aggregated by region and identifies high-volume sales by salesperson per region. Which of the following communication techniques best displays this information?

QUESTION 136
A data analyst is creating a new dataset that involves bringing together the following datasets:
Name
ID
Date of birth
Frank
23525
3/19
Martha
11290
6/13
Ellen
12141
11/4
ID
Address
City
State
23525
1234 Harding
Chicago
IL
11040
935 Terrace Hills
Chino
CA
11290
2 Speedway
Miami
FL
Which of the following would be the output if the data analyst does a FULL JOIN?

QUESTION 137
A data analyst wants to find the mean score that students received in science classes. Given the following tables:

Which of the following will produce the desired results?

QUESTION 138
Which of the following best describes a characteristic of a Boolean?

QUESTION 139
A data analyst receives a report from a dashboard user stating that their report is taking longer than usual to load. The user needs five components for the dashboard. However, upon investigating, the analyst notices ten components that are attempting to load. Which of the following steps should the analyst take to correct this issue?

QUESTION 140
Which of the following pieces of information, if made public, results in a data privacy violation?

QUESTION 141
A data analyst wants to isolate a serial number from a string of code. Which of the following data transformation techniques should the analyst use?

QUESTION 142
A data analyst needs to summarize the number of customers who contacted the business in the last year by contact type. The Contact_Type table is in a file and has one million rows. Based on the following sample:

Which of the following is the most efficient for the analyst to use?

QUESTION 143
A complex report is being created from a database. Within the database the storage location of the orders, packaging, and logistics details is unclear. The table’s attributes names are abbreviated and not easily identifiable. Which of the following types of documentation would be most useful for reference lookup?