DATABASE

Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings?

- Netflix tracks what users who viewed all three seasons of stranger things also had their queues -an in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received are for falling in their homes

Which of the following sets of characteristics specifically apply to relational database

- a relational database organizes data in tables composed of records or objects (the rows), and fields(the columns) -data tables in a relational database are linked by the fields they have in common

Which of the following is an example of what an information policy could specify?

- a user agreement on a website indicates that it will store the browsing history linked to the IP address for an indefinite amount of time and reserves the right to sell that information to interested parties - a large corporation grants access to salary information to the direct supervisor of employees and to the members of the Human Resources department who administer payroll - a health insurance company stores data that patients self-report as inputs on its website, but does not link the data with information about the patients search history

Which of the following are advantages of cloud databases over a traditional database?

- can supper both SQL and NoSQL databases - are maintained by an external provider, such as Amazon or oracle -can be accessed through an application programming interface(API)

Which of the following task are NoSQL databases designed to do?

- create queries from the data created from web apps - manage large datasets across different platforms - analyze nonstructured data

Which of the following statements correctly describes referential integrity?

- data on both sides of the table relationship must be present - data quality within the structure of a relational database

Why is online analytical processing(OLAP) software included in many business intelligence(BI) software applications?

- it allows reports and analytics to be exported to more user-friendly,front-end tools - it allows users to view data from different perspectives or angles and gain new insight -it allows for sophisticated data and trend analysis, data modeling, and forecasting

Which of the following improvements might be the direct outcome of a data quality audit?

- recommendations for a new data management design and prescription for preserving data quality - corrections is source data issues and ways to examine data over time - eliminating of redundant metadata and strengthened referential integrity

Select two statements that correctly explain the roles of data Marta and data warehouses in a decision support system(DSS)

-data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area - data warehouses are use to analyze long-term, historical data for an organizations strategic purposes, because they store data from different time periods and subject areas

Which statement explains the difference between a database and a database management system (DBMS)

A DBMS is a software program designed to organize and administer database

A database management system(DBMS)

A computer program that is used to help organize the data found in a database

data mining

A research and analysis technique in which data analysts mathematical tools and artificial intelligence (AI) to search large volumes of data and discover less-obvious patterns and trends

Database management system(DBMS) make it easier to secure data and information because they

Allow for the creation of access constraints

Primary Key

An important field that contains a unique value that identifies each record as individual

Velocity

Analysis of streaming data

Action Queries

Append , delete , update , and make-table queries

The four steps in a data quality audit

Assessment Design Transformation Monitoring

Organizations often use data scrubbing software because it

Automatically analyzes data, then fixes any errors, and consistently formats the data according to an organizations guidelines

Cross tab queries

Calculate sum , average , or other aggregate functions

Date integrity is increased when

Data is centralized

How are data marts different from data warehouses?

Data marts focus on an individual department or business function and manage less data than a date warehouse

Which statement best explains why traditional file systems have certain issues?

Each file is independent of another file in a traditional system

data administration

Establishes how an organization manages its data and making sure the organization adheres to these methods.

Business use business intelligence(BI) systems to

Help them make decisions that are informed by business data and facts

In memory computing function

Help unite transactional and analytical processing to provide real-time insights and analytics. This creates an environment that increases the amount and speed at which data can be ingested and analyzed

Business can use in memory computing to conduct or support almost any task that

Involves the near-instantaneous processing and analysis of huge volumes of data

How does the structure of an online analytical processing(OLAP) database shape it's core functionality

It's use of data cubes allows users to conduct complex queries, analyses, and modeling by taking multiple dimensions of data into account and viewing data from multiple viewpoints or "slices"

Which of these steps in the data mining process most likely involves the actual "mining" or "knowledge discovery in data"?

Model building and evaluation

I'm contrast to computerized systems, traditional file management systems can create issues with

Organization, repetition, and place of consistency

Why it is important for all organizations , no matter how small, to create and implement organizational information policies?

Organizational data are critical asset; it is important to ensure its security

Data normalization

Organizing data so that data are in simple tables without any redundancies

parameter query

Prompt the user for values in order to run/execute the query

The important goals of data governance(DG) are to

Protect data from risk, misuse, regulatory noncompliance, and quality and cost issues

Analytic platforms are designed to

Quickly gather and analyze specific organizational data to provide information that guides decision making

volumn

Scale of data

Web mining by organizations

Site visibility Usability Accessibility

The primary characteristic of a relational database is that it___

Stores and allows access to data objects that are related to one another

Which statements best summarizes the primary advantages of performing a data quality audit?

The audit recommends ways the organization can improve its data quality and reduce cost through increasing data consistency

Date Integrity

The information entered is accurate, timely, and useful

Why do large driven companies use analytic platforms

They generate vast amounts of organizational data and need to be able to rapidly analyze and interpret this information to make informed business decisions

Forms

To control how data is entered into a database and ensure data integrity

Queries

Users can find specific information quickly by using filters based on specific criteria databases

variety

different forms of data

veracity

uncertainty of data