Worksheets#5 CIW Data Analyst - Certification Prep
Total questions: 54
Worksheet time: 2hrs 48mins
A company's form, where you are asked to fill in your first name, last name, email address, and phone number, is an example of:
structured data
customer data
sales data
unstructured data
A linear data structure that follows a particular order in which the operations are applied is known as a/an:
Array
Stack
linked list
Tree
What is an outlier?
A data sample that holds irrelevant records from the set of data
The incomplete information about any object or element in a dataset
A set of duplicate records present in a database
An amount of information that represents a larger group of datasets
Why is open data important?
Because it streamlines the processes and systems that the society and governments have built
Because it is freely available (but not really accessible) on the Internet
Because it includes non-digital formats, such as lab notebooks and diaries
Because it gives an overview of registration, transaction, and record-keeping
Documents, spreadsheets, questionnaires, transcripts, codebooks, and audiotapes are types of:
public data
open data
research data
administrative data
National health surveys, birth and death records, pensions, and taxation are examples of which of the following types of data?
Research
Administrative
Open
Public
After a company markets and sells products and the sales order is executed, the transaction data is recorded by the accounting department. In which of the following is the data recorded first?
Proper journal
General journal
Sales journal
Purchases journal
What is SEO?
A paid service used to direct traffic to a Website
A specialized format that provides users with a means to store, organize, and retrieve data in an efficient manner
A tool that identifies key information related to an individual's or business's operation
The process of affecting the visibility of a Website or a Webpage in a search engine's results
Which information security standard is defined for organizations that handle branded credit cards from major credit card companies including Visa, Mastercard, American Express, Discover, and JCB?
HIPAA
FISMA
PCI DSS
Sarbanes-Oxley
In the last several decades, after replacing the "time-sharing" services with "cloud-based data storage applications," the main issue software providers faced was to prevent the data from being accessed by unauthorized users. Cloud providers offer a variety of new security solutions to deal with this problem. Which of the following are included in the newest security techniques?
Improved VM support and PGP
SSL and PGP
PKI and Improved VM support
PGP and PKI
Cloud-based data storage and solutions providers must comply with a spectrum of regulations, including:
the Federal Bureau of Investigation.
the Federal Information Security Management Act.
the Federal Trade Commission.
the United States Department of the Treasury.
Which act has been passed to protect investors from the possibility of fraudulent accounting activities by corporations?
Health Insurance Portability and Accountability Act (HIPAA)
Sarbanes-Oxley
Payment Card Industry Data Security Standard (PCI DSS)
Federal Information Security Management Act (FISMA)
Which of the following best describes cloud computing?
A structured set of data held in a computer, especially one that is secured at a nearby location
An application that requires the use of versions of SQL and other structured query languages from which to parse information
A database management system that integrates a relational database with user-friendly graphical user interfaces
A distributed model where computers and other devices use shared resources, data, and information to benefit the customer
The advantages of cloud-based applications in comparison with the use of a local server can include which of the following?
Better regulated standards
Increased security
Decreased downtime
Infrastructure flexibility and scalability
You need to put the organization's data into its natural form rather than wrapping data into a particular structure. Along with this, you want to properly handle missing values. Which of the following programming languages can help with this task?
R Project
Java
SAS
MATLAB
What does the underlined part of the following sentence mean? "Hadoop provides for distributed processing with clusters of computers."
They have a framework of a collection of computers that store and process data.
They have many computers and each one stores a specific type of data, so they would have the best server for a company.
They divide sensitive data into bundles of computers that process in parallel.
They store multiple copies of a company's data on multiple servers.
Which of the following statements is true of the R Project?
It is commercially available to end-users and is supported by R Foundation for statistical computing.
It is a programming language useful in statistical computing and graphics.
It is released under the General Refine Expression Language (GREL).
It comes only with a command-line interface.
As a newly graduated data analyst, a senior analyst asks you if you know of any good tools to work with cloud-native data. You choose to discuss:
Microsoft Access, because it is the database with which you are most familiar.
Apache Hadoop, as it is open-source, reliable, and scalable.
HTML, CSS, and JavaScript, as all are excellent ways to work with cloud-native data.
Oracle, because it has been around the longest.
You received a complaint from a customer whose order did not reach her within five days after placing the order. To identify the reason for the delay in delivery, you need to check the detailed shipment information. Which management system will have the required carrier-related information?
Inventory management
Just-in-time
Facilities management
Supply chain management
Often, public social media platforms may provide application program interfaces (APIs) for free, but impose restrictions on:
the different types of users.
the amount or type of data that can be accessed.
companies and firms.
the time of usage.
Which management system involves designing, planning, executing, and monitoring the products, information, and finances as they flow from the initial supplier of raw materials all the way to the final consumer?
Facilities
Supply chain
Inventory
Just-in-time
In which of the following social media platforms would you classify Twitter?
Microblogging site
Content sharing site
Professional networking site
Social networking site
The typical method of obtaining data from social media platforms is by the use of Application Program Interfaces (APIs). What is an API?
It provides a graphical user interface that allows social media users to speak directly to a company
It is the "chat" box that allows live operators to help customers while placing orders.
It is a Website with a form that parses the information and passes it to the database.
It is a pre-programmed instruction and tool for managing interactions between different software and is used to automatically extract social media data.
Which of the following explains why inventory management is critical for a company?
Many companies have large inventory operations and employ many workers causing it to have a large budget.
Brick and mortar stores are expensive and should only be as large as the current inventory supply.
A company with no inventory has nothing to sell.
Inventory forms the largest part of a business's current assets.
An online shopping Website that sells baby clothes, equipment, and supplies is classified as:
business-to-business (B2B).
customer-to-customer (C2C).
customer-to-business (C2B).
business-to-customer (B2C).
Which of the following is an essential part of the business-to-business (B2B) framework?
Decision making
Segmentation
Data integration
Data handling
A chain of grocery stores is buying processed beef from many different farms to sell to its customers. What kind of transaction framework exists between the grocery stores and the farms?
Business-to-business
Customer-to-business
Customer-to-customer
Business-to-customer
Which type of customer data is psychographic in nature?
Demographic
Contextual
Behavioral
Descriptive
Your experience as a data analyst allows you to recognize which of the following as behavioral data?
Context-specific data
Transactional data
User demographics
Complaint details
__________ data pertains directly to the relationship between the organization and its customers. It is usually in the form of transactional data, recording all relevant information about user purchases - what, when, how much, and how often.
Contextual
Descriptive
Behavioral
Supply chain management
While performing analysis on data that you have collected, you find the need to combine Hadoop analytics and Tableau extensions in one easy to use Website. Which of the following meets your needs?
OpenRefine
Tableau Public
Rapid Miner
The R Project
Martha as a data analyst asks you how she could incorporate information from a Google Transparency Report into her data as Google is an online entity and she does not know how to do it. You inform her that:
You do not know of a way to do that.
If she knows how to interpret HTML, she can copy the information into a spreadsheet.
She can copy/paste the information.
Google's reports are also downloadable.
Which of the following can combine data from multiple sources and display the information with new aspects?
The R Project
OpenRefine
Rapid Miner
Tableau Public
Which of the following data analysis tools provides tool blending?
KNIME
BigQuery
OpenRefine
Tableau Public
Why are decision trees used?
They are intelligible and easy to present.
They are immune to sampling errors.
They help identify the strategy that is most likely to reach the goal.
They have the ability to forecast the exact outcomes.
Mr. Shallis has just opened 5 new donut shops throughout the Lee county area. The donuts are award winning and they begin to draw numerous customers to their shop. In order to operate smoothly, the managers need to have the latest data and share it between stores. Which tool would be the best fit for this?
Tableau
Rapid Miner
CRM System
The R Project
Your mean DIT teacher decides that he is going to assign you a massive team project. You need a visual tool that highlights due dates and what each member is accountable for. Which tool listed below would best capture all of this information in an appropriate way?
A calendar on Microsoft Word
A graphic edited calendar in Adobe
A Gantt chart created in Microsoft Excel
A box and whiskers chart created in Google slides
Which of the following can be used to illustrate key information graphically that describes the business operations?
HDFS
Dashboard
Oracle
MySQL
You and your best friend decide that you are going to become entrepreneurs and start your own shoe business. You need to know what shoe to sell in each location of the city at your newly rented stores. You want to hire a data analyst, but you’re broke as can be. So you ask a friend who always passes his DIT tests and they say you should work with the following database:
MS-SQL (Microsoft)
Oracle
Hadoop
MySQL
There are two competing businesses in Cape Coral. You as a smart data analyst play them both and convince them to hire you as their data analyst. They both hand you a mass amount of disorganized data in different formats. Which tool would be best used to process this data into one organized format?
OpenRefine
Apache Hadoop
Oracle
Google Big Query
You somehow manage to pass this data analyst course thanks to the wise wisdom from your great and powerful DIT teacher. You decide that you want to enter the data analyst field with all this new-found knowledge. So you get hired by Amazon in the sales department. They ask you to create charts for sales data over the last 10 years. Which function of the R Project could help you do this?
Knime
Graph-R
Coding
Dashboards
Which Magic Quadrant is occupied by organizations who demonstrate completeness of vision, but have little ability to execute?
Niche Players
Challengers
Leaders
Visionaries
Which of the following types of software is often used to display information for small-to-large audiences?
Grafting
Calculating
Presentation
Database
Which of the following would best describe a "Webcast"?
A presentation that takes place in a distance-oriented environment where one person uses a tool to present important and valuable information to an audience that logs in from across the globe
A list of what users are looking at on a Website and how long they look at it
A type of blogging, over the Web, in which one regularly expresses his or her thoughts or feelings
A tool often used to help a company know their customers better, know how to communicate with their customers better, and create products for their customers
In a presentation, where should the background or history of the topic be given?
Never, it is a waste of time for the audience
Anywhere in the presentation
On slide three
On the last slide
Which of the following is not an effective way to display data in a presentation?
Using numbers on one side and a simple chart on the other side of a slide
Avoiding the use of the default chart
Using many animations and sounds
Adding images to the presentations
You have asked Vlad to create a presentation on a recently completed project. He asks you how to start, as he is creating a presentation for the first time. You suggest Vlad
begin by mentioning the frequently asked questions
give a brief detail about the project
begin by creating an outline.
start with the results you have achieved so far.
You are creating a sales analysis presentation to be used by all of your sales personnel. One of them asks how you will tailor the presentation to meet the needs of all their unique vendors. You explain
I will include the name of each and every vendor and their unique product or situation in the presentation.
I will use the FAQ slide to answer specific questions that these unique vendors may have
I will not, each salesperson will have to do that
I will use the find/replace function to make changes to each presentation
You are creating the frequently asked questions (FAQs) slide for your presentation. What should be included?
Abstract data
Questions asked during the first presentation
Conclusions and action items
Key points and statistics
A company wants to increase the speed of their internet. They need to know how much additional bandwidth is needed. A winter intern is asked to track internet usage among employees in his department. What is a possible problem with the report he provides?
The types of internet sites that need to be accessed has not been considered
The internet has not protected anyone's privacy
The cost of expansion has not been considered
The survey is biased because all employees of the company have not been considered
You have created a presentation about network traffic and are making suggestions to improve operations based on your findings. You have been asked to submit your present findings and information to people who are in different offices in different cities around the country. What would be the appropriate tool for presenting this information?
Email handouts to the people
Set up a webcast meeting for everyone to connect and share your presentation
As a data analyst for an organization, which of the following is necessary to ensure your results are valid and ethical?
Repeat the collection of data several times to ensure consistent results each time
Verify and follow the process outlined for data collection as approved by a committee or oversight body
Profits at your company have been the same for the past three years. Your company is starting to expand its services. You will be presenting your company’s new business plan at the investors meeting. What information should you use to justify the new business plan?
Analysis of marketing focus groups indicates that a significant change in the messaging will attract additional customers
You interviewed competitors in the market and determined that they new services in will be profitable
You work at the Registrars department for a major university. You need to report on expected enrollments for the next school year's cycle of freshman class registration. You must work with several different departments in the university. Which internal organization will provide the least important data for your report?
Athletic department - for tickets sales and sporting events
Finance department - for financial aid applications
