Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A pre-assessment exam for data analytics, featuring questions and verified answers. It covers topics such as data collection methods (cookies), data types (continuous, discrete), data sources (first-party, second-party), and data ethics (privacy, consent). The material is designed to help students enhance their understanding and improve their exam performance in data analytics. It also touches on database management, data security, and file management practices, offering a comprehensive overview of key concepts in the field.
Typology: Quizzes
1 / 34
This page cannot be seen from the preview
Don't miss anything!
To track people's online activities and interests, which method of data collection is most effective? Cookies What are cookies? Small files stored on computers that contain information about users In data analytics, what term refers to all possible data values in a dataset? Population
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? Second-party What type of data is the height of a skyscraper? Continuous In data analytics, what is the term for data that is generated from, and lives, outside of an External Fill in the blank: A data model is used to organize _____ and how they relate to one another. data elements 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 Fill in the blank: A data type is a specific kind of data _____ that tells what kind of value the data is.
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 sample Which of the following questions would enable a data professional to collect nominal qualitative data? Did anyone recommend our music lessons to you? Fill in the blank: Bias is a _____ preference in favor of or against a person, group of people, or thing. conscious or subconscious What is the term for the tendency to search for or interpret information in a way that validates pre-existing beliefs? Confirmation bias
Fill in the blank: Data is considered _____ when it is accurate, complete, and unbiased information that has been vetted and proven fit for use. reliable A junior data analyst learns that the dataset they have been given is six years old. After looking into this further, they also discovered 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? Current What concept states that all data-processing activities and algorithms should be completely explainable and understood by the individual who provides their data? Transaction transparency A data analyst removes personally identifying information from a dataset. What task are they performing? Data anonymization 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? Boolean
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? Interpretation Before completing a survey, a respondent learns more about how their data will be used. They understand why their data is being collected and how long it will be stored. What data ethics concept does this describe? Consent 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 What is the preferred method for open data to be made available? A convenient and modifiable internet download 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
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 Fill in the blank: A relational database contains a series of _____ that can be connected to form relationships. tables What process do data professionals use to eliminate data redundancy, increase data integrity, and reduce complexity in a database? Normalization Fill in the blank: When using a relational database, data analysts write _____ to request data from the related tables. queries A large company has several databases across its many departments. What kind of metadata describes how many locations contain a certain piece of data?
What is the term for an identifier that references a database column in which each value is unique? Primary key What is the process for arranging data into a meaningful order to make it easier to understand, analyze, and visualize? Sorting 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? Filter out non-condominium sales 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 descending order Fill in the blank: To keep a header row at the top of a spreadsheet, highlight the row and select _____ from the View menu. freeze
Fill in the blank: When using SQL, the _____ clause can be used to filter a dataset of customers to only include people who have made a purchase in the past month. WHERE A database table is named WebTrafficAnalytics. What type of case is this? Camel case Fill in the blank: Data professionals use data _____ to handle issues related to internal and external data flows while ensuring data assets are formally managed. governance A data team at a trade school is sending a text alert to all students who have fewer than 10 credits. What spreadsheet tool will enable them to display only the students who meet that condition? Filter out students with more than 10 credits
What data-security measure uses a unique algorithm to alter data and make it inaccessible without the algorithm? Encryption Thank you for accessing this study resource. This document provides well structured academic support materials designed to help students enhance their understanding and improve their exam performance. Additionally, we offer assistance with university assignments, essays, research projects, test banks and Final Exam Qs & AS. Reliable, Affordable & Plagiarism-free. For further inquiries, please contact us at: [email protected] or [email protected] When using tokenization as a safety measure, what is replaced as a randomly generated token? The data elements to be protected What data-security practice enables all collaborators within a file to track changes, such as who made what edits to the file, when they were made, and why? Version control What can be removed from the following query without preventing it from running? SELECT *
FROM Uni_dataset.new_table WHERE ID = 'Lawrence' Backticks (`) You are in charge of your company's weekly accounting spreadsheet. It has 15 sheets, each containing a different employee's purchases. You add restrictions to the spreadsheet to make sure employees can only edit their own sheets. What practice does this scenario describe? Data security A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario? Metadata A data analyst uses _____ to organize multiple files for a given project so they can be found and accessed in an efficient manner. foldering Fill in the blank: To keep files organized, use a logical _____ to organize folders and subfolders. hierarchy
How does an analyst ensure that a data source is reliable? It is accurate, complete, and unbiased information. What should an analyst consider at the start of data collection to reduce errors? Bias and fairness How does an analyst apply data ethics to privacy and collection? By using the collected data responsibly How does an analyst apply the principle of ownership to ethics and privacy in data collection? Individuals who create the data should own it. How does an analyst apply the principle of consent to ethics and privacy in data collection? By disclosing how and why the data will be used before the survey An analyst used a column of a table to uniquely identify each record within a table. Which tool did they use? Primary key
Which tool is used by data analysts to store and organize data, making it easier for them to manage and access information? Database Which element of a Notepad file would be considered data as opposed to underlying metadata? File contents What is an example of administrative metadata for a digital file? File permission What is an acceptable syntax for the SELECT keyword in MySQL? select Which role does an analyst have in collecting second-party data? Contracts with an external entity
Which process may restrict data analysis needs and should be balanced with data access needs? Data security What is the best practice for naming folders and subfolders to organize data? Use descriptive names. Which file name follows formatting conventions? SalesReport_ Fill in the blank: Data _____ involves the accuracy, completeness, consistency, and trustworthiness of data throughout its lifecycle. integrity Which process do data analysts use to make data more organized and easier to read? Data manipulation
Before analysis, a company collects data from countries that use different date formats. Which of the following actions would improve the data integrity? Change all of the dates to the same format If you have to complete your analysis with insufficient data, how should you address this limitation? Identify trends with the available data What is a feature of the filtering process when applied to spreadsheets? Filtering hides the data temporarily. A data analyst wants to find out how many middle school students in Helsinki have laptops. It is unlikely that they can survey every middle schooler in the city. Instead, they survey enough students to represent all middle schoolers. This describes what data analytics concept? Using a sample Fill in the blank: Sampling _____ occurs when some members of a population are overrepresented or underrepresented in the data. bias Which statistical power is typically considered the minimum for statistical significance?
