Download Data Driven Consulting Silver Professional Certificate (Intermediate) Exam and more Exams Technology in PDF only on Docsity!
Professional Certificate (Intermediate)
Exam
Question 1. Which mindset is essential for a data-driven consultant to effectively translate business challenges into analytical solutions? A) Technical proficiency alone B) Business impact focus combined with stakeholder management C) Data storage expertise only D) Pure statistical analysis skills Answer: B Explanation: A data-driven consultant must focus on business impact and stakeholder management, integrating technical skills with strategic understanding to deliver actionable insights aligned with business goals. Question 2. What is the primary purpose of hypothesis testing in data analysis?
Professional Certificate (Intermediate)
Exam
A) To confirm preconceived notions without data B) To identify causal relationships without data collection C) To validate or invalidate assumptions based on data evidence D) To generate data without a specific question in mind Answer: C Explanation: Hypothesis testing helps determine whether the data provides sufficient evidence to support or refute initial assumptions, enabling data- driven decision-making. Question 3. Which regulation emphasizes the importance of data privacy rights and consent in the EU? A) CCPA
Professional Certificate (Intermediate)
Exam
C) Storytelling supported by clear visualizations tailored to the audience D) Avoiding visual aids to focus on verbal explanations Answer: C Explanation: Effective communication involves storytelling supported by visualizations that are simple, clear, and tailored to the audience’s level of technical understanding. Question 5. Which data source type is typically structured and stored in tabular format? A) Flat files B) Relational databases C) APIs
Professional Certificate (Intermediate)
Exam
D) Unstructured text files Answer: B Explanation: Relational databases organize data in structured tables with rows and columns, facilitating efficient querying and retrieval. Question 6. What is a common method for extracting data from relational databases? A) Using Python scripts only B) Manual copy-paste C) SQL queries D) Data visualization tools Answer: C
Professional Certificate (Intermediate)
Exam
Question 8. What is the purpose of feature engineering in data analysis? A) To reduce data size by removing features B) To create new variables that improve model performance C) To eliminate irrelevant data D) To visualize data better Answer: B Explanation: Feature engineering involves creating new features from existing data to enhance the predictive power of models. Question 9. Which descriptive statistic provides the middle value in a sorted dataset?
Professional Certificate (Intermediate)
Exam
A) Mean B) Mode C) Median D) Standard deviation Answer: C Explanation: The median is the middle value that separates the higher half from the lower half of the dataset. Question 10. Which visualization best illustrates the distribution of a continuous variable? A) Bar chart B) Histogram
Professional Certificate (Intermediate)
Exam
Answer: B Explanation: Logistic regression is designed to model binary outcomes, estimating the probability of class membership. Question 12. What is the primary goal of decision tree modeling? A) To cluster data points B) To predict continuous outcomes only C) To create interpretable rules for classification or regression D) To reduce data dimensionality Answer: C Explanation: Decision trees generate clear, interpretable rules for classification or regression tasks based on feature splits.
Professional Certificate (Intermediate)
Exam
Question 13. When designing dashboards, what principle is most important? A) Overloading with all available data B) Simplicity and ease of interpretation C) Using as many colors as possible D) Including complex statistical details Answer: B Explanation: Dashboards should be simple, intuitive, and focused, enabling users to easily interpret key insights without being overwhelmed. Question 14. Which statistical concept is essential for determining whether an observed difference in an A/B test is significant?
Professional Certificate (Intermediate)
Exam
C) Using data without consent for better insights D) Prioritizing algorithm accuracy over ethical concerns Answer: B Explanation: Data ethics involves respecting privacy, avoiding bias, and ensuring responsible use of data to maintain trust and fairness. Question 16. Which data source type often provides real-time data through APIs? A) Flat files B) Relational databases C) Web services and APIs D) Paper records
Professional Certificate (Intermediate)
Exam
Answer: C Explanation: APIs (Application Programming Interfaces) enable real-time data retrieval from various online platforms and services. Question 17. Which data transformation technique converts categorical variables into a format suitable for modeling? A) Binning B) Standardization C) One-hot encoding D) Scaling Answer: C
Professional Certificate (Intermediate)
Exam
Question 19. Which visualization is most appropriate for showing relationships between two continuous variables? A) Bar chart B) Scatter plot C) Pie chart D) Histogram Answer: B Explanation: Scatter plots effectively display the relationship or correlation between two continuous variables.
Professional Certificate (Intermediate)
Exam
Question 20. Which predictive modeling technique is particularly suitable for understanding feature importance? A) Linear regression B) Decision trees C) K-means clustering D) PCA Answer: B Explanation: Decision trees inherently provide feature importance metrics based on how often and effectively features are used for splits. Question 21. What is the primary purpose of cross-validation in model evaluation?
Professional Certificate (Intermediate)
Exam
C) Using complex visualizations to impress users D) Displaying raw data tables only Answer: B Explanation: Focusing on key KPIs with clear visualizations simplifies understanding and supports decision-making. Question 23. Which is a key ethical consideration when deploying AI models? A) Maximizing model complexity regardless of transparency B) Ensuring models do not perpetuate biases or discrimination C) Removing all data privacy safeguards D) Prioritizing speed over fairness Answer: B
Professional Certificate (Intermediate)
Exam
Explanation: Ethical AI deployment requires ensuring models are fair, unbiased, and respect privacy to prevent harm and discrimination. Question 24. In data sourcing, what does “data quality” primarily refer to? A) The volume of data collected B) The accuracy, completeness, and consistency of data C) The speed of data retrieval D) The variety of data sources Answer: B Explanation: Data quality encompasses accuracy, completeness, consistency, and reliability—crucial for valid analysis.
