- All Exams Instant Download
Which of the following is the BEST way to meet this stakeholder requirement?
A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?...
Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?
Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?A . Rephrase the business requirement.B . Determine the data necessary for the analysis.C . Build a mock dashboard/presentation layout.D . Perform exploratory data analysis.View AnswerAnswer: B Explanation: Exploratory data analysis (EDA) is...
Which of the following steps should be taken to ensure data consistency?
While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?A . Delete any of the responses that do not have “January” written out.B . Replace any of the...
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...
Which of the following should the data analyst use to BEST communicate this information to the manager?
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?A...
Which of the following functions will allow the data analyst to organize the table in this manner?
A data analyst has been asked to organize the table below in the following ways: By sales from high to low - By state in alphabetic order - Which of the following functions will allow the data analyst to organize the table in this manner?A . Conditional formattingB . GroupingC...
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:
A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:A . transactional schema.B . star schema.C . non-relational schema.D . snowflake schema.View AnswerAnswer:...
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...
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...
Which of the following is an example of a discrete data type?
Which of the following is an example of a discrete data type?A . 8in (20cm)B . 5 kidsC . 2.5mi (4km)D . 10.7lbs (4.9kg)View AnswerAnswer: B Explanation: A discrete data type is a data type that can only take on a finite number of values, such as integers or categories....
