- All Exams Instant Download
Which one of the following is a common data warehouse schema?
Which one of the following is a common data warehouse schema?A . Snowflake.B . Square.C . Spiral.D . Sphere.View AnswerAnswer: A Explanation: Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings. The Snowflake data platform is not built...
What kind of issues is Angela facing?
Angela is aggregating data from CRM system with data from an employee system. While performing an initial quality check, she realizes that her employee ID is not associated with her identifier in the CRM system. What kind of issues is Angela facing? Choose the best answer.A . ETL process.B ....
Which of the following would BEST fulfill the analyst’s goal?
An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst’s goal?A . MedianB . MeanC...
Which one of the following tools is least likely to meet her needs?
Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders. Which one of the following tools is least likely to meet her needs?A . QuickSight.B . Tableau.C . Power BI.D . SPSS Modeler.View AnswerAnswer: D Explanation: SPSS Modeler. QuickSight,...
Which of the following report types should the data analyst create?
A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business’s performance through the second quarter. The board meeting will be held on July 15, 2020, after the numbers are finalized. Which of the following report types...
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 is used for calculations and pivot tables?
Which of the following is used for calculations and pivot tables?A . IBM SPSSB . SASC . Microsoft ExcelD . DomoView AnswerAnswer: C Explanation: This is because Microsoft Excel is a type of software application that allows users to create, edit, and analyze data in spreadsheets, which are composed of...
Which of the following components need to be added to ensure the report is point-in-time and static?
Refer to the exhibit. Given the following report: Which of the following components need to be added to ensure the report is point-in-time and static? (Choose two.)A . A control group for the phrasesB . A summary of the KPIsC . Filter buttons for the statusD . The date when...
Which of the following issues will MOST likely arise with this data?
Different people manually type a series of handwritten surveys into an online database. Which of the following issues will MOST likely arise with this data? (Choose two.)A . Data accuracyB . Data constraintsC . Data attribute limitationsD . Data biasE . Data consistencyF . Data manipulationView AnswerAnswer: A, E Explanation:...
Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?
Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?A . NumericB . DateC . FloatD . TextView AnswerAnswer: D Explanation: A telephone number formatted as XXX-XXX-XXXX would be considered a text data type, as it is composed of alphanumeric characters and symbols. A numeric...
