Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
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
Right join Ex- show me all orders, even if no customer is linked
26
A star schema is best used for which databases?
Data warehouse and data mart
27
What data transformation technique involves standardizing the codes?
Decoding
28
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
Conceptual Ex- we need to store information about customers and their orders
29
What database is 1. More detailed than a conceptual 2.define the attributes (tables, columns, relationships)
Logical Ex- a customer table has “customer id”, name, and email columns
30
What database is 1. The actual implementation of the database 2. Focuses on how the data is store- files, servers, indexing
Physical schema
31
Whats the correct order of execution for SQL queries?
1.From 2.where 3. group by 4. Having 5. Select 6. Order by 7. Limit
32
What constraint will tell you if someone isn't formatted correctly?
Domain constraint
33
What interface allows you to share data in real time without human intervention?
Application programming interfaces
34
What backup strategy do you want If prefer efficient and continuous availability?
Incremental
35
Minimizing media storage is an advantage to which backup type?
Incremental
36
What backup combo has the fastest backup time?
Full backups and incremental back ups
37
Which disaster recovery concept will protect against hardware failure?
Redundacy
38
What stage of data life cycle involves implementation of procedures to ensure info is up to date and accurate?
Monitor
39
What database model contains basic entities that have data structures and operatikns
Object oriented
40
What are 3 characteristics of network data model?
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
Which data model is suitable for predetermined data relationships?
Hierarchical
42
What subdimesion is the range and proportion of data values that agree with the actual values?
Intrinsic
43
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?
Contextual
44
The range and proportion of information that is available or accessible?
Security/accessibility
45
What check control examines the order of data elements?
Sequence check Clerk processed check 91 and then enter 93
46
What check validates data against predetermined. It prevents errors, security vulnerabilities by ensuring values fall within acceptable limits?
Limit check
47
What control verifies data values within specified range? Confirms values are within scopes, crucial in scenarios like temp monitoring?
Range check The user is allowed to select a number between 1-5
48
What control confirms that data conforms to predefined rules?
Validity check Clerk entered the letter “G” in the phone number field, and the system promoted an error.
49
What control verifies the presence and non-null values of data?
Existence check Verifying a customers id number corresponds to a current customer in the database
50
What control assesses the presence and validity of all required data? Helps avoid oversight and inaccuracies
Completeness check User is promoted to enter data in all mandatory fields before moving to next steps
51
Who is responsible for physical design, logical design, and security of a database?
Data administrator
52
What connects on premises systems behind a firewall to cloud based applications?
Integration platform as a service
53
What software reduces the need to manual data entry by scans documents to extract data
Character recognition
54
What is decoding?
Data trsnformation technique that involves standardizing the codes for data ex- two systems use two different codes for the same label.
55
What do Pools and Lanes represent in a business process model and notation (BPMN)
Pools - Represent participants in a process Lanes - Divide the pools into roles or sub-processes
56
Data governance policies and procedures are driven by?
Data Stewards - They also train new data owners and employees
57
In what way does the Order by clauses return values?
ascending order
58
In what way does adding DESC to the Order by clauses return values?
Descending order
59
What Data has a specific format or schema, such as tables with fields and records?
structured data user ID from a smartphone app customer purchase history
60
What data has a partial structure but is not as defined as structured data?
semi-structured data -tagged posts from social media
61
what data is raw data that doesn't have a predefined format?
Unstructured data PDF and video clips

CPA ISC (12 decks)

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