Question 1

At what stage in the SDLC are programmers responsible for testing code?

Accepted Answer

A)  Development stage 
B)  Testing stage 
C)  Design stage 
D)  Analysis stage 
A)  Development stage 
B)  Testing stage 
C)  Design stage 
D)  Analysis stage A

Question 2

Which role in the SDLC is responsible for developing the plan for a systems' functionality and logic?

Accepted Answer

A)  IT steering committee 
B)  End users 
C)  Lead systems analyst 
D)  Core application programmers 
A)  IT steering committee 
B)  End users 
C)  Lead systems analyst 
D)  Core application programmers C

Question 3

You need to write a SQL command to add a new record to a table. Which command would you choose?

Accepted Answer

A)  ADD 
B)  INSERT 
C)  ALTER 
D)  CREATE 
A)  ADD 
B)  INSERT 
C)  ALTER 
D)  CREATE B

Question 4

You need to write a SQL command to retrieve data from a database. Which command would you choose?

Accepted Answer

A)  CREATE 
B)  COMMIT 
C)  SELECT 
D)  RETRIEVE 
A)  CREATE 
B)  COMMIT 
C)  SELECT 
D)  RETRIEVE

Question 5

You need to write a SQL command to delete an existing table and all records that it contains. Which command would you choose?

Accepted Answer

A)  DELETE 
B)  DROP 
C)  TRUNCATE 
D)  ROLLBACK 
A)  DELETE 
B)  DROP 
C)  TRUNCATE 
D)  ROLLBACK

Question 6

NoSQL databases store data

Accepted Answer

A)  individually with key-values. 
B)  in rows and columns. 
C)  in classes. 
D)  in schemas. 
A)  individually with key-values. 
B)  in rows and columns. 
C)  in classes. 
D)  in schemas.

Question 7

Amar is a new systems analyst with Ally Corporation. Amar is tasked with reviewing a requirements definition document for Ally. Which of the following should Amar suggest that Ally should have dealt with before creating the requirements definition?

Accepted Answer

A)  Documentation of the final project goal 
B)  Steps needed to achieve the project goal 
C)  An outline of the overall system plan 
D)  Risk and reward list for cloud-based versus local system 
A)  Documentation of the final project goal 
B)  Steps needed to achieve the project goal 
C)  An outline of the overall system plan 
D)  Risk and reward list for cloud-based versus local system

Question 8

Systems development projects can involve risks associated with

Accepted Answer

A)  incompatibility between the existing IT infrastructure and the system being developed. 
B)  inadequate design or testing resulting in a final product that functions poorly. 
C)  insufficient end-user training that yields poor adoption of the new system. 
D)  All of these answer choices are correct. 
A)  incompatibility between the existing IT infrastructure and the system being developed. 
B)  inadequate design or testing resulting in a final product that functions poorly. 
C)  insufficient end-user training that yields poor adoption of the new system. 
D)  All of these answer choices are correct.

Question 9

Alfred took the conceptual ERD that Alice created and added field names for each table. Alfred's work resulted in a

Accepted Answer

A)  physical ERD. 
B)  logical ERD. 
C)  conceptual ERD. 
D)  database ERD. 
A)  physical ERD. 
B)  logical ERD. 
C)  conceptual ERD. 
D)  database ERD.

Question 10

Write a SQL command that will pull all data from the Act table and the Event table only where the Acts have performed at an event.

Accepted Answer

SELECT * FROM Act
IN

Question 11

Josh is a leader on the new Smart Technology software project. Josh decided on Agile as the systems development methodology of choice for the project. At which stage in the SDLC should Josh include end users?

Accepted Answer

A)  Analysis 
B)  Design 
C)  Testing 
D)  All of these answer choices are correct. 
A)  Analysis 
B)  Design 
C)  Testing 
D)  All of these answer choices are correct.

Question 12

What advantages does a NoSQL database have over an object-oriented and relational database?

Accepted Answer

A)  NoSQL databases store data in objects that can handle the high velocity of big data generated. 
B)  NoSQL databases allow for faster processing and flexible storage for big, unstructured data. 
C)  NoSQL databases allow for faster processing of unstructured data by using rows and columns to quickly locate data. 
D)  NoSQL databases store data using key-values to categorize into classes and objects for speed of retrieval. 
A)  NoSQL databases store data in objects that can handle the high velocity of big data generated. 
B)  NoSQL databases allow for faster processing and flexible storage for big, unstructured data. 
C)  NoSQL databases allow for faster processing of unstructured data by using rows and columns to quickly locate data. 
D)  NoSQL databases store data using key-values to categorize into classes and objects for speed of retrieval.

Question 13

Why is it important for future accountants to study the SDLC?

Accepted Answer

A)  The CPA exam reflects the increased expectations that accounting professionals understand technology. 
B)  Accountants, as end users of accounting systems, often participate in determining requirements for projects. 
C)  Accountants who progress in their career to a director level or higher will see and work with departments throughout the organization, including technology. 
D)  All of these answer choices are correct. 
A)  The CPA exam reflects the increased expectations that accounting professionals understand technology. 
B)  Accountants, as end users of accounting systems, often participate in determining requirements for projects. 
C)  Accountants who progress in their career to a director level or higher will see and work with departments throughout the organization, including technology. 
D)  All of these answer choices are correct.

Question 14

Diagram and categorize the following information into database selection considerations:
1. Data will be stored in a data warehouse.
2. Data captured will be structured in nature.
3. The system currently captures 1 megabyte of data per week.
4. In the next year, the system data capture will increase to 2 megabytes per week.
5. The current database can handle 25 concurrent database connections, but the new system could require the database to handle four times the concurrent connections.

Accepted Answer

Database S

Question 15

Object-oriented databases group similar objects together in a

Accepted Answer

A)  class. 
B)  record. 
C)  variable. 
D)  file. 
A)  class. 
B)  record. 
C)  variable. 
D)  file.

Question 16

An advantage that object-oriented databases have over relational databases are

Accepted Answer

A)  that the two-dimensional structure is easy to understand. 
B)  the ability to store both structured and unstructured data. 
C)  its wide adoption for accounting systems. 
D)  All of these answer choices are correct. 
A)  that the two-dimensional structure is easy to understand. 
B)  the ability to store both structured and unstructured data. 
C)  its wide adoption for accounting systems. 
D)  All of these answer choices are correct.

Question 17

Explain how business rules are used to define relationships in a database?

Accepted Answer

Business rules are written statements th

Question 18

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query?

Accepted Answer

A)  SELECT * FROM Customer WHERE State  'TX' 
B)  SELECT * FROM Customer WHERE State not = 'TX' 
C)  SELECT all FROM Customer WHERE State  'TX' 
D)  SELECT all FROM Customer WHERE State not = 'TX' 
A)  SELECT * FROM Customer WHERE State  'TX' 
B)  SELECT * FROM Customer WHERE State not = 'TX' 
C)  SELECT all FROM Customer WHERE State  'TX' 
D)  SELECT all FROM Customer WHERE State not = 'TX'

Question 19

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX') and the payment method (field is 'PaymentMethod') is American Express ('AMEX'). Which of the following SQL statements will work for your query?

Accepted Answer

A)  SELECT all FROM Customer WHERE State  'TX' and PaymentMethod = 'AMEX' 
B)  SELECT all FROM Customer WHERE State not = 'TX' and PaymentMethod = 'AMEX' 
C)  SELECT * FROM Customer WHERE State  'TX' and PaymentMethod = 'AMEX' 
D)  SELECT * FROM Customer WHERE State not = 'TX' and PaymentMethod = 'AMEX' 
A)  SELECT all FROM Customer WHERE State  'TX' and PaymentMethod = 'AMEX' 
B)  SELECT all FROM Customer WHERE State not = 'TX' and PaymentMethod = 'AMEX' 
C)  SELECT * FROM Customer WHERE State  'TX' and PaymentMethod = 'AMEX' 
D)  SELECT * FROM Customer WHERE State not = 'TX' and PaymentMethod = 'AMEX'

Question 20

Which type of database stores structured data in two-dimensional tables?

Accepted Answer

A)  Relational 
B)  Object-oriented 
C)  NoSQL 
D)  All of these answer choices are correct. 
A)  Relational 
B)  Object-oriented 
C)  NoSQL 
D)  All of these answer choices are correct.

At what stage in the SDLC are programmers responsible for testing code?

Which role in the SDLC is responsible for developing the plan for a systems' functionality and logic?

You need to write a SQL command to add a new record to a table. Which command would you choose?

You need to write a SQL command to retrieve data from a database. Which command would you choose?

You need to write a SQL command to delete an existing table and all records that it contains. Which command would you choose?

NoSQL databases store data

Amar is a new systems analyst with Ally Corporation. Amar is tasked with reviewing a requirements definition document for Ally. Which of the following should Amar suggest that Ally should have dealt with before creating the requirements definition?

Systems development projects can involve risks associated with

Alfred took the conceptual ERD that Alice created and added field names for each table. Alfred's work resulted in a

Write a SQL command that will pull all data from the Act table and the Event table only where the Acts have performed at an event.

Josh is a leader on the new Smart Technology software project. Josh decided on Agile as the systems development methodology of choice for the project. At which stage in the SDLC should Josh include end users?

What advantages does a NoSQL database have over an object-oriented and relational database?

Why is it important for future accountants to study the SDLC?

Object-oriented databases group similar objects together in a

An advantage that object-oriented databases have over relational databases are

Explain how business rules are used to define relationships in a database?

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query?

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX') and the payment method (field is 'PaymentMethod') is American Express ('AMEX'). Which of the following SQL statements will work for your query?

Which type of database stores structured data in two-dimensional tables?

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Data Storage and Analysis

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters

Exam 6: Systems and Database Design

At what stage in the SDLC are programmers responsible for testing code?

Which role in the SDLC is responsible for developing the plan for a systems' functionality and logic?

You need to write a SQL command to add a new record to a table. Which command would you choose?

You need to write a SQL command to retrieve data from a database. Which command would you choose?

You need to write a SQL command to delete an existing table and all records that it contains. Which command would you choose?

NoSQL databases store data

Amar is a new systems analyst with Ally Corporation. Amar is tasked with reviewing a requirements definition document for Ally. Which of the following should Amar suggest that Ally should have dealt with before creating the requirements definition?

Systems development projects can involve risks associated with

Alfred took the conceptual ERD that Alice created and added field names for each table. Alfred's work resulted in a

Write a SQL command that will pull all data from the Act table and the Event table only where the Acts have performed at an event.

Josh is a leader on the new Smart Technology software project. Josh decided on Agile as the systems development methodology of choice for the project. At which stage in the SDLC should Josh include end users?

What advantages does a NoSQL database have over an object-oriented and relational database?

Why is it important for future accountants to study the SDLC?

Object-oriented databases group similar objects together in a

An advantage that object-oriented databases have over relational databases are

Explain how business rules are used to define relationships in a database?

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX'). Which of the following SQL statements will work for your query?

You need to write a query to retrieve all customer information (table is 'Customer') for customers who do NOT live in Texas ('TX') and the payment method (field is 'PaymentMethod') is American Express ('AMEX'). Which of the following SQL statements will work for your query?

Which type of database stores structured data in two-dimensional tables?

Accounting As Information

Risks and Risk Assessments

Risk Management and Internal Controls

Software and Systems

Data Storage and Analysis

Emerging and Disruptive Technologies

Documenting Systems and Processes

Human Resources and Payroll Processes

Purchasing and Payments Process

Conversion Processes

Marketing, Sales, and Collection Processes

Financial Reporting Processes

Information Systems and Controls

Fraud

Cybersecurity

Data Analytics

Data Visualization

Audit Assurance

Filters