DIGITAL systems exam 2

datacenter

A cloud database infrastructure integrates computer hardware and operating system in an internet-based _____.

Foreign key

A common field between tables that is not the primary key

tables

A database and a DBMS are different. A database is a collection of metadata, relationships, and ______.

Row

A database record is also referred to as a ______ in the table.

Link

A database relationship is a(n) ____ between tables that define how the data are related.

Centralized database

A key component, and major advantage, of an ERP is its

Scalable

A major trend in data analytics is the use of artificial intelligence to focus on small data which is more precise, using small datasets that are capable of impacting decisions in the present. This is known as ______Blank AI

cloud service providers.

Amazon, Kamatera, Salesforce, and Google are all examples of

wide area network (WAN)

An investment firm creates a network designed to facilitate information exchange between devices at its offices in New York City and New Haven, Connecticut. Which type of network would the company use to exchange information?

security

Areas covered in digital governance include data architecture, data quality, data modeling, data warehousing, and data _____.

Relational

Because we can create relationships in Microsoft Access, this program is considered to be a(n) _____ database

Records

Collections of related fields in a database are referred to as

Five aspects if analytical skills

Curiosity, understanding context, having a technical mindset, data design, data strategy

Accessible

Data governance policies help to ensure an organization's data is valid, understandable, complete, and _____

Analyzing

Data mining is a means of _____ data that can help organizations find patterns and relationships within data sets

errors

Data scrubbing (data cleaning) involves identifying _____ in data sets then duplicating these errors to ensure the data is accurate for an organization.

Share

Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?

labels

Database reports are useful in many ways; one way a report is used is to provide details about individual records and to create ___

Objects

Databases maintain data and information about various types of data ____

DBMS

Forms are created using ____ software

SQL

In a data warehouse, data is analyzed using business intelligence (BI) tools, ______ clients, and a variety of analytics applications designed to interpret the data.

TPS software

Integrating a business software module into an ERP has several advantages. Which of the following business software modules includes customer payment information?

Data Mining

Knowledge Discovery in Data (KDD) is also known as _______

Financial management systems software

Must be integrated into an organization's enterprise resource management solution to allow it to create and maintain regulatory and compliance information from a centralized location

AutoCAD

One of the first computer aided design programs ever developed was also among the first to be integrated into ERP systems. This popular program is

Data

Online Analytical Processing (OLAP) is included in many Business Intelligence (BI) software applications. We use this OLAP for a range of _______ discovery activities, including report creation and analysis, analytical calculations, forecasting, budgeting, planning, and what-if predicative analysis

Ask, Prepare, Process, Analyze, Share, Act

Six steps to create data driven decision

Planning

Software that businesses use to manage activities in both the internal and external operational environment is known as Enterprise Resource

Analyst

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data

backup

Tasks of a database administrator (DBA) include database security, tuning, _____, and creation of queries and reports used to assist business decisions.

folksonomy

The key feature of Web 2.0 that allows users to collectively classify information, such as by tagging websites and online images, is called

data analytics.

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is

terabytes to zettabytes.

The size of Big Data ranges from

common

To create a relationship between two tables, you must use a ____ field that is present in both tables.

primary

To set a primary key field in a database table, you must click the ______ key button.

Learning curves

Users often find it difficult to implement or even comprehend a new ERP system without significant training because of ERPs' steep

access rules

Using a Database Management System (DBMS) increases data security by using ____ so that only authorized users can access data.

Select

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the _____ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

proliferation of e-commerce-based organizations

What aspect of today's business environment is central to the need for robust transaction management processing systems?

A cloud deployment model defines the framework of a cloud environment.

What is a cloud deployment model?

Illustrates patterns in data

What is one of the advantages of data visualization?

It improves communication and understanding.

What is the benefit of designing data visualizations for the target audience?

Digital Signal Processor (DSP)

What is the correct term for the small computer within a smartphone that analyzes the sounds entering your phone through the analog/digital converter?

A cloud service provides users with increased computing power and data management, whereas a web service provides the software tools needed for devices and systems to communicate with each other.

What is the difference between a cloud service and a web service?

increase operational efficiency

What is the overarching goal of organizations choosing to adopt an enterprise resource planning (ERP) system?

people who validate cryptocurrency transactions on the digital ledger

What type of computer users are considered miners?

Parts-to-whole relationships

What type of relationships do pie charts primarily represent?

data types

When creating a database field, we set ______ for each field to decrease data input mistakes.

table

When creating a relationship in a relational database management system (DBMS), which object is used?

Third party

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered _____ data.

Design View

Which View lets you change database table Field Names and Field Properties?

Ethereum

Which cryptocurrency offers a blockchain-based platform that can be used to develop decentralized applications?

Tableau

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?

e-commerce operations

Which type of ERP module collects data such as customer information, order history, shipping information, and customer satisfactions measures?

cloud-based forums, messaging, and meeting apps

Which type of collaboration software could best help an organization increase engagement between remote employees and those who are "in-house" or organization-based?

High costs

While ERP systems offer many competitive advantages to users, particularly those in upper management, a significant disadvantage is their

statistical

data quality audit uses ________Blank analysis to test data, variabilities, and outcomes against test data.