- All Exams Instant Download
Which of the following is the FIRST step the analyst should perform with the data?
An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?A . Conduct an exploratory analysis and use descriptive statistics.B . Conduct a trend analysis and use a scatter chart.C . Conduct a link analysis and illustrate the...
Which of the following data manipulation techniques should the analyst perform?
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?A . ImputingB . TransposingC . ParsingD . ConcatenatingView AnswerAnswer: C Explanation: Parsing is the data manipulation technique that should be used...
Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?
Which of the following describes the method of sampling in which elements of data are selected randomly from each of the small subgroups within a population?A . Simple randomB . ClusterC . SystematicD . StratifiedView AnswerAnswer: D Explanation: This is because stratified is a type of sampling in which elements...
Which of the following types of charts should be considered?
A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts...
Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?
Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?A . Data encryption.B . Data transmission.C . Data protection.D . Data masking.View AnswerAnswer: A Explanation: Data encryption can be used to...
Which of the following types of analysis would this practice be considered?
A company’s marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought the product, at what frequency, and at what value. Which of the following types of analysis would this...
Which of the following would be considered non-personally identifiable information?
Which of the following would be considered non-personally identifiable information? A. Cell phone device name B. Customer’s name C. Government ID number D. Telephone numberView AnswerAnswer: A Explanation: Non-personally identifiable information (non-PII) is any data that cannot be used to identify, contact, or locate a specific individual, either alone or...
Which of the following date parameters should the analyst use?
Q3 2020 has just ended, and now a data analyst needs to create an ad-hoc sales report that demonstrates how well the Q3 2020 promotion went versus last year's Q3 promotion. Which of the following date parameters should the analyst use?A . 2019 vs. YTD 2020B . Q3 2019 vs....
Which of the following is a characteristic of a relational database?
Which of the following is a characteristic of a relational database?A . It utilizes key-value pairs.B . It has undefined fields.C . It is structured in nature.D . It uses minimal memory.View AnswerAnswer: C Explanation: It is structured in nature. This is because a relational database is a type of...
Which of the following would be the BEST way to provide this visibility?
A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals’ earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to...
