Google Data Analytics Certification-TEST/QUIZ QUESTIONS

Which of the following activities are part of the manage phase of the data life cycle? Select all that apply.

REFLECT ON HOW TO CARE FOR DATA Use the data solve problems DECIDE WHERE TO STORE DATA SELECT TOOLS TO HELP KEEP DATA SECURE

An _____ is a process or set of rules that may be followed in order to perform a specific task.

attribute observation ALGORITHIM equation

Data analysts use a problem-oriented approach in order to identify, _____, and solve problems.

create obscure modify DESCRIBE

An HR firm is filling open positions for administrative assistants, so they purchase online help-wanted ads. Research reveals that 87% of administrative assistants are women, so the data team decides that women are more likely to be successful applicants. Therefore, they target the ads to female job seekers. What should they have done instead?

Find an additional data source that supports the strategy to target women. Only target the ads for the administrative assistant jobs to men. Ask the executive team to decide which type of applicants to target with the ads. CONDUCT MORE RESEARCH TO UNDERSTAND THE SURROUNDING FACTORS OF THIS SITUATION

Which spreadsheet feature uses a set of instructions to perform calculations, such as multiplication or division?

Format Function Filter FORMULA

When solving the _____ problem type, a junior data analyst identifies a technological breakthrough that is likely to disrupt their industry.

identifying themes making predictions SPOTTING SOMETHING UNUSUAL discovering connections

During the _____ phase, data teams decide what kind of data is needed and who will be responsible for it.

manage PLANNING capture analyze

A university system gathers historical academic data from an outside database and information from the internal records of student applications. This work occurs during the _____ phase of the data life cycle.

manage analyze CAPTURE plan

Analytical thinking involves _____ a problem, then solving it by using data in an organized, step-by-step manner.

monitoring and assessing observing and inspecting IDENTIFYING AND DEFINING evaluating and summarizing

During the prepare step of the data analysis process, data is collected and _____ for analysis.

presented STORED cleaned interpreted

The SQL clause SELECT * is used to retrieve all data from a particular _____.

spreadsheet database TABLE cell

Fairness means ensuring that bias is neither created nor _____ by the data analysis process.

subverted REINFORCED diminished modified

In the process step, data analysts may remove _____, which are data points that lie significantly outside the overall pattern of the data and could potentially skew the information.

values OUTLIERS statistics observations

A technical mindset

The analytical skill that involves breaking processes down into smaller steps and working with them in an orderly, logical way

Data strategy

The analytical skill that involves managing the processes and tools used in data analysis

In a data analytics context, what is a business task?

The effective, ongoing management of resources The development of company goals or objectives THE QUESTION ANSWERED, OR PROBLEM SOLVED BY DATA ANALYSIS The implementation of new strategies that advance the organization

Which of the following examples demonstrate data-driven decision-making? Select all that apply.

A FINANCIAL ADVISOR INTERVIEWS CLIENTS TO ASSESS THEIR RISK TOLERANCE AND INVESTMENT GOALS IN ORDER TO CREATE PERSONALIZED PLANS A SCHOOL DISTRICT USES REPORT CARDS TO TRACK PERFORMANCE AND IDENTIFY AREAS WHERE STUDENTS NEED ADDITIONAL SUPPORT An advertising company relies on the common sense of its copywriting team when creating a new campaign. A DENTIST'S OFFICE USES SPECIFICS FROM PATIENT RECORDS TO TRACK TREATMENT OUTCOMES AND IMPROVE QUALITY OF CARE

What is a key difference between a formula and a function?

A formula is a preset command, whereas a function is a set of instructions. A FORMULA IS A SET OF INSTRUCTIONS, WHEREAS A FUNCTION IS A PRESET COMMAND. A formula automatically performs a process or task, whereas a function requires the user to type directions in order for it to execute. A formula is a more efficient way of executing a task than a function.

The question, "Which aspects of our packaging can be updated in order to make our product more customer-centric?" is _____ because it encourages change.

ACTION-ORIENTED measurable specific relevant

In the data life cycle, which phase involves using data to solve problems, make good decisions, and support business goals?

ANALYZE Capture Manage Plan

A junior data analyst is assigned a new project. They define the problem that they need to help solve and confirm they understand expectations. Which step of the data analysis process are they working in?

ASK Prepare Analyze Share

Which of the following statements accurately describe spreadsheet attributes and observations? Select all that apply.

ATTRIBTUES CAN ALSO BE REFERRED TO AS COLUMN HEADERS Observations are characteristics or qualities of data. COLUMN LABELS ARE ATTRIBUTES An observation includes all of the attributes contained in its row.

In the following query, what will be retrieved from the database? SELECT * FROM Storeroom 5 WHERE glasses = 'bifocals'

All bifocals in all storerooms All glasses in Storeroom 5 ALL GLASSES IN STOREROOM 5 THAT ARE BIFOCALS All glasses in all storerooms

Which of the following activities are elements of data-driven decision-making? Select all that apply.

Define the business need Exclude information that is based on human intuition Request observations from subject-matter experts FIND RELEVANT DATA

A data team considers how and where data will be stored, what tools are required to safeguard it, and how to maintain it properly. What phase of the data life cycle does this scenario describe?

Analyze Archive Capture MANAGE

An acquaintance tells you that they spend many hours each day "playing." To learn more, you ask them whether they play sports, a musical instrument, or something else. Their answer helps you clarify the meaning of their statement. What does this scenario describe?

Analyzing data UNDERSTANDING CONTEXT Making assumptions Testing a hypothesis

A data professional ensures their data analysis is fair by considering fairness from _____ of a project.

BEGINNING TO CONCLUSION planning to presentation outlining to reporting analysis to completion

Which of the following statements accurately describe fairness considerations in data analysis? Select all that apply.

BEST PRACTICES FOR FAIRNESS IN DATA ANALYSIS INCLUDE CONSIDERING ALL AVAILABLE DATA FAIRNESS MEANS ENSURING THAT ANALYSIS DOES NOT CREATE OR REINFORCE BIAS A data professional may include self-reported data when prioritizing fairness. Fairness practices should begin during the prepare phase of the data analysis process.

An executive might ask data team members to work on a _____ in order to address a particular question or problem using data analysis.

BUSINESS TASK relevant process stated objective measurable outcome

What type of data visualization might an analyst create in order to communicate data insights to others? Select all that apply.

CHART MAP Report GRAPH

When data professionals _____ data, they eliminate inaccuracies by transforming the data into a more useful format and removing outliers.

CLEAN analyze query store

A data professional notices that their dataset is imbalanced and therefore is not representative of the entire population. They work to get more responses from nondominant groups in order to address this issue and ensure data insights are fair. What does this scenario describe?

Context OVERSAMPLING Data cleaning Data strategy

In your role as a data professional, you examine a dataset of taxi rides to determine which hour of the day typically has the highest demand. Under which discipline does this example best fall?

DATA ANALYTICS Data wrangling Data analysis Data science

Which of the following statements accurately describe data? Select all that apply.

DATA CAN REVEAL IMPORTANT PATTERNS, TRENDS, AND INSIGHTS DATA IS A COLLECTION OF FACTS There are no limitations to data, as data measures are standard across users. DATA IS USED TO HELP ORGANIZATIONS MAKE MORE INFORMED DECISIONS

The analytical skill _____ encompasses how someone organizes information.

DATA DESIGN data mindset data analysis data strategy

What is the term for the computer system in which organizations store their data?

DATABASE Catalog Cache Data ecosystem

A data professional asks, "Why?" five times. What are they trying to figure out?

Details about the effects of a problem THE ROOT CAUSE OF A PROBLEM Evidence of a problem's existence The most common symptoms of a problem

A junior data analyst sorts sales data by product category. Then, they group that information into broader concepts, such as customer demographic and geographic region. Which data problem type does this scenario describe?

Discovering connections IDENTIFYING THEMES Finding patterns Making predictions

Which problem type involves using historical data to understand what happened in the past and is therefore likely to happen again?

Discovering connections Identifying themes FINDING PATTERNS Making predictions

A junior data professional working for an online retailer is asked to determine which ads are most successful with shoppers. They review click-throughs compared to the type of ads presented, then group the ads accordingly. Which data problem type does this scenario describe?

Discovering connections Spotting something unusual CATEGORIZING THINGS Finding patterns

A restaurant group is choosing the locations of new restaurant openings. They use an algorithm to monitor current trends and develop business intelligence about where people most frequently dine out. Which data problem type does this scenario describe?

Discovering connections Spotting something unusual MAKING PREDICTIONS Categorizing things

What are some strategies data professionals use to ensure their data analysis is unbiased? Select all that apply.

ENSURE ANYTHING SHARED WITH STAKEHOLDERS IS PRESENTED IN CONTEXT CONSIDER THE COMPLICATED SOCIAL CONTEXTS THAT COULD CREATE BIAS Disregard systemic factors that may affect the data PRIORITIZE FAIRNESS DURING DATA COLLECTION

Which of the following statements correctly describe analytical thinking? Select all that apply.

FIGURING OUT ALL OF THE SPECIFICS THAT WILL HELP EXECUTE A PLAN IS DETAIL-ORIENTED THINKING Analytical thinking involves using data in an organized manner in order to modify or make adjustments to a problem. VISUALIZATION IS THE GRAPHICAL REPRESENTATION OF INFORMATION JUST BECAUSE TWO PIECES OF DATA TREND IN THE SAME DIRECTION DOES NOT NECESSARILY MEAN THEY ARE RELATED

A data analyst uses a SQL query to retrieve information from a database. They add a WHERE statement to _____ the data based on certain conditions.

FILTER sort categorize copy

When solving the _____ problem type, a data analytics team at a health care provider analyzes patient data from the past five years. They then use this information to understand what led to certain symptoms and what is likely to cause them again.

FINDING PATTERNS identifying themes categorizing things discovering connections

A software company wants to improve its customer experience scores by 3% over the next 30 days. A data professional works to achieve this objective by understanding current scores and how far away they are from desired scores. They then use data insights to help advance the company from where they are now to where they want to be next month. What does this scenario describe?

Guiding business decisions Future analysis GAP ANALYSIS Planning

Which problem type involves assigning information to different groups or clusters based on common features?

Identifying themes CATEGORIZING THINGS Finding patterns Making predictions

A technology company faces escalating prices for a key part of one of its software applications. Data professionals at the firm discover that many other tech companies are experiencing the same issue. They reach out to the other affected businesses to share data and brainstorm solutions to their parallel challenges. What data problem type are they solving?

Identifying themes DISCOVERING CONNECTIONS Making predictions Categorizing things

A data professional at a web design firm collects data about website users. The data indicates the number of times each user visits the website. It also shows the duration of their visits, in seconds. What type of data is being collected?

Qualitative QUANTITATIVE Narrative Redundant

Data science involves using _____ data to create new ways of modeling and understanding the unknown.

RAW transformed clean processed

Which of the following statements correctly describe the SMART methodology? Select all that apply.

RELEVANT QUESTIONS MATTER, ARE IMPORTANT, AND HAVE SIGNIFICANCE TO THE PROBLEM SPECIFIC QUESTIONS ARE SIMPLE, SIGNIFICANT, AND FOCUSED ON A SINGLE TOPIC OR A FEW CLOSELY RELATED IDEAS SMART STANDS FOR SPECIFIC, MEASURABLE, ACTION-ORIENTED, RELEVANT, AND TIME-BOUND Time-bound questions limit the amount of time analysts should work on a particular project.

What is the term for a digital worksheet that data analysts use to store, organize, and sort data?

Report Application SPREADSHEET Document

Data design

The analytical skill that involves how you organize information

A data analyst working for a coffee roaster is writing questions for a customer experience survey. One of the questions asks, "Do you prefer online or in-store?" Then, they rewrite it to ask, "Do you prefer purchasing coffee beans through our online marketplace or by shopping at our retail store?" Why is this a more effective question?

The first question is closed-ended, whereas the second question encourages the respondent to elaborate. The first question contains slang that might not make sense to everyone, whereas the second question is easily understandable. The first question is leading, whereas the second question could have many different answers. THE FIRST QUESTION IS VAGUE, WHEREAS THE SECOND QUESTION INCLUDES IMPORTANT CONTEXT

To execute a plan using detail-oriented thinking, what does a data analyst consider?

The main idea The big picture THE SPECIFICS The root cause

Analytical skills

The qualities and characteristics associated with solving problems using facts

Thinking about the way you organize your contacts in a new phone is an example of which analytical skill?

Understanding context Data strategy Curiosity DATA DESIGN

In which of the following scenarios would a line chart be the most appropriate visualization?

When showing the distribution of people living in a certain area When showing the relationship between diet and blood pressure WHEN SHOWING THE CHANGE IN SOMEONE'S SALARY OVER TIME When showing what percentage of total annual sales were generated by various stores

Which text wrapping feature cuts off the contents of a spreadsheet cell so only the text that fits is visible?

Wrap Fill CLIP Overflow

During the _____ step of the data analysis process, data analysts use tools such as spreadsheets to draw useful conclusions.

act share ANALYZE process

Analytical skills are the qualities and characteristics associated with using _____ to solve problems.

gut instinct FACTS feedback predictions

Fill in the blank: A _____ encompasses the various elements that interact with one another in order to produce, manage, store, organize, analyze, and share data.

DATA ECOSYSTEM business transformation cloud system data source

Which of the following statements correctly describe data and data analysis? Select all that apply.

DATA IS A COLLECTION OF FACTS Data analysis is the science of data. COLLECTING DATA IS PART OF THE DATA ANALYSIS PROCESS ONE GOAL OF DATA ANALYSIS IS TO MAKE PREDICTIONS

Which of the following statements correctly describe the archive and the destroy phases of the data life cycle? Select all that apply.

DATA THAT IS NO LONGER RELEVANT TO BUSINESS GOALS IS OFTEN ARCHIVED. EVEN IF DATA MIGHT BE NEEDED AGAIN IN THE FUTURE, IT MAY STILL BE ARCHIVED. The destroy phase ensures data can be accessed again if necessary. DATA-ERASURE SOFTWARE CAN BE USED TO DESTROY DATA ON A HARD DRIVE.

Which tool in the data analysts toolbox is most likely to involve the creation of graphs, maps, or charts?

DATA VISUALIZATION SQL Database Spreadsheet

What are some key benefits of data visualizations? Select all that apply.

DATA VISUALIZATIONS ENABLE STAKEHOLDERS TO IDENTIFY TRENDS MORE EASILY. INSIGHTS THAT ARE VISUALIZED CAN BE MORE QUICKLY SHARD AND UNDERSTOOD. GRAPHS AND CHARTS OFFER A CLEAR AND CONCISE OVERVIEW OF THE DATA. Data becomes more detailed and comprehensive when visualized.

While planning a roadtrip, you figure out all of the specific stops you need to take along the way. You also consider how often you'll stop for gas, meals, and sleep. Having this information enables you to execute your plan. What does this scenario describe?

DETAIL-ORIENTED THINKING Finding a correlation Problem-orientation Big-picture thinking

In the _____ problem type, a data analyst finds similar challenges faced by different entities and combines data and insights to address them.

DISCOVERING CONNECTIONS spotting something unusual categorizing things finding patterns

What is the term for people who invest time and resources into a project and are interested in the outcome?

Data designers STAKEHOLDERS Data analysts Subject-matter experts

What is a method for examining and evaluating how a process works currently in order to get to an improved future state?

Data-driven decision-making GAP ANALYSIS Five whys Root cause analysis

A data analyst works for an engineering company, which specializes in aircraft design and development. They help their employer choose the best places to advertise, which include a podcast about the latest trends in airplane engineering and a magazine published by an aviation engineering association. What does this scenario describe?

Data-driven decision-making REACHING A TARGET AUDIENCE Structured thinking Adhering to a budget

What is prioritized when asking a specific SMART question? Select all that apply.

FOCUSING ON A SINGLE TOPIC OR A FEW CLOSELY RELATED IDEAS KEEPING THE QUESTION SIMPLE Asking about the era, phase, or period involved ENSURING THE QUESTION IS SIGNIFICANT

A data professional at a snack foods company wants to identify themes related to customer buying patterns and product popularity. How should they proceed?

GROUP CATEGORIZED INFORMATION INTO BROADER CONCEPTS Identify data that is different from the norm Use data to make an informed decision about how things may be in the future Assign information to different groups or clusters based on common features

For what reasons would it be unfair for a human resources manager to ask employees, "Why do you love working for our company?" Select all that apply.

It is a closed-ended question IT IS A LEADING QUESTION IT MAKES ASSUMPTIONS It is vague

Which of the following questions are open-ended? Select all that apply.

On a scale of 1-10 (with 10 being highest), how interested are you in current events? WHAT ARE THE THREE MOST IMPORTANT LIFE LESSONS YOU HAVE LEARNED? HOW WOULD YOU DESCRIBE THIS BOOK? Is it difficult for you to speak in public?

An e-commerce website collects, observes, and analyzes its customers' online behaviors. Then, it uses the insights gained to choose when to put certain products on sale. What business practice does this describe?

Organizing data DATA-DRIVEN DECISION MAKING Performance measurement Analytical thinking

A data analyst at a government agency researches ways to reduce traffic congestion. Rather than using only data about when and where traffic occurs, the analyst considers public transportation usage, road and weather conditions, and more. This enables them to achieve more insightful results. Which fairness best practice does this scenario describe?

Oversampling Including self-reported data CONSIDERING ALL AVAILABLE DATA Guiding business strategy

A data team at a car dealership considers fairness when collecting data. Instead of having salespeople share observations, they create a survey that asks customers to provide information about their own car-buying experiences. This helps avoid any unconscious bias that might be introduced by the salespeople. Which fairness best practice does this scenario describe?

Oversampling SELF-REPORTING Using all available data Considering context

A data professional at a beauty products enterprise is assigned a task related to customer buying habits. They think about what type of data they need to be successful, as well as optimal project outcomes. What phase of the data life cycle does this scenario describe?

PLAN Manage Archive Analyze

Which step of the data analysis process includes collecting data for analysis?

PREPARE Share Ask Process

A data team at a high-tech company writes questions for a focus group. They use common abbreviations such as PLS for "please" and LMK for "let me know." A supervisor then suggests spelling everything out in order to ensure the questions are fair. What are they trying to achieve?

PRESENTING QUESTIONS WITH STRAIGHTFORWARD WORDING Asking irrelevant questions Writing questions that do not make assumptions Avoiding leading people to a particular response

A political candidate surveys voters to learn about their opinions on key issues. The politician's data team notices that most respondents are people who have already voted in the current election. The fairness of the survey could be improved by over-sampling people from which group?

People who voted against the candidate in the current election PEOPLE WHO HAVE NOT YET VOTED IN THE ELECTION People who voted for the candidate in the current election First-time voters who already voted in the current election

A data professional at a social media company wants to communicate to stakeholders about which countries have the most active users. They create a data visualization that identifies 45 different countries, then shows the number of active users from each one. What type of data visualization should they create?

Pie chart BAR CHART Donut chart Line chart

There are six phases in the data life cycle, which culminate with analyze, archive, and destroy. What is the correct order of the first three phases?

Plan, manage, capture Manage, plan, capture Manage, capture, plan PLAN, CAPTURE, MANAGE

What symbol is used to start a formula?

Plus sign (+) EQUAL SIGN (=) Asterisk (*) Slash mark (/)

Which analytical skill involves the ability to break things down into smaller steps and work with them in an orderly and logical way?

Problem-solving Curiosity TECHNICAL MINDSET Simplification

Which step of the data analysis process is most likely to involve creating visuals that help people understand complex facts and figures?

SHARE Act Ask Prepare

What tasks may occur during the ask step of the data analysis process? Select all that apply.

STAY ENGAGED BY HAVING A DIALOGUE WITH STAKEHOLDERS DEFINE THE PROBLEM TO BE SOLVED CONSIDER THE CURRENT STATE COMPARED TO THE IDEAL STATE Select appropriate tools for cleaning the data

A data team at a national retail brand wants to understand why customers return certain items. They have two datasets containing statistics about returns. They clean them, then combine them in order to make the information more complete. What step of the data analysis process does this scenario describe?

Share PROCESS Analyze Prepare

Understanding context

The analytical skill that has to do with how you group things into categories

What does SQL stand for?

Software quotient listing STRUCTURED QUERY LANGUAGE Systematic quality level Searchable question lingo

What spreadsheet feature is used to change the height of a cell to allow the text inside to fit?

TEXT WRAP Filter Dropdown Sort

When building data into business strategy, why is it important to include insights from subject-matter experts? Select all that apply.

THEIR EXPERIENCE AND HUMAN INTUITION ARE VALUABLE TO DATA-DRIVEN DECISION-MAKING THEY CAN REVIEW ANALYSIS RESULTS AND HELP IDENTIFY INCONSISTENCIES THEY ARE FAMILIAR WITH THE BUSINESS PROBLEM They are responsible for finding and analyzing data to uncover trends, patterns, and relationships.

A data professional considers how they can best manage the key elements of an analysis project. They confirm that team members know how to use the right data, ensure there's a clear path to a solution, and check that the right technology is in place. Which analytical skill does this scenario describe?

Technical mindset Understanding context Curiosity DATA STRATEGY

In a table, an attribute is a characteristic or quality of data used for what purpose?

To perform a calculation TO LABEL A COLUMN To gather related data To reference a cell

A data analyst uses the SMART methodology to create a question that encourages change. In the SMART methodology, how is this question type described?

Transitional ACTION-ORIENTED Motivational Results-focused

Which of the following activities are part of the share step of the data analysis process? Select all that apply.

USE VISUALS TO HELP PEOPLE UNDERSTAND DATA INSIGHTS SUMMARIZE ANALYSIS RESULTS Make recommendations Define the problem to be solved

Which fairness best practice is intended to help stakeholders better understand the conditions that might influence the final conclusions of data analysis?

Use oversampling Consider relevant data IDENTIFY SURROUNDING FACTORS Include self-reported data

A junior data analyst at a construction company develops a plan about a home-remodeling project. They employ analytical thinking to stay focused and on track. They also consider how to improve the quality and usefulness of the data they collect. Which aspect of analytical thinking does this scenario describe?

Visualization STRATEGIC THINKING Problem-orientation Correlation

Which of the following statements accurately describe data visualizations and visualization tools? Select all that apply.

WHEN WORKING WITH THE PROGRAMMING LANGUAGE R, DATA PROFESSIONALS CAN CREATE DASHBOARD-STYLE DATA VISUALIZATIONS DATA PROFESSIONALS CAN CREATE BAR GRAOHS, PIE CHARTS, AND MAPS IN A SPREADSHEET The amount of data being shared should not influence the type of visualization selected. TABLEAU IS A DATA VISUALIZATION TOOL THAT ENABLES SIMPLE AND QUICK DATA SHARING