D467 - Exploring Data

An analyst needs to show the geographic distribution of customers in the United States by region. Which visual representation should this analyst use? Sales reports Field descriptions Charts A data dictionary

Charts

A data scientist at a tech company records whether users have accepted their company's terms of service or not. What data type is being collected in this scenario? Text Boolean String Numerical

Boolean

A data analyst works for a rental car company. They have a spreadsheet that lists car ID numbers and the dates cars were returned. How should they sort the spreadsheet to find the most recently returned cars? By return date, in ascending order By return date, in descending order By car numerical ID, in ascending order By car numerical ID, in descending order

By return date, in descending order

An analyst wants to combine the fields for city and state into a single field prior to extraction for data cleansing. Which Structured Query Language (SQL) statement will perform this function? CONCAT statement CAST statement ORDER BY statement COALESCE statement

CONCAT statement

A data analyst removes personally identifying information from a dataset. What task are they performing? Data anonymization Data sorting Data collection Data visualization

Data anonymization

Which process may restrict data analysis needs and should be balanced with data access needs? Data security Data storage Data organization Data normalization

Data security

Which tool is used by data analysts to store and organize data, making it easier for them to manage and access information? Primary key Table Database Foreign key

Database

What is an example of conceptual data modeling that an analyst uses? Using mathematical models for predictive analysis of experiments Defining how individual records are uniquely identified in a database Defining the business requirements for a new database Using table names, column names, and data types for the database

Defining the business requirements for a new database

A large metropolitan high school gives each of its students an ID number to differentiate them in its database. What kind of metadata are the ID numbers? Administrative Structural Descriptive Representative

Descriptive

Fill in the blank: A data type is a specific kind of data _____ that tells what kind of value the data is. attribute frame model point

attribute

Fill in the blank: Bias is a _____ preference in favor of or against a person, group of people, or thing. conscious or subconscious sensible or insensible fair or unfair standard or substandard

conscious or subconscious

Fill in the blank: The data ethics principle of _____ states that an individual has the right to understand all of the data-processing activities and algorithms used on their data. transaction transparency consent ownership currency

transaction transparency

Which of the following statements accurately describe first-, second-, and third-party data? Select all that apply. -When using third-party data, it's important to confirm its accuracy. -Second-party data is sold by a trusted partner to another party. -Third-party data is collected by an individual or group using their own resources. -A key benefit of using first-party data is that the user knows where it came from.

-When using third-party data, it's important to confirm its accuracy. -Second-party data is sold by a trusted partner to another party. -A key benefit of using first-party data is that the user knows where it came from.

Which of the following are examples of sampling bias? Select all that apply. A teacher gives higher grades to essays written in their own writing style. A clinical study includes three times more men than women. A survey of students does not include homeschooled students. An election poll only interviews people with college degrees.

A clinical study includes three times more men than women. A survey of students does not include homeschooled students. An election poll only interviews people with college degrees.

Which example shows the use of primary data? U.S. census data used by a university A company's survey data of its customers' satisfaction Data purchased from a market firm containing customer profiles Data from a published journal cited in a student's research paper

A company's survey data of its customers' satisfaction

What is the preferred method for open data to be made available? A convenient and modifiable internet download A secure password-protected file A compressed file format that keeps file size small A print copy that is easily shared by anyone

A convenient and modifiable internet download

What is the definition of verification in the data cleaning process? A process of ensuring the degree to which a set of measures is equivalent across systems A process of chronologically listing the modifications made to a set of data files during the data cleansing process A process to confirm how accurate and reliable a data set is following data cleaning A process to report on the results of data cleansing efforts to help build trust in the data and cleansing

A process to confirm how accurate and reliable a data set is following data cleaning

A team leader is assigned the task of evaluating the schema of a data set as part of data cleansing. How would the team leader define a schema to the analyst collaborating on the project prior to commencing cleansing? How well two or more data sets work together A way of describing how something is organized A process of combining two or more data sets into a single data set A way of matching fields in separate databases

A way of describing how something is organized

A data professional working on a project about commuters researches the origin of a dataset to confirm it was created by a reputable source, such as a government transportation agency. Which aspect of good data are they prioritizing? Original Comprehensive Cited Reliable

Cited

A data analyst is performing analysis on data stored in a big data platform with state-of-the-art analysis tools. Insufficient sample size is rendering the current analysis ineffective. What is the primary challenge of a larger sample size? Collecting a larger sample size is more expensive. Analyzing a larger sample size is complex. Storing a larger sample size is difficult. Cleansing a larger sample size is complicated.

Collecting a larger sample size is more expensive.

In a data table, where are fields contained? Rows Columns Favorites Charts

Columns

What are the main benefits of open data? Select all that apply. Combines data from different fields of knowledge Good data is more widely available Restricts data access to certain groups of people Increases the amount of data available for purchase

Combines data from different fields of knowledge Good data is more widely available

What type of file saves data in a table format? Calculated spreadsheet values (.csv) Comma-separated values (.csv) Cell-structured variables (.csv) Compatible scientific variables (.csv)

Comma-separated values (.csv)

A manager in charge of selling a particular product interprets any ambiguous customer feedback about the product as being positive. What type of bias does this represent? Confirmation Sampling Interpretation Observer

Confirmation

What is the term for the tendency to search for or interpret information in a way that validates pre-existing beliefs? Sampling bias Confirmation bias Observer bias Interpretation bias

Confirmation bias

Before completing a survey, an individual acknowledges reading information about how and why the data they provide will be used. What is this concept called? Privacy Discretion Currency Consent

Consent

Freedom from inappropriate use of your data is an element of which aspect of data ethics? Consent Transparency Privacy Currency

Consent

Which data ethics principle gives an individual the right to know why their data is collected and how long it will be stored? Consent Anonymization Credibility Privacy

Consent

What are the key characteristics of a text, or string, data type? Select all that apply. Contains textual information Only two possible values Sequence of characters and punctuation Has numerical percentages

Contains textual information Sequence of characters and punctuation

What type of data is the height of a skyscraper? Discrete Qualitative Nominal Continuous

Continuous

Which role does an analyst have in collecting second-party data? Contracts with data aggregators Acquires internal data Contracts with an external entity Surveys sample populations

Contracts with an external entity

An entertainment website displays a star rating for a movie based on user reviews. Users can select from one to five whole stars to rate the movie. The star rating is an example of what type of data? Select all that apply. Continuous Discrete Ordinal Nominal

Discrete Ordinal

Which of the following items are examples of continuous data? Select all that apply. Duration of a customer service call Favorite social media platform Number of employees at a company Temperature of a swimming pool

Duration of a customer service call Temperature of a swimming pool

What is an outcome of the verification step of data cleansing? Compares dirty data with clean data Ensures the data collected and cleansed will address the original purpose Chronologically documents how the data set evolved during the project Helps build trust in the cleansing process and data

Ensures the data collected and cleansed will address the original purpose

In data analytics, what is the term for data that is generated from, and lives, outside of an organization? Peripheral Outer Internal External

External

When discussing structured databases, data analysts refer to the data contained in a row as a record. How do they refer to the data contained in a column? Field Subject Character Point

Field

Which element of a Notepad file would be considered data as opposed to underlying metadata? File contents File description FIle date File size

File contents

What is an example of administrative metadata for a digital file? File size File name File contents File permission

File permission

An analyst performing data cleansing on invoice data would like to select and view rows that have an amount paid that is greater than $100. Which spreadsheet functionality should the analyst use? COUNTIF Conditional formatting Filter Remove duplicates

Filter

A data analyst is reviewing a national database of real estate sales. They are only interested in sales of condominiums. How can the analyst narrow their scope? Sort by condominium sales Filter out non-condominium sales Filter out condominium sales Sort by non-condominium sales

Filter out non-condominium sales

What is a feature of the filtering process when applied to spreadsheets? Filtering hides the data temporarily. Filtering orders the data temporarily. Filtering removes the data permanently. Filtering orders the data meaningfully.

Filtering hides the data temporarily.

Which process utilizes logical and descriptive names for files, making them easier to find and use? Safety measures Foldering Normalization Data validation

Foldering

On very short notice, a data analyst is asked to create a report for stakeholders. Because of the challenging time frame, what type of data might yield the best results? Theoretical Fabricated Unclean Historical

Historical

In Google Sheets, what function enables a data analyst to specify a range of cells in one spreadsheet to be duplicated in another? SPECIFY DUPLICATE IMPORTRANGE CELLRANGE

IMPORTRANGE

Bringing data from a .csv file into a spreadsheet is an example of what process? Filing data Importing data Editing data Normalizing data

Importing data

An investor with a background working in the tech industry interprets any pitch from a tech startup as being more promising than others, even if the information is confusing and ambiguous. What type of bias does this scenario describe? Sampling Interpretation Observer Confirmation

Interpretation

Which of the following questions would enable a data professional to collect nominal qualitative data? How many books do you own? How many years of experience do you have? Is this your first time dining at this restaurant? What is your height?

Is this your first time dining at this restaurant?

Why is clean data critical for data analysis? It ensures data drives the decision the analyst intends to communicate. It ensures data used for analysis reflects operational reality. It ensures data is structured to enable effective analysis. It ensures data is visualized to make decisions.

It ensures data used for analysis reflects operational reality.

How does an analyst ensure that a data source is reliable? It includes data needed to answer the research question. It is accurate, complete, and unbiased information. It is validated against the original source. It includes data that is current and relevant to the study.

It is accurate, complete, and unbiased information.

An expert in query languages searched for month_name = DEC using Vertica. The data set contains variations of the word December, such as dec, Dec, etc. What will the output of this search query be? It will return all entries that match DEC only. It will return all entries that match dec only. It will return all entries such as dec, Dec, DEC. It will return all entries that match Dec only.

It will return all entries that match DEC only.

What is the general rule regarding the suggested length of each line in a query to maintain indentation best practices? Less than or equal to 50 characters Greater than or equal to 100 characters Less than or equal to 100 characters Greater than or equal to 50 characters

Less than or equal to 100 characters

What are some key benefits of open-data initiatives? Select all that apply. Limit opportunities for collaboration Make government activities more transparent Support innovation and economic growth Help educate citizens about important issues

Make government activities more transparent Support innovation and economic growth Help educate citizens about important issues

A hospital system wants to protect the personally identifiable information of its patients, such as names and medical records. They ask their data team to anonymize the data. What techniques might they use to achieve this goal? Hashing Masking Sorting Blanking

Masking Blanking

What does an UPDATE statement do after execution in Structured Query Language (SQL)? Modifies values in certain cells of a table based on conditions Inserts new rows into the table based on data provided in the query Removes tables based on the query Creates a temporary table to be downloaded for analysis and visualization

Modifies values in certain cells of a table based on conditions

What are the key aspects of universal participation? Select all that apply. Certain groups of people must share their private data. No one can place restrictions on data to discriminate against a person or group. Everyone must be able to use, reuse, and redistribute open data. All corporations are allowed to sell open data.

No one can place restrictions on data to discriminate against a person or group. Everyone must be able to use, reuse, and redistribute open data.

What process do data professionals use to eliminate data redundancy, increase data integrity, and reduce complexity in a database? Composition Normalization Manipulation Iteration

Normalization

When using long data, each subject has data in multiple rows. This is because each row represents what? Data in different formats True or false data points One observation per subject Multiple values

One observation per subject

A financial institution publishes data about stock prices and market trends, which any business, nonprofit, or citizen can access, reuse, or redistribute through its online databases. What type of data is described in this scenario? Open Allowable Free Closed

Open

A government agency allows any business, nonprofit, or citizen to access its databases and reuse or redistribute the data. What type of data is described in this scenario? Closed Allowable Free Open

Open

What leads to confirmation bias in data collection? People experience the same circumstance differently. People view the same object differently. People search to verify preexisting beliefs. People perceive ambiguous situations in a positive or negative way.

People search to verify preexisting beliefs.

An analyst wants to present a high-level summarized version of the data at the end of data cleansing. Which spreadsheet functionality should the analyst use? Conditional formatting Pivot table Find and replace Filters

Pivot table

In data analytics, what term refers to all possible data values in a dataset? Source Representation Population Sample

Population

Which of the following items are examples of structured data? Select all that apply. Price list Scanned medical images Data table Audio recording

Price list Data table

An analyst used a column of a table to uniquely identify each record within a table. Which tool did they use? Normalization Field Foreign key Primary key

Primary key

What is the term for an identifier that references a database column in which each value is unique? Field Relation Primary key Foreign key

Primary key

What is the difference between raw data and information? Raw data is universal, while information is specific. Raw data is organized, while information is unstructured. Raw data is corrupt, while information is secure. Raw data is unorganized, while information is structured.

Raw data is unorganized, while information is structured.

A junior data analyst learns that the dataset they have been given is six years old. After looking into this further, they also discover that the age of the data is making the information irrelevant to their project. What good data source principle have they used to evaluate the dataset? Comprehensive Original Reliable Current

Reliable

Which of the following terms are also ways of describing observer bias? Select all that apply. Perception bias Research bias Spectator bias Experimenter bias

Research bias Spectator bias Experimenter bias

Which file name follows formatting conventions? SalesReport 2021 SalesReport*2021 SalesReport_2021 SalesReport!2021

SalesReport_2021

A magazine conducts research about people's reading preferences. They only include respondents who currently subscribe. What type of bias does this scenario describe? Confirmation Interpretation Sampling Observer

Sampling

A university surveys its student-athletes about their experience in college sports. The survey only includes student-athletes with scholarships. What type of bias does this scenario describe? Sampling Observer Interpretation Confirmation

Sampling

A grocery store chain purchases customer data from a credit card company. The grocer uses this data to identify its most loyal customers and offer them special promotions and discounts. What type of data is being used in this scenario? First-party Multi-party Third-party Second-party

Second-party

What are cookies? Types of malware that can damage computers Small files stored on computers that contain information about users Programs that enable users to access websites Pieces of code that store information about a website

Small files stored on computers that contain information about users

What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize? Filtering Prioritizing Reframing Sorting

Sorting

Which type of structured data does an analyst use? Social media posts User-created content Videos of store traffic Store inventory

Store inventory

A large company has several databases across its many departments. What kind of metadata describes how many locations contain a certain piece of data? Structural Administrative Descriptive Representative

Structural

What is the most likely reason why a data analyst would use historical data instead of gathering new data? The data is unknown The data is constantly changing The project has a very short time frame The project is unimportant

The project has a very short time frame

Which statement is true about sampling, irrespective of sample size? The sample standard deviation (Stdev) is the same as the population Stdev. The sample distribution approximates to normal distribution. The sample bias is reduced if the sample being selected is representative of the population. The sample mean approaches the population mean

The sample bias is reduced if the sample being selected is representative of the population.

What concept states that all data-processing activities and algorithms should be completely explainable and understood by the individual who provides their data? Ownership Currency Privacy Transaction transparency

Transaction transparency

What are the key characteristics of unstructured data? Select all that apply. Fits neatly into rows and columns Unorganized May have an internal structure Clearly identifiable construction

Unorganized May have an internal structure

What is the best practice for naming folders and subfolders to organize data? Use special character names. Use descriptive names. Use numeric names. Use spaces in the names

Use descriptive names.

An international nonprofit organization wants to merge third-party data with its own data. Which of the following actions will help make this process successful? Select all that apply. Use metadata to standardize the datasets. Replace the incoming data's metadata with its own company metadata. Use metadata to evaluate the third-party data's quality and credibility. Alter the internal metadata to more closely reflect the incoming metadata.

Use metadata to standardize the datasets Use metadata to evaluate the third-party data's quality and credibility

What strategy do data professionals use in order to ensure unbiased sampling? Use random sampling during data collection Write survey questions that encourage specific responses Store data in a spreadsheet Skew results in a certain direction

Use random sampling during data collection

A political scientist needs to poll all voters in Seoul, South Korea, in order to predict the outcome of an election. Because it would be impossible to collect data from every single person in the city, the political scientist polls a part of the population that is representative of the whole. What does this scenario describe? Using a population Choosing a data type Using a sample Choosing quantitative data

Using a sample

Which of the following are usually good data sources? Select all that apply. Vetted public datasets Social media sites Governmental agency data Academic papers

Vetted public datasets Governmental agency data Academic papers

An analyst wants to extract data from a table by filtering for certain conditions prior to performing data cleansing. Which Structured Query Language (SQL) statement will perform this function? LENGTH statement DISTINCT statement TRIM statement WHERE statement

WHERE statement

In the next six months, an analyst is expected to analyze and present the effects of monthly promotions on sales of a new product released one month ago. Which solution for insufficient data should this analyst pursue? Look for a new data set Identify trends with available data Speak with stakeholders and adjust the objective Wait for more data

Wait for more data

What are data ethics? Established methods for ensuring data is clean, well-organized, and appropriate for a project Long-standing techniques for confirming that data is always used to benefit society Approved strategies data professionals use to safeguard the privacy and security of a dataset Well-founded standards of right and wrong that dictate how data is collected, shared, and used

Well-founded standards of right and wrong that dictate how data is collected, shared, and used

To determine if a data source is cited, ask which of the following questions? Select all that apply. When was this data last refreshed? Who created this dataset? Is this dataset from a credible organization? Has this dataset been properly cleaned?

When was this data last refreshed? Who created this dataset? Is this dataset from a credible organization?

Fill in the blank: A data model is used to organize _____ and how they relate to one another. data visualizations database structures data elements spreadsheet fields

data elements

Fill in the blank: The data ethics principle of transaction transparency states that an individual has the right to understand all of the _____ and algorithms used on their data. free access data-processing activities raw data financial transactions

data-processing activities

Fill in the blank: The number of points scored in a basketball game is an example of _____ data. discrete open nominal continuous

discrete

Fill in the blank: For data analytics projects, _____ data is typically preferred because users know it originated within the organization. second-party third-party multi-party first-party

first-party

Fill in the blank: Openness refers to _____ access, usage, and sharing of data. protected limited free disclosed

free

Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select _____ from the View menu. set lock freeze pin

freeze

Fill in the blank: Data _____ is a process data professionals use to ensure the formal management of their organization's data assets. sourcing governance organization storage

governance

Fill in the blank: When using a relational database, data analysts write _____ to request data from the related tables. relationships keys queries programs

queries

Fill in the blank: Data is considered _____ when it is accurate, complete, and unbiased information that has been vetted and proven fit for use. original current comprehensive reliable

reliable

What is an acceptable syntax for the SELECT keyword in MySQL? "select" select SELECT_Keyword 'select'

select

Fill in the blank: A relational database contains a series of _____ that can be connected to form relationships. tables cells fields spreadsheets

tables