NO.20 A company wants to gauge the thoughts of their employees towards a new company product. On the 25th of March the interviewer makes a list of all employees who were at work on that day and then chooses a subset of those employees to interview. Which term describes the list of all employees present on March 25th?

NO.21 The definition of data elements is different across various data sources. The organization is looking to improve the usability of data across the organization. Which practice would help address this problem?

NO.22 The team has completed their analysis on a vast amount of collected data and agree on their recommendations for action.
However, they are having difficulty in developing the appropriate messages to support their recommendations.
The business analysis professional suggests which technique to assist the team?

NO.23 The results for a certification exam were revealed in percentage and percentile. The results for one of the attendees was: 75%, 90th percentile. What is the value in sharing the percentile score?

NO.24 A software company launched a new product in late 2016. The product manager is reviewing a Box and Whisker plot used to compare year-over-year sales, from 2017 to 2018. What is the conclusion he can make from this chart?

NO.25 A government agency is conducting a study on the performance of 12th grade students’ in mathematics across the country. In particular, they want to understand if there is a relationship between intelligence and scores, as well as the difference in performance between various locations. Which combination of inferential statistics procedures should be used?

NO.26 There were 7 students enrolled in the Introduction to Artificial Intelligence course. These were the student’s scores from the final exam: 64, 70, 80, 80, 90, 98, 100 What is the mean and mode for the outlined scores?

NO.27 A Human Resource manager recently learned that their competitor reduced employee attrition rates by 20% after implementing personality tests as part of their screening process. Intrigued by the idea, the manager suggests collecting data on personality tests and attrition rates over the next year. The data from this year is then analyzed to explore possible relationships. What type of analytics has the team been asked to perform?

NO.28 The analytics team has established two equally strong potential recommendations which will deliver the desired outcomes with similar benefits to be derived from each one. On the surface there is no discernable difference in costs or schedule for either option. To help the analytics team reach a recommendation the business analysis professional recommends the team:

NO.29 An analytics team has completed some initial data analysis but is considering revising their research question based on their analysis findings. The team was concerned the original question was too broad. What outcome would lead the team to have this concern?

NO.30 Based on the results of a recently completed analytics initiative, the Human Resource department for a major department store implemented a change to its hiring practice to address the attrition rates of its sales associates. The new policy stated that candidates applying for sales positions must possess at least 3 years of relevant sales experience to be considered. After implementing the change, attrition rates are 10% higher and management is frustrated. Which of the following could result in this outcome?

NO.31 After analyzing sales data, the analytics team finds that the older the customer, the more expensive the neckties purchased. The team felt this was a breakthrough insight but on closer analysis realized that other factors could account for this relationship. This is a clear indication that:

NO.32 An analytics team employed at a leading credit card company is utilizing data analytics to identify unusual credit card purchases.
They have created the following visual. How many extreme outliers exists in this dataset?

NO.33 A lab is conducting a study on protein interactions. They have used the data to create a graph visualization. In graph visualization, what would a layout be?

NO.34 A Data Dictionary is being developed for an employee database. When reviewing the data dictionary, the analyst recommends adding another primitive data element. Which element would be suggested?

NO.35 A marketing director has asked the question ‘How many product purchases are expected this coming year given the current marketing campaign?”. What type of analytics would be performed to answer this question?

NO.36 Senior executives in a large organization receive numerous sales reports of every sale through a corporate dashboard on a weekly basis. The executives are considering budget increases for various functions but would like to know if they are obtaining good returns for current budget allocations. They ask the analytics team to research and answer: “How effective is our marketing spend?” This question is:

NO.37 Collaborative games are used by a business analyst to identify the research questions to be explored within an analytics system.
Participants are asked to write down a research question on a sticky note, put the notes on the wall, and move them towards related research questions. What type of Collaborative game is being played?

NO.38 Interested in experimenting with analytics, a manufacturing company hires an analyst to see how the capability can be developed within its organization. The analyst is getting started and recognizes the need to show value from the onset of their work to gain upper management’s trust and future funding. What action will accomplish these objectives?

NO.39 Based on the financial analysis that’s been completed by the analytics team, the business analysis professional reminds the team that the most financially feasible option is the one with the:

NO.40 Which attributes from the Order entity will need to be normalized to avoid redundancies?
. Orderld
. OrderDate
. Itemld
. ItemName
. Quantity
. ItemPrice

NO.41 An analyst has just completed building a data model that shows the table structures including table names, table relationships with primary and foreign keys and column names with respective data types. What type of data model has the analyst just built?

NO.42 An organization’s customers are categorized based on the amount of purchases completed over the last 12 months. The analytics team would like to ensure the accuracy of their survey results and decide to randomly select 500 customers to participate in a survey from this large pool of customers. This is an example of:

NO.43 A research marketer is interested in collecting information about the spending habits of families in North America. Concerned about the volume of data required to conduct the research, they choose to use sampling.
The dataset is sourced using all credit card transactions from a leading North American credit card company for Quarter 1 of the prior year. The sample used is:

NO.44 While creating a dataset for analysis, the analyst reviews the data collected and finds a large percentage of records are missing values. Which activity would the analyst perform in order to use this dataset?