Download Data Driven Consulting Silver Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which data type is best suited for representing categories such as "Red," "Blue," and "Green"? A) Numerical B) Categorical C) Ordinal D) Boolean Answer: B Explanation: Categorical data represent distinct categories or groups without inherent order, making them suitable for labels like "Red," "Blue," and "Green." Question 2. In a data frame, which structure is most appropriate for storing a dataset with multiple variables and observations? A) Array
B) List C) Data frame D) Scalar Answer: C Explanation: A data frame is a tabular data structure ideal for storing multidimensional data with rows (observations) and columns (variables). Question 3. Which principle is essential in data governance to ensure data is accurate, consistent, and accessible? A) Data encryption B) Data ownership C) Data anonymization D) Data visualization
Question 5. Under GDPR regulations, which of the following practices is most important to ensure data privacy? A) Data encryption B) Data anonymization and obtaining user consent C) Data visualization D) Data backup procedures Answer: B Explanation: GDPR emphasizes the importance of obtaining explicit consent and anonymizing data to protect individual privacy rights. Question 6. Which descriptive statistic provides the middle value when data is ordered from smallest to largest? A) Mean B) Median
C) Mode D) Standard deviation Answer: B Explanation: The median is the middle value in an ordered dataset, useful for understanding central tendency, especially with skewed data. Question 7. Which visualization would best display the distribution of ages in a customer database? A) Bar chart B) Histogram C) Line chart D) Pie chart Answer: B
Question 9. Which technique is most suitable for identifying relationships between two numerical variables? A) Correlation analysis B) Logistic regression C) Cluster analysis D) Time series analysis Answer: A Explanation: Correlation analysis measures the strength and direction of the linear relationship between two continuous variables. Question 10. Which machine learning model is typically used for binary classification problems? A) Linear regression B) Logistic regression
C) K-means clustering D) Time series forecasting Answer: B Explanation: Logistic regression models the probability of binary outcomes, making it suitable for classification tasks like yes/no decisions. Question 11. In predictive modeling, which metric is most appropriate for evaluating the accuracy of a classification model? A) Mean squared error B) R-squared C) Accuracy score D) Correlation coefficient Answer: C
Question 13. Which of the following best describes the purpose of A/B testing? A) To build predictive models B) To compare two versions of a product or feature to determine which performs better C) To analyze customer segmentation D) To visualize data distributions Answer: B Explanation: A/B testing involves comparing two variants to assess which one leads to better outcomes based on statistical analysis. Question 14. In SQL, which statement is used to select specific columns from a table? A) INSERT
B) UPDATE
C) SELECT
D) DELETE
Answer: C Explanation: The SELECT statement retrieves specific columns or all data from a table for analysis or reporting. Question 15. Which Python library is most commonly used for data manipulation and analysis? A) Matplotlib B) Pandas C) Seaborn D) NumPy
Question 17. Which BI tool feature allows users to dynamically explore data through filters and drill-downs? A) Static report B) Dashboard C) Pivot table D) Interactive visualization Answer: D Explanation: Interactive visualizations enable users to explore data interactively, applying filters and drill-downs. Question 18. Which Excel feature is most useful for summarizing large datasets and analyzing patterns? A) Cell formatting B) Pivot tables
C) Conditional formatting D) Data validation Answer: B Explanation: Pivot tables summarize and analyze large datasets efficiently, revealing patterns and insights. Question 19. Which data source is most likely to contain real-time data suitable for operational decision-making? A) Public API B) Static CSV file C) Archived reports D) External research papers Answer: A
A) Customer ID numbers B) Customer satisfaction ratings (e.g., 1-5) C) Product categories (e.g., Electronics, Clothing) D) Boolean true/false values Answer: B Explanation: Ordinal data have a meaningful order but not equal intervals, such as satisfaction ratings. Question 22. When evaluating the relevance of a third-party data source, which factor is most critical? A) Data format B) Data licensing restrictions C) Source credibility and data accuracy
D) Data visualization tools used Answer: C Explanation: The credibility and accuracy of the data source determine its relevance and reliability for analysis. Question 23. Which principle supports responsible data use by ensuring individuals are informed and consent to data collection? A) Data encryption B) Data anonymization C) Data privacy and ethics D) Data normalization Answer: C Explanation: Data privacy and ethics emphasize transparency and obtaining consent to respect individual rights and prevent bias.
B) Pie chart C) Scatter plot D) Line chart Answer: B Explanation: Pie charts effectively illustrate the relative proportions of different categories. Question 26. Which technique helps identify whether a pattern in data is statistically significant? A) Correlation analysis B) Hypothesis testing C) Data normalization D) Data aggregation
Answer: B Explanation: Hypothesis testing assesses the likelihood that observed patterns are due to chance, establishing statistical significance. Question 27. Which algorithm is typically used for customer segmentation based on purchase behavior? A) K-means clustering B) Linear regression C) Logistic regression D) Time series analysis Answer: A Explanation: K-means clustering groups customers into segments based on similar features like purchase behavior.
