Question 1

At the end of the current sprint, Astrid, the product owner, will seek feedback by presenting which scrum artifact to the end users?

Accepted Answer

A)  Product backlog 
B)  Spring backlog 
C)  Product increment 
D)  All of these answer choices are correct. 
A)  Product backlog 
B)  Spring backlog 
C)  Product increment 
D)  All of these answer choices are correct.

Question 2

Allure Technologies assists small business owners with database storage technologies. Allure designs and hosts databases for many small businesses that include transaction data and large unstructured data used for analysis purposes. What kind of database management system will work best for Allure and why?

Accepted Answer

Allure needs to implement an object-orie

Question 3

Relational databases are designed to reduce redundancy by

Accepted Answer

A)  not allowing more than 5 fields per table. 
B)  ensuring that the primary key is not null. 
C)  referencing needed data already stored in a different table. 
D)  storing duplicate data in foreign keys. 
A)  not allowing more than 5 fields per table. 
B)  ensuring that the primary key is not null. 
C)  referencing needed data already stored in a different table. 
D)  storing duplicate data in foreign keys.

Question 4

Adrian, a scrum master for the company's new project, receives suggestions for features from end users. Which scrum artifact is the appropriate place for Adrian to log the end-user feature requests?

Accepted Answer

A)  Product backlog 
B)  Sprint backlog 
C)  Product increment 
D)  All of these answer choices are correct. 
A)  Product backlog 
B)  Sprint backlog 
C)  Product increment 
D)  All of these answer choices are correct.

Question 5

What is a scrum master?

Accepted Answer

A)  Champion of the core development team 
B)  Someone who clears obstacles from the core team's path 
C)  Someone who ensures focus on Agile principles 
D)  All of these answer choices are correct. 
A)  Champion of the core development team 
B)  Someone who clears obstacles from the core team's path 
C)  Someone who ensures focus on Agile principles 
D)  All of these answer choices are correct.

Question 6

Campbell Marketing Solutions (CMS) has grown in the past few years and is considering upgrading their current database management system. The data that CMS would like to store in the new database includes social media posts, photographs, and videos, though the type of data seems to continually change. CMS knows that they will need to scale often and retrieve large amounts of various data. Which kind of database should CMS use?

Accepted Answer

A)  Relational 
B)  Object-oriented 
C)  NoSQL 
D)  Any of these database models could work for CMS. 
A)  Relational 
B)  Object-oriented 
C)  NoSQL 
D)  Any of these database models could work for CMS.

Question 7

The unique IDs that identify every record in a relational database are referred to as

Accepted Answer

A)  keys. 
B)  data. 
C)  cardinals. 
D)  nulls. 
A)  keys. 
B)  data. 
C)  cardinals. 
D)  nulls.

Question 8

The unique ID for a table is the

Accepted Answer

A)  primary key. 
B)  foreign key. 
C)  referential integrity. 
D)  entity integrity. 
A)  primary key. 
B)  foreign key. 
C)  referential integrity. 
D)  entity integrity.

Question 9

Davidson Equipment Company is working through the SDLC framework in an effort to successfully build and implement a new parts inventory system. Davidson is unsure what technology will be needed for the system. What element in the design stage needs to be completed to resolve this issue for Davidson?

Accepted Answer

A)  Conceptual design 
B)  Technical architecture specifications 
C)  Systems model 
D)  Graphical user interface 
A)  Conceptual design 
B)  Technical architecture specifications 
C)  Systems model 
D)  Graphical user interface

Question 10

Which of the following statements about the Waterfall systems development methodology are TRUE?

Accepted Answer

A)  The Waterfall method must be executed in a linear fashion with each step overlapping the next. 
B)  The Waterfall method uses the seven stages of the SDLC framework and is not customizable. 
C)  Each stage in the Waterfall method is completed before continuing to the next stage. 
D)  The first stage in the Waterfall method is planning; the final stage is implementation. 
A)  The Waterfall method must be executed in a linear fashion with each step overlapping the next. 
B)  The Waterfall method uses the seven stages of the SDLC framework and is not customizable. 
C)  Each stage in the Waterfall method is completed before continuing to the next stage. 
D)  The first stage in the Waterfall method is planning; the final stage is implementation.

Question 11

Which cardinality type is represented by this crow's foot cardinality notation?

Accepted Answer

A)  One and only one 
B)  No more than one 
C)  At least one 
D)  Any 
A)  One and only one 
B)  No more than one 
C)  At least one 
D)  Any

Question 12

Risk is created using the Waterfall method when developers do NOT receive feedback until project completion because of

Accepted Answer

A)  changes in user expectations. 
B)  changes in requirements. 
C)  changes in business processes. 
D)  All of these answer choices are correct. 
A)  changes in user expectations. 
B)  changes in requirements. 
C)  changes in business processes. 
D)  All of these answer choices are correct.

Question 13

The planning stage of the SDLC includes

Accepted Answer

A)  creating a project plan. 
B)  a feasibility study. 
C)  identifying necessary resources. 
D)  All of these answer choices are correct. 
A)  creating a project plan. 
B)  a feasibility study. 
C)  identifying necessary resources. 
D)  All of these answer choices are correct.

Question 14

Referencing the ERD, what will this SQL command yield:
SELECT * FROM Act WHERE ActGenre = 'Pop'

Accepted Answer

A)  The results will include the ActID, ActName, and ActGenre for all Pop acts. 
B)  The results will include the ActID, ActName, EventID, EventDate, EventTime, EventName, and EventLocation for all Pop acts. 
C)  The results will include the ActID and EventID for all Pop acts. 
D)  The results will include the ActID, ActName, and ActGenre for all Acts. 
A)  The results will include the ActID, ActName, and ActGenre for all Pop acts. 
B)  The results will include the ActID, ActName, EventID, EventDate, EventTime, EventName, and EventLocation for all Pop acts. 
C)  The results will include the ActID and EventID for all Pop acts. 
D)  The results will include the ActID, ActName, and ActGenre for all Acts.

Question 15

Tables in a relational database must be connected in a meaningful order to allow for the retrieval of information. The design process for a database is referred to as

Accepted Answer

A)  database diagraming. 
B)  entity modeling. 
C)  data modeling. 
D)  entity diagramming. 
A)  database diagraming. 
B)  entity modeling. 
C)  data modeling. 
D)  entity diagramming.

Question 16

Azle Corporation has a new software development project and is evaluating methodologies to determine the best fit for their current situation. Azle employees are currently working from home with some in remote areas with little Internet access. The project has clearly defined requirements and a firm budget. Which software development methodology would you recommend to Azle?

Accepted Answer

A)  Waterfall 
B)  Agile 
C)  Scrum 
D)  All of these answer choices are correct. 
A)  Waterfall 
B)  Agile 
C)  Scrum 
D)  All of these answer choices are correct.

Question 17

Which implementation method moderates risk by implementing a new system with only a small group of users before going live for the entire company?

Accepted Answer

A)  Direct cutover 
B)  Parallel implementation 
C)  Phased implementation 
D)  Pilot implementation 
A)  Direct cutover 
B)  Parallel implementation 
C)  Phased implementation 
D)  Pilot implementation

Question 18

Referential integrity states that

Accepted Answer

A)  the primary key cannot be null. 
B)  a foreign key cannot be inserted into a table unless it already exists as a primary key. 
C)  relational databases must reduce redundancy. 
D)  relational databases must manage data integrity, accuracy, and consistency. 
A)  the primary key cannot be null. 
B)  a foreign key cannot be inserted into a table unless it already exists as a primary key. 
C)  relational databases must reduce redundancy. 
D)  relational databases must manage data integrity, accuracy, and consistency.

Question 19

Which relational database term is synonymous with file and is a group of records for a specific entity?

Accepted Answer

A)  Field name 
B)  Record 
C)  Table 
D)  Database 
A)  Field name 
B)  Record 
C)  Table 
D)  Database

Question 20

Dikshya writes a SELECT command to retrieve data from the database. Which type of SQL language is Dikshya using?

Accepted Answer

A)  Data definition language 
B)  Data manipulation language 
C)  Data control language 
D)  Data querying language 
A)  Data definition language 
B)  Data manipulation language 
C)  Data control language 
D)  Data querying language

At the end of the current sprint, Astrid, the product owner, will seek feedback by presenting which scrum artifact to the end users?

Relational databases are designed to reduce redundancy by

Adrian, a scrum master for the company's new project, receives suggestions for features from end users. Which scrum artifact is the appropriate place for Adrian to log the end-user feature requests?

What is a scrum master?

The unique IDs that identify every record in a relational database are referred to as

The unique ID for a table is the

Davidson Equipment Company is working through the SDLC framework in an effort to successfully build and implement a new parts inventory system. Davidson is unsure what technology will be needed for the system. What element in the design stage needs to be completed to resolve this issue for Davidson?

Which of the following statements about the Waterfall systems development methodology are TRUE?

Which cardinality type is represented by this crow's foot cardinality notation?

Risk is created using the Waterfall method when developers do NOT receive feedback until project completion because of

The planning stage of the SDLC includes

Referencing the ERD, what will this SQL command yield: SELECT * FROM Act WHERE ActGenre = 'Pop'

Tables in a relational database must be connected in a meaningful order to allow for the retrieval of information. The design process for a database is referred to as

Which implementation method moderates risk by implementing a new system with only a small group of users before going live for the entire company?

Referential integrity states that

Which relational database term is synonymous with file and is a group of records for a specific entity?

Dikshya writes a SELECT command to retrieve data from the database. Which type of SQL language is Dikshya using?

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 the end of the current sprint, Astrid, the product owner, will seek feedback by presenting which scrum artifact to the end users?

Relational databases are designed to reduce redundancy by

Adrian, a scrum master for the company's new project, receives suggestions for features from end users. Which scrum artifact is the appropriate place for Adrian to log the end-user feature requests?

What is a scrum master?

The unique IDs that identify every record in a relational database are referred to as

The unique ID for a table is the

Which of the following statements about the Waterfall systems development methodology are TRUE?

Which cardinality type is represented by this crow's foot cardinality notation?

Risk is created using the Waterfall method when developers do NOT receive feedback until project completion because of

The planning stage of the SDLC includes

Referencing the ERD, what will this SQL command yield: SELECT * FROM Act WHERE ActGenre = 'Pop'

Tables in a relational database must be connected in a meaningful order to allow for the retrieval of information. The design process for a database is referred to as

Which implementation method moderates risk by implementing a new system with only a small group of users before going live for the entire company?

Referential integrity states that

Which relational database term is synonymous with file and is a group of records for a specific entity?

Dikshya writes a SELECT command to retrieve data from the database. Which type of SQL language is Dikshya using?

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