Free certification test prep

Q45. A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Q46. A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Q47. Which of the following contains alphanumeric values?

Q48. Which one of the following programming languages is specifically designed for use in analytics applications?

Q49. Melissa wants to explore central tendency in her dataset.
Which statistic best matches her need?

Q50. Given the following customer and order tables:
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?

Q51. You recently downloaded a file containing website visitor logs from your organization’s web server.
What term best describes these logs at this point in the process?

Q52. Which of the following data manipulation techniques is an example of a logical function?

Q53. What symbol is used for the variance of a population of data?

Q54. What three technological innovations contribute to modern analytics?
Choose three answers.

Q55. Which of the following value is the measure of dispersion “range” between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

Q56. Which of the following are reasons to create and maintain a data dictionary? (Choose two.)

Q57. How many variables are normally shown on a standard heat map?

Q58. Data validation should occur only when data is initially brought into a organization.

Q59. The number of phone calls that call center receives in a day is an example of:

Q60. Which of the following data elements would not normally be stored in binary format?

Q61. What colors are commonly used for the change bars in a waterfall chart?

Q62. Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Q63. The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable. Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

Q64. Which of the following is a control measure for preventing a data breach?