EMT Practice Test

1. Question Content...

---

Question1: 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?

Question2: 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?

Question3: 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?

Question4: An analyst at a supermarket chain has been asked to extract data from multiple data sources to complete a study on customer spending habits. The analyst is going to query data from various databases. Which statement is true about database querying?

Question5: The analytics team is struggling with which recommendation to make. Their challenge is that they have five good options and this indecision is stopping them from moving forward. To help the team finalize their recommendation, the BA professional on the team recommends they complete:

Question6: 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:

Question7: The analytics team has been asked to assess sales data from their company's website with the hopes of providing insights to help increase online sales. It's the first time the team is looking at this specific data and they are concerned about the quality of data that has been captured. They decide to use the following approach as the next step:

Question8: 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?

Question9: A data scientist is performing statistical analysis and is interested in graphically depicting the data set according to the associated quartiles Minimum, First Quartile, Median, Second Quartile, Third Quartile.
Which technique would allow for the display of this statistical five number summary?

Question10: 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?

Question11: A financial software company has growth and expansion as one of their top strategic priorities for the year.
The senior executive team would like to assess their sales performance over the last 3 years to help set sales objectives. In discussion with the business analytics manager, for a comprehensive sales report, the sales lead recommends looking into the number of contracts signed over the past 3 years and the dollar value for the signed contracts. Which other question is important to consider when evaluating sales performance?

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

Question13: A database analyst is modelling a database for a large toy manufacturer. Which statement describes a logical database model?

Question14: An online retailer has been successful utilizing analytics to guide decisions on product placement and marketing spend.
Management has requested a task force be assembled to make recommendations on how to further develop their analytics capabilities. To begin this work, the task force builds a model to develop a shared understanding about customer segments, customer relationships, key partnerships, and the company's value proposition. The team has leveraged the following model to facilitate this discussion?

Question15: The analytics team is identifying research questions to address a business problem. The business analysis professional reminds the team that the most important dimension to consider is the:

Question16: The analytics team is assessing the results of their analysis. They are surprised to find that their data indicates two events seem to be strongly related even though the general belief in the organization is that they are independent of each other. Knowing that this information will be used for decision making, they are concerned about presenting this data. At an impasse, the business analysis professional reminds them that the data can be presented as long as the team has:

Question17: A manufacturing company, specializing in turf maintenance equipment, has recently seen a decline in their lawn mower sales. As a result, the analytics team is asked to review the latest customer satisfaction survey results. An analyst on this team creates a report for senior management with attractive visuals, supported by the KPI results. Upon reviewing the report, the analyst's manager mentions that the report is missing the narrative. What does this mean?

Question18: Insights based on the data collected indicate that a multi-national company could increase its sales of a mature product by reducing its price by 20% which would result in increased revenues of 2% over a 6-month period.
The team recommends this as an appropriate goal for its organization. This is considered a good goal because:

Question19: An analytics team has been asked to answer the following question: "Given that you're a customer, would you work at our company?" The team is concerned about answering this question because it is:

Question20: What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order?

Question21: A large car manufacturer is interested in comparing the number of sales for a specific model of electric car across all 50 US states.
The data analytics team sourced and acquired the data, and the business analyst created the model to compare sales across states.
In a meeting to review the results, the feedback received included several complaints concerning an inability to distinguish the number of sales per state. What model would result in such confusion?

Question22: A large telecommunications company wants to increase their Average Revenue Per User per month by 5%, by end of year, to increase revenue in a highly competitive market. From a SMART target perspective, what is missing?

Question23: An analyst at a bank is trying to identify research questions for an analytical study on top customer issues across branches. During an interview with a branch manager, the analyst asks the manager what their top customer concerns are relating to this branch?
After the manager's reply, the analyst asks a follow up question on how their top customer concerns compare against the top customer concerns across all branches? Was the analyst's follow-up question valid?

Question24: 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:

Question25: To gain traction on online sales, a retailer initiated a marketing campaign using banner ads. The company has requested their analytics team to evaluate the performance of the campaign. During the presentation, the analyst confirmed that the campaign did bring in a large number of net new customers to the website and met the target sales conversion rate. They also noted that there was a high number of repeat visitors not completing a sale. What decision would help the retailer improve sales conversion rates for repeat visitors?

Question26: 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:

Question27: With the recent departure of two of its employees, an IT helpdesk team is now understaffed and finding it difficult to keep up with the current workload. The number of tickets being received has increased as well as the number of days to resolve the tickets. The IT manager has set up a meeting with the IT director to request funding for two new helpdesk agents. To prepare for the meeting, the manager is interested in showing the tickets processed against ticket volume over the past year.
What type of chart should the manager use to effectively show the change in processing rate over time?

Question28: 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?

Question29: 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?

Question30: An online retailer of men's athletic apparel is seeking to become the market leader in the industry. To deliver on this strategy, the analytics team continuously collects data on the prices of competitor products and uses this information to adjust the retailer's prices. What type of analytics is the retailer using to maintain their pricing structure?

Question31: The research question prompting the use of analytics is well-defined. The team obtains the results and determines that the source data did not provide reliable results. As a result of this finding, the team modifies the original question to one that can be answered by the data. What is a risk that could impact the value of this analysis?

Question32: A business analyst constructs a model they would like to review with key business stakeholders but decides to review the model first with the data scientist who has performed the data analysis. The data scientist provides some suggestions on how to reduce the complexity in the model. One suggestion is to use color to group objects needing to be associated. The data scientist is encouraging using which Gestalt Principle of Perception with regards to data visualization?