All Coursera Quiz Answers

Assess your readiness for the Google Business Intelligence Certificate Quiz Answers

by Niyander

In this article i am gone to share Assess your readiness for the Google Business Intelligence Certificate Quiz Answers with you..

Also read:  Microsoft Create Serverless Applications Coursera Quiz Answers

 

The following questions are designed to help you assess your comfort level with general data analytics principles and data types. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 1)
What is data science?

  • A process used to solve complex problems in a user-centric way
  • The collection, transformation, and organization of data in order to draw conclusions, and drive informed decision-making
  • 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

Question 2)
What is the key difference between qualitative and quantitative data?

  • Qualitative data measures qualities and characteristics; quantitative data measures numerical facts.
  • Qualitative data is subjective; quantitative data is specific.
  • 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 describes the kind of data being analyzed; quantitative data describes how much data is being analyzed.

Question 3)
Which of the following statements accurately describe wide and long data? Select all that apply.

  • Wide data subjects can have multiple rows that hold the values of subject attributes.
  • Wide data subjects can have data in multiple columns.
  • Long data subjects can have data in multiple columns.
  • Long data subjects can have multiple rows that hold the values of subject attributes.

Question 4)
Structured data is likely to be found in which of the following formats? Select all that apply.

  • Spreadsheet
  • Digital photo
  • Database table
  • Audio file

Question 5)
Fill in the blank: A Boolean data type can have _____ possible values.

  • three
  • two
  • five
  • infinite

The following questions are designed to help you assess your comfort level with data strategy. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 6)
What is the term for the individuals who have invested time and resources in a project and are interested in its outcome?

  • Subject-matter experts
  • Stakeholders
  • Project sponsors
  • Executives

Question 7)
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

Question 8)
The SMART methodology can be used to ask a question that promotes change. What type of SMART question leads to change?

  • Motivational
  • Action-oriented
  • Results-focused
  • Transformational

Question 9)
Which of the following inquiries are leading questions? Select all that apply.

  • How did you learn about our company?
  • What do you enjoy most about our service?
  • In what ways did our product meet your needs?
  • How satisfied were you with our customer representative?

Question 10)
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.

  • Encryption
  • Filters
  • Tabs
  • Sharing permissions

The following questions are designed to help you assess your comfort level with data integrity and data cleaning. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 11)
Which type of bias is the tendency to construe ambiguous situations in a positive or negative way?

  • Cultural bias
  • Interpretation bias
  • Observer bias
  • Confirmation bias

Question 12)
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?

  • Transaction transparency
  • Consent
  • Privacy
  • Openness

Question 13)
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

Question 14)
Fill in the blank: To remove leading, trailing, and repeated spaces when cleaning data, use the _____ function.

  • CLIP
  • CLEAN
  • EXTRACT
  • TRIM

Question 15)
Which spreadsheet tool changes how cells appear when values meet a specific condition?

  • Protected ranges
  • Alternating colors
  • Data validation
  • Conditional formatting

Question 16)
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.

  • indicator
  • delimiter
  • substring
  • mark

The following questions are designed to help you assess your comfort level with spreadsheet and SQL tools for data aggregation and analysis. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 17)
The date and time a photo was taken is an example of which kind of metadata?

  • Representative
  • Descriptive
  • Structural
  • Administrative

Question 18)
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 ($)
  • Hash (#)
  • Asterisk (*)

Question 19)
Which spreadsheet function vertically searches for a certain value in a column in order to return a corresponding piece of information?

  • VLOOKUP
  • VALUE
  • VALIDATE
  • VIEW

Question 20)
When creating a SQL query, which JOIN clause returns all matching records in two or more database tables?

  • INNER
  • RIGHT
  • LEFT
  • OUTER

Question 21)
In a SQL query, which calculation does the modulo (%) operator perform?

  • It returns the remainder of a division calculation.
  • It applies an exponent to a value.
  • It converts a decimal to a percent.
  • It finds the square root of a number.

The following questions are designed to help you assess your comfort level with programming languages. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 22)
What are the main benefits of using a programming language to work with data? Select all that apply.

  • Automate decision-making
  • Easily reproduce and share work
  • Clarify the steps of analysis
  • Save time

Question 23)
What goals are programming languages designed to achieve? Select all that apply.

  • Data visualization
  • Data cleaning
  • Data governance
  • Data transformation

Question 24)
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

The following questions are designed to help you assess your comfort level with data visualization, dashboards, and sharing insights with others. Use them to self-reflect and make your own decisions about the foundational knowledge you need to be successful in this course.

Question 25)
To demonstrate how often data values fall into certain ranges, what type of data visualization should be used?

  • Bar chart
  • Correlation chart
  • Histogram
  • Tree map

Question 26)
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?

  • Pie chart
  • Scatter plot
  • Line chart
  • Area chart

Question 27)
What type of visualizations enable the data in a presentation to automatically update and change over time?

  • Customized
  • Static
  • Discrete
  • Dynamic

Question 28)
Why is it more effective to label a data visualization instead of using a legend? Select all that apply.

  • Labels make the data visualization more accessible because they don’t rely on the ability to interpret color.
  • Labels allow for text explanations to be placed directly on the visualization.
  • Labels help keep people’s attention on relevant data by redirecting their focus away from outliers.
  • Labels can be placed near the data, whereas legends are typically positioned away from the data.

Question 29)
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?

  • Polarity
  • Causation
  • Divergence
  • Correlation

Question 30)
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
  • Highlighting individual data points
  • Providing data to different users based on their particular needs