Objective 7.2 Democratize Data CERTIFIED-DATA-SCIENCE-PRACTITIONER Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A retail company's marketing team wants to use a new analytics tool, but they are making errors in interpreting the results, such as confusing correlation with causation. The team has access to the tool but no formal training. What is the most effective way to address this?

   • ARemove the analytics tool from the marketing team to prevent errors.
   • BProvide targeted training on data interpretation, including common pitfalls like correlation vs. causation.
   • CAdd more advanced features to the tool to help the team analyze data more deeply.
   • DHave the data science team review all marketing analyses before they are used.
   Reveal Solution Discussion Select an answer first
2. 7expert · hard

   A company has deployed a self-service BI platform, but some employees are creating reports that show conflicting results for the same metric. The data team is overwhelmed with support requests. What is the best way to reduce conflicting reports and support burden?

   • ALet employees resolve conflicts on their own to encourage collaboration.
   • BEstablish a center of excellence that defines standard metrics, provides documentation, and offers office hours for support.
   • CDisable the self-service platform and have the data team create all reports.
   • DProvide a FAQ document and do nothing else.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A financial services firm wants to give its financial advisors access to client portfolio data for analysis. The data is sensitive and subject to regulations. What is the best way to provide access while maintaining security?

   • AEmail advisors a spreadsheet of all client data on a weekly basis.
   • BGrant advisors direct access to the production database with full read/write permissions.
   • CSet up a secure data sandbox with de-identified data and strict access controls.
   • DProvide advisors with a read-only copy of the full database on their local machines.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A data science team wants to make a dataset available to a broader group of stakeholders while ensuring that only authorized users can view sensitive fields. Which approach best balances wider access with appropriate controls?

   • AProvide role-based access to a governed data catalog and provision read-only views that mask sensitive columns for non-privileged users.
   • BEmail a copy of the full dataset to each stakeholder and ask them to keep it confidential.
   • CPublish the dataset on a public cloud storage bucket with no access restrictions so all stakeholders can reach it.
   • DGrant every stakeholder direct database administrator privileges so they can query any table they need.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A retail company wants to enable store managers to create their own sales reports without relying on the IT team. The managers have basic Excel skills but no SQL experience. What should the company implement to meet this need?

   • ADeploy a self-service BI platform with pre-built data models and drag-and-drop report building.
   • BSend store managers a weekly email with a static Excel file of sales data.
   • CProvide direct SQL access to the production database for all store managers.
   • DCreate a shared folder with CSV exports of all sales transactions.
   Reveal Solution Discussion Select an answer first