- All Exams Instant Download
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...
Which of the following should be the total number of datapoints on the next day?
An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was...
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 types of charts should be considered to BEST display the data?
An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available: Which of the following types of charts should be considered to BEST display the data?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 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 must be done to the Genre column before this task can be completed?
A data analyst for a media company needs to determine the most popular movie genre. Given the table below: Which of the following must be done to the Genre column before this task can be completed?A . AppendB . MergeC . ConcatenateD . DelimitView AnswerAnswer: D Explanation: Delimiting is the...
Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?
Given the following customer and order tables: Which of the following describes the number of rows and columns of data that would be present after performing an INNER JOIN of the tables?A . Five rows, eight columnsB . Seven rows, eight columnsC . Eight rows, seven columnsD . Nine rows,...
