Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CPA ISC > Chapter 4 Data Management > Flashcards

Chapter 4 Data Management Flashcards

1
Q

What are the responsibilities of Data Owners?

A

authorizing new user access and ensuring that access to data is updated upon user employment changes (e.g., termination, promotion, or transfers).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What do Gateways Do in a business model?

A

represent decision paths in a business process. They help model conditional behavior and control the flow of the process based on conditions or events.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How Many Keys does Symmetric encryption use?

A

One is used to both encrypt and decrypt information. They must exchange the key so that it can be used in the decryption process

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Who Sets the policies and procedures for Data governance?

A

The Data Governance Committee

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is Data Collecting?

A

Gather data from different sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What Step in Data Integration Ensures Data quality and accuracy?

A

Data Cleansing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is Data transformation?

A

Convert Data into a common format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the first stage of the Data lifecycle? What happens

A

Planning- The business identifies info used in the processes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the second stage of the Data lifecycle? What happens

A

Design - development info standards and procedures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the third stage of the Data lifecycle? What happens

A

build/acquire - records are created or bought

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the 4th stage of the Data lifecycle? What happens

A

use- data is stored and available to use and shared

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is the 5th stage of the Data lifecycle? What happens

A

monitoring - procedures are put in place to ensure its up to date and accurate.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the Key Components of an AIS System?

A

Financial Transactions, reporting, Data storage, and compliance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is Data Reorganization?

A

Deletion of Unused space in the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

what is data Restructuring?

A

Performing Physical and Logical Physical Changes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are Job Stream Checkpoints?

A

used to Minimize Data loss and to recover data after a system Failure

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are the 3 advantages of the Hierarchical Data model?

A
  1. Proven performance,
  2. SImplicity
  3. Reduction of Data Dependency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

describes the properties of a hierarchical database model

A
  1. A model always starts with a root node.
  2. A parent node must have at least one dependent node.
  3. Every node except the root must be accessed through its parent node.
  4. Except at level 1—the root node—the dependent node can be added horizontally as well as vertically with no limitation.
  5. There can be several occurrences of each node at each level.
  6. Every node occurring at level 2 must relate to one and only one node occurring at level 1, and the node is repeated downward.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What is the relational database model?

A

it is recognized as the most suitable for laymen and end users because of its basic formulation.

Query language innovations use this model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What database model can be related to a family tree concept, where the parents can have no children, one child, or more than one child?

A

Hierarchical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What data model is depicted using blocks and arrows? A block represents a record type or an entity.

A

Network

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What database model consists of columns equal to data elements in a conventional file and rows equal to data records in a traditional file, represented in a table?

A

Relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which of the data joins
1. Combines data from two tables
2. Only returns a match in both tables

A

Inner join

Ex- show me customers who have placed orders

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

What data join
1. Returns all rows from the left table and matching ones from right
2. Will return “null” if no match in right table

A

Left join

Ex- show me all customers, even if they haven’t placed an order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What data join

  1. Returns all rows from the right table and matching ones from the left
    2.will return null if no match in the left column
A

Right join

Ex- show me all orders, even if no customer is linked

26
Q

A star schema is best used for which databases?

A

Data warehouse and data mart

27
Q

What data transformation technique involves standardizing the codes?

A

Decoding

28
Q

What database shows

  1. The big picture/ high level?
  2. Based on initial phases of design
  3. Focuses on what data needs to be stored not how
A

Conceptual

Ex- we need to store information about customers and their orders

29
Q

What database is
1. More detailed than a conceptual
2.define the attributes (tables, columns, relationships)

A

Logical

Ex- a customer table has “customer id”, name, and email columns

30
Q

What database is

  1. The actual implementation of the database
  2. Focuses on how the data is store- files, servers, indexing
A

Physical schema

31
Q

Whats the correct order of execution for SQL queries?

A

1.From
2.where
3. group by
4. Having
5. Select
6. Order by
7. Limit

32
Q

What constraint will tell you if someone isn’t formatted correctly?

A

Domain constraint

33
Q

What interface allows you to share data in real time without human intervention?

A

Application programming interfaces

34
Q

What backup strategy do you want If prefer efficient and continuous availability?

A

Incremental

35
Q

Minimizing media storage is an advantage to which backup type?

A

Incremental

36
Q

What backup combo has the fastest backup time?

A

Full backups and incremental back ups

37
Q

Which disaster recovery concept will protect against hardware failure?

A

Redundacy

38
Q

What stage of data life cycle involves implementation of procedures to ensure info is up to date and accurate?

A

Monitor

39
Q

What database model contains basic entities that have data structures and operatikns

A

Object oriented

40
Q

What are 3 characteristics of network data model?

A
  1. There is only one owner in a set
  2. There may be zero, one, or many members in a set
  3. A set is composed of related records
41
Q

Which data model is suitable for predetermined data relationships?

A

Hierarchical

42
Q

What subdimesion is the range and proportion of data values that agree with the actual values?

A

Intrinsic

43
Q

What subdismension is the range and proportion of information that is applicable and relevant to the users task and presented in a manner that satisfies users data requirements?

A

Contextual

44
Q

The range and proportion of information that is available or accessible?

A

Security/accessibility

45
Q

What check control examines the order of data elements?

A

Sequence check

Clerk processed check 91 and then enter 93

46
Q

What check validates data against predetermined. It prevents errors, security vulnerabilities by ensuring values fall within acceptable limits?

A

Limit check

47
Q

What control verifies data values within specified range? Confirms values are within scopes, crucial in scenarios like temp monitoring?

A

Range check

The user is allowed to select a number between 1-5

48
Q

What control confirms that data conforms to predefined rules?

A

Validity check

Clerk entered the letter “G” in the phone number field, and the system promoted an error.

49
Q

What control verifies the presence and non-null values of data?

A

Existence check

Verifying a customers id number corresponds to a current customer in the database

50
Q

What control assesses the presence and validity of all required data? Helps avoid oversight and inaccuracies

A

Completeness check

User is promoted to enter data in all mandatory fields before moving to next steps

51
Q

Who is responsible for physical design, logical design, and security of a database?

A

Data administrator

52
Q

What connects on premises systems behind a firewall to cloud based applications?

A

Integration platform as a service

53
Q

What software reduces the need to manual data entry by scans documents to extract data

A

Character recognition

54
Q

What is decoding?

A

Data trsnformation technique that involves standardizing the codes for data

ex- two systems use two different codes for the same label.

55
Q

What do Pools and Lanes represent in a business process model and notation (BPMN)

A

Pools - Represent participants in a process
Lanes - Divide the pools into roles or sub-processes

56
Q

Data governance policies and procedures are driven by?

A

Data Stewards - They also train new data owners and employees

57
Q

In what way does the Order by clauses return values?

A

ascending order

58
Q

In what way does adding DESC to the Order by clauses return values?

A

Descending order

59
Q

What Data has a specific format or schema, such as tables with fields and records?

A

structured data

user ID from a smartphone app
customer purchase history

60
Q

What data has a partial structure but is not as defined as structured data?

A

semi-structured data

-tagged posts from social media

61
Q

what data is raw data that doesn’t have a predefined format?

A

Unstructured data

PDF and video clips

CPA ISC (14 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions