foundations of business intelligence coursera week 1 quiz answers
Test your knowledge: Organizations and teams that benefit from business intelligence
1. What are the typical responsibilities of a business intelligence analyst? Select all that apply.
- Create visualizations, dashboards, and reports.
- Retrieve, organize, and interpret an organization’s data.
- Gather requirements from stakeholders, partners, and team members.
- Evaluate and streamline devices, infrastructures, and information channels.
2. Fill in the blank: To enable different computer programs to communicate with one another, companies can use an application programming _____. This is a set of functions and procedures that integrate diverse systems.
- channel
- interface
- requirement
- dashboard
3. Which stakeholders do business intelligence professionals collaborate with in order to maximize available data and data tools?
- Data analysts
- Data governance professionals
- Information technology professionals
- Data warehousing specialists
Test your knowledge: Business intelligence structures and stages
4. A business intelligence professional is considering how effectively their team is able to use the data available to them in order to extract actionable insights. What BI concept is the focus of this situation?
- Data analysis
- Data governance
- Data structure
- Data maturity
5. In business intelligence, which stage might involve querying a database to return a financial dataset or accessing a spreadsheet of marketing campaign data?
- Capture
- Analyze
- Share
- Monitor
6. In what ways might data analysis be used in order to help business intelligence professionals provide data-driven insights? Select all that apply.
- Examining data more in-depth
- Automating processes and information channels
- Exploring why things happened
- Understanding relationships between data points
Test your knowledge: How business intelligence makes an impact
7. What concept involves managing the people, processes, and tools used in the business intelligence process?
- Business intelligence governance
- Data governance
- Business intelligence strategy
- Data maturity
8. A data pipeline is a series of processes that transports data from different sources to a new destination. What happens to the data at this destination?
- Live monitoring
- Graphical representation
- Archival or destruction
- Storage and analysis
9. A business intelligence professional wants to improve a procedure in order to achieve better outcomes. To do this, they repeat the procedure over and over until they get closer to the desired results. What business intelligence concept does this situation describe?
- Transformation
- Monitoring
- Iteration
- Flow
Assess your readiness for the Google Business Intelligence Certificate
10. What is data science?
- A process used to solve complex problems in a user-centric way
- A field of study that uses data to create new ways of modeling and understanding the unknown
- A tool for organizing data elements and how they relate to one another
- The collection, transformation, and organization of data in order to draw conclusions, and drive informed decision-making
11. What is the key difference between qualitative and quantitative data?
- Qualitative data describes the kind of data being analyzed; quantitative data describes how much data is being analyzed.
- Qualitative data is about the quality of a product or service; quantitative data is about how much of that product or service is available in the marketplace.
- Qualitative data is subjective; quantitative data is specific.
- Qualitative data measures qualities and characteristics; quantitative data measures numerical facts.
12. Which of the following statements accurately describe wide and long data? Select all that apply.
- Long data subjects can have multiple rows that hold the values of subject attributes.
- Wide data subjects can have multiple rows that hold the values of subject attributes.
- Long data subjects can have data in multiple columns.
- Wide data subjects can have data in multiple columns.
13. Structured data is likely to be found in which of the following formats? Select all that apply.
- Audio file
- Database table
- Digital photo
- Spreadsheet
14. Fill in the blank: A Boolean data type can have _____ possible values.
- three
- infinite
- two
- five
15. What is the term for the individuals who have invested time and resources in a project and are interested in its outcome?
- Stakeholders
- Project sponsors
- Subject-matter experts
- Executives
16. When collecting data for a study, what are some reasons to consider sample size? Select all that apply.
- To collect data that represents a diverse set of perspectives
- To eliminate certain segments of a population
- To include as many participants as possible in the study
- To make sure a few unusual responses don’t skew results
17. The SMART methodology can be used to ask a question that promotes change. What type of SMART question leads to change?
- Motivational
- Results-focused
- Action-oriented
- Transformational
18. Which of the following inquiries are leading questions? Select all that apply.
- What do you enjoy most about our service?
- How did you learn about our company?
- How satisfied were you with our customer representative?
- In what ways did our product meet your needs?
19. Which of the following data security tools can be used to ensure only specific people can access, edit, and download a spreadsheet? Select all that apply.
- Tabs
- Filters
- Encryption
- Sharing permissions
20. Which type of bias is the tendency to construe ambiguous situations in a positive or negative way?
- Cultural bias
- Confirmation bias
- Observer bias
- Interpretation bias
21. Before completing a survey, an individual acknowledges reading information about how and why the data they provide will be used. What concept does this describe?
- Openness
- Consent
- Privacy
- Transaction transparency
22. A data analyst commits a SQL query to a repository as a new and improved query. Then, they specify the modifications they made during data cleaning and why they were made. What process does this scenario describe?
- Creating a changelog
- Data reporting
- Sharing results
- Data transferal
23. Fill in the blank: To remove leading, trailing, and repeated spaces when cleaning data, use the _____ function.
- EXTRACT
- CLEAN
- TRIM
- CLIP
24. Which spreadsheet tool changes how cells appear when values meet a specific condition?
- Data validation
- Protected ranges
- Conditional formatting
- Alternating colors
25. Fill in the blank: In a spreadsheet, the SPLIT function divides a text string around a ___ and puts each fragment into a new, separate cell.
- substring
- indicator
- delimiter
- mark
26. The date and time a photo was taken is an example of which kind of metadata?
- Descriptive
- Structural
- Administrative
- Representative
27. In spreadsheets, an absolute reference is used to lock a function array so that rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?
- Ampersand (&)
- Dollar sign ($)
- Asterisk (*)
- Hash (#)
28. Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?
- VLOOKUP
- VALIDATE
- VALUE
- VIEW
29. When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?
- RIGHT
- INNER
- LEFT
- OUTER
30. In a SQL query, which calculation does the modulo (%) operator perform?
- It applies an exponent to a value.
- It converts a decimal to a percent.
- It returns the remainder of a division calculation.
- It finds the square root of a number.
31. What are the main benefits of using a programming language to work with data? Select all that apply.
- Save time
- Clarify the steps of analysis
- Easily reproduce and share work
- Automate decision-making
32. What goals are programming languages designed to achieve? Select all that apply.
- Data transformation
- Data visualization
- Data cleaning
- Data governance
33. What is the term for programming code that is freely available and may be modified and shared by the people who use it?
- Open-source
- Non-dependant
- Common-design
- One-access
34. To demonstrate how often data values fall into certain ranges, what type of data visualization should be used?
- Correlation chart
- Bar chart
- Histogram
- Tree map
35. A dashboard is designed to share insights about the housing market in a city. What type of data visualization would be most effective at demonstrating how the city’s annual home sales have risen over time?
- Scatter plot
- Line chart
- Area chart
- Pie chart
36. What type of visualizations enable the data in a presentation to automatically update and change over time?
- Static
- Discrete
- Customized
- Dynamic
37. Why is it more effective to label a data visualization instead of using a legend? Select all that apply.
- Labels allow for text explanations to be placed directly on the visualization.
- Labels make the data visualization more accessible because they don’t rely on the ability to interpret color.
- Labels can be placed near the data, whereas legends are typically positioned away from the data.
- Labels help keep people’s attention on relevant data by redirecting their focus away from outliers.
38. A data visualization reveals two variables in the data that rise and fall at the same time. When variables are related in this way, what is likely happening?
- Causation
- Polarity
- Divergence
- Correlation
39. Which of the following are appropriate uses for filters in data visualization tools? Select all that apply.
- Hiding outliers that do not support the hypothesis
- Limiting the number of rows or columns in view
- Providing data to different users based on their particular needs
- Highlighting individual data points
Weekly challenge 1
40. A business analyst automates processes and information channels in order to transform data into actionable insights. Then, they share these insights with decision-makers. What concept does this scenario describe?
- Business intelligence
- Business metrics
- Business strategy
- Business monitoring
41. What are some of the primary responsibilities of a business intelligence analyst? Select all that apply.
- Create visualizations, dashboards, and reports to use when presenting and communicating insights
- Use an understanding of large datasets to retrieve, organize, and interpret data
- Evaluate and streamline various devices, infrastructures, and information channels
- Gather requirements from stakeholders, partners, and team members
42. Fill in the blank: To enable disparate _____ to communicate, business intelligence professionals integrate them using an application programming interface.
- databases
- file managers
- data repositories
- computer programs
43. Which team members maximize a company's software and hardware resources so they may be used effectively in business intelligence projects?
- Project managers
- Information technology professionals
- Data analysts
- Data warehousing professionals
44. A business intelligence professional learns that a company is not using customer data to make decisions. What actions might they make in order to achieve higher levels of data maturity? Select all that apply.
- Build data-reporting tools
- Create dashboards to continuously analyze and monitor data
- Examine data through a specific topic or subject-matter lens
- Establish repeatable methods for monitoring operations
45. A business intelligence professional is working for a global food service provider. In which business intelligence stage might they download a spreadsheet that contains data about grocery orders over the past six months?
- Report
- Analyze
- Capture
- Monitor
46. What events might occur during the monitor stage of the business intelligence process? Select all that apply.
- Decision-makers are given business insights through a dashboard.
- A company uses automated processes to transform data into intelligence.
- A company transforms data in order to investigate more deeply.
- Information channels provide data that reveals a business opportunity.
47. Business intelligence strategy is the management of the people, processes, and tools used in the business intelligence process. What are some key considerations with regard to the processes part of this concept? Select all that apply.
- Training and educating users
- Creating a feedback system to confirm that users are getting value from the tools
- Asking data governance professionals about the solutions being used
- Establishing key performance indicators
48. Which business intelligence tool is used to keep data consistent across systems and explain to users how it’s organized?
- Data visualizations
- Dashboards
- Data models
- Pipelines
49. What business intelligence process involves gathering data from source systems, converting it into a useful format, and bringing it into a unified system?
- Data models
- Data visualization
- ETL
- Dashboard
50. In order to transform data into actionable insights, what do business intelligence professionals work to automate? Select all that apply.
- Information channels
- Processes
- Models
- Iterations
51. Which of the following statements accurately describe what data analytics and business intelligence professionals do when working to achieve higher levels of data maturity? Select all that apply.
- Business intelligence analysts ensure reporting tools are practical and efficient.
- Both use data to answer questions about what happened.
- Business intelligence analysts build data-reporting tools and dashboards for continuous monitoring.
- Data analysts solve business problems by examining data through a specific topic or subject-matter lens.
52. What are stakeholders most likely to do during the business intelligence monitor stage?
- Gain insights about what’s happening in the organization right now
- Understand why something happened
- Identify connections that were not easily apparent
- Discover key relationships between data points
53. Business intelligence strategy is the management of the people, processes, and tools used in the business intelligence process. What are some key considerations with regard to the people part of this concept? Select all that apply.
- Getting feedback from people with diverse perspectives
- Understanding the vision for the business intelligence process
- Documenting everything that has been learned
- Deciding who is responsible for business intelligence governance
54. Fill in the blank: To get clear directions when navigating a database, business intelligence professionals use _____, which organize data elements and how they relate to one another.
- dashboards
- data visualizations
- pipelines
- data models
55. Fill in the blank: Business intelligence involves automating processes and information channels in order to transform relevant data into _____ for decision-makers.
- actionable insights
- connected systems
- business strategies
- relevant metrics
56. Which of the following statements correctly describes the roles of business intelligence engineers versus business intelligence analysts?
- Engineers apply their knowledge of large datasets; analysts are responsible for less complex types of intelligence.
- Engineers gather requirements from stakeholders; analysts apply those requirements to evaluate devices, infrastructures, and information channels.
- Engineers create data visualizations, dashboards, and reports; analysts present their findings to team members.
- Engineers design, configure, implement, and improve tools; analysts use those tools to retrieve, organize, and interpret data.
57. Business intelligence projects often require the help of information technology (IT) professionals. What are some of the typical responsibilities of these team members? Select all that apply.
- Write code specific to the project goals
- Install, repair, and upgrade hardware
- Test software
- Bring data into an internal company database
58. A business intelligence professional is building data-reporting tools and creating dashboards that continuously analyze and monitor data. What business intelligence goal does this situation describe?
- Collecting, transforming, and organizing data
- Achieving higher levels of data maturity
- Using data to answer questions about what happened
- Solving problems by examining the data through a specific topic or subject-matter lens
59. What are some of the primary responsibilities of a business intelligence engineer? Select all that apply.
- Create visualizations, dashboards, and reports to use when presenting and communicating insights
- Design, configure, implement, and improve data tools and processes
- Evaluate and streamline various devices, infrastructures, and information channels
- Troubleshoot and find solutions to security issues, application permissions, and updates
60. Fill in the blank: ETL is a type of _____ that enables data to be gathered from source systems, converted into a useful format, and brought into a data warehouse or other unified destination system.
- package
- dashboard
- programming language
- pipeline