Ch. 7 Quiz

You are investigating how a solution affects a particular stakeholder group after that solution has been deployed. What Solution Evaluation task are you performing? a. Assessing enterprise limitations b. Analyzing performance measures c. Assessing solution limitations d. Measuring solution performance

A. Assessing enterprise limitations

What does denormalization refer to?

Consciously choosing to violate the rules of normality in order to improve speed or for some other business reason

T/F: A database must include one or more relationship.

False

What would you use a relationship to connect? a. A customer with their favorite table in the restaurant. b. A customer's email address and phone number. c. The price of a dish and the name of that dish. d. A customer's first name and last name.

a. A customer with their favorite table in the restaurant.

What does the term transaction mean? a. All of the steps for an action must be completed. b. The action being taken is financial in nature. c. The action was initiated by a customer. d. The action is transferring data from one cell to another.

a. All of the steps for an action must be completed.

When planning a database, what do you start with? a. An Entity Relationship (ER) diagram b. A rough idea of what data will be stored. c. A Table Definition (TD) diagram d. A smile on your face and a song in your heart

a. An Entity Relationship (ER) diagram

Which is a good example of a candidate key? a. An employee ID number b. A customer's favorite movie c. An employee's birthday d. A customer's first name

a. An employee ID number

When storing the text Mozambique in a column with a data type of VARCHAR(8), what would be saved in the database? a. Mozambiq b. Mozambiqu c. MOZAMBIQUE d. Mozambique

a. Mozambiq

When might you choose to denormalize a table? a. Retrieving the data upon request would be slow or burdensome, and you are able to pre-calculate or store a copy of the data somewhere it can be retrieved faster. b. Our tables are small, and normalization is not a concern. c. There is never a benefit to denormalizing a table. d. You don't have time to follow the normalization process.

a. Retrieving the data upon request would be slow or burdensome, and you are able to pre-calculate or store a copy of the data somewhere it can be retrieved faster.

What technique would you select to discover whether a solution defect is a symptom of a deeper, underlying problem? a. Root-cause analysis b. SWOT analysis c. Force-field analysis d. Decision analysis

a. Root-cause analysis

If you don't use a number type to store numeric data, _____. a. you need to take additional steps to process the data as a number whenever you use it. b. the database will compensate and do what you intend rather than what you said. c. the precision of the number will be lost. d. you can't store numbers in any type other than a numeric.

a. you need to take additional steps to process the data as a number whenever you use it.

If you can figure out the value of one non-key field in a row by looking at another non-key field in that same row, what do you violate? a. Second Normal Form b. Third Normal Form c. the rules of the space-time continuum d. First Normal Form

b. Third Normal Form

Second Normal Form tells you to _____ in addition to being compliant with First Normal Form. a. ensure that no non-key field is dependent on another non-key field b. ensure that no non-key field is dependent on only part of a composite key c. ensure that no non-key field is dependent on the entire composite key d. remove repeating groups

b. ensure that no non-key field is dependent on only part of a composite key.

When should you begin to allocate requirements to the solution components that will implement those requirements during a project? a. When the real project requirements are derived b. When the proposed solution is being assessed c. when the solution approach is determined d. When solution design and construction starts

c. when the solution approach is determined.

What is it called if you delete a record and the database goes on and deletes other records associated with that record? a. A galloping get-out-of-here b. A recursive remove c. A progressive purge d. A cascading delete

d. A cascading delete

If you reference a key from Table A in Table B, what is that value in Table B? a. A primary key b. A composite key c. A secondary key d. A foreign key

d. A foreign key

In a database, what is a relation? a. One column of information. b. The way in which information in one table connects to the information in another table. c. Two pieces of data on one row that are connected in meaning. d. A set of attributes (columns) that describe information about specific instances (rows) of an entity.

d. A set of attributes (columns) that describe information about specific instances (rows) of an entity.

Before you create a database, what do you need to know? a. How entries in different tables will be used together b. The names and data types of fields you will use. c. What tables you'll need for your data. d. All of these answers

d. All of these answers

Requirements that are associated with the solution component that will implement them are called: a. verified requirements b. solution requirements c. traced requirements d. allocated requirements

d. allocated requirements.

To evaluate solution performance, the solution must exist in some form and be a. verified. b. approved. c. external. d. in use.

d. in use.

A unique value _____. a. occurs only once in a given table. b. occurs only once in a given row. c. almost never repeats. d. occurs only once in a given column.

d. occurs only once in a given column.

In a one-to-many relationship, the value representing the 'many' side is what? a. a primary key b. a foreign key c. a number d. a string type

b. A foreign key

When should transition requirements be defined? a. While the solution is being designed b. After the solution has been designed c. Before the solution is actually designed d. When required capabilities are defined

b. After the solution has been designed.

You are determining the most appropriate response to identified problems in a delivered solution. What task are you performing? a. Measuring solution performance b. Assessing solution limitations c. Analyzing solution performance d. Assessing the enterprise limitations

b. Assessing solution limitations

Which input best provides you with the measurable result that the enterprise wants to achieve? a. Business goal b. Business objecive c. Business requirement d. Business need

b. Business objective

To store the value 4:32PM, December 27, 2019, which data type would you use? a. DATE b. DATETIME c. VARCHAR d. CHAR

b. DATETIME

What technique ensures that issues arising from assessing enterprise limitations are addressed and resolved? a. Decision analysis b. Item tracking c. Metrics and KPIs d. Root cause analysis

b. Item tracking

Which is an example of referential integrity? a. Using an auto-incrementing column as a primary key b. Preventing the user from entering a record that refers to nonexistent data c. Double-checking that everything in the record is spelled correctly d. Checking with the administrator before deleting a table

b. Preventing the user from entering a record that refers to nonexistent data.

Which stakeholder approves the potential value of a solution? a. Business analyst b. Sponsor c. Domain SME d. Project manager

b. Sponsor

When assessing enterprise limitations using the risk analysis and management technique, what three areas of risk should be considered? a. Strategic, tactical, operational b. Technology, finance, business c. High, medium, and low impact d. Capability, condition, constraint

b. Technology, finance, business

In order to put a database into Third Normal Form, _____. a. you can skip right to Third Normal Form b. it must also be in First and Second Normal Form c. it must not be in either First or Second Normal Form d. the database must contain three tables

b. it must also be in First and Second Normal Form.

What type of requirements should address employee training, conversion of existing information, and user acceptance testing? a. Stakeholder b. Transition c. Implementation d. Functional

b. transition

Which task has solution performance measures as an input? a. Measure solution performance. b. Assess solution limitations. c. Analyze performance measures. d. Assess enterprise limitations.

c. Analyze performance meausres.

What would be a good name for a table containing customer details and contact information? a. CustomersDetailsAndContactInformation b. Customers Contact Information c. Customers d. customercontactinfo

c. Customers

What is the best recommendation to make when the value of a change from a current state is low relative to the effort required to make that change? a. Retire solution. b. Reduce complexity. c. Do nothing. d. Avoid waste.

c. Do nothing.

What is another name for a solution that exists in some way? a. Designed solution b. Constructed solution c. Implemented solution d. Allocated solution

c. Implemented solution

What is one advantage of using a spreadsheet to store data? a. It protects data from unauthorized changes. b. It ensures that the data is correct. c. It can help you see gaps in the data. d. It protects data from becoming inconsistent.

c. It can help you see gaps in the data.

What technique might assist you in measuring solution performance? a. Business cases b. Decision analysis c. Metrics and KPIs d. Vendor assessment

c. Metrics and KPIs

Solution Evaluation tasks can be performed on solutions in different stages of development. You want to evaluate a solution component that is part of a limited implementation that is not fully released. What type of solution are you working on? a. Prototype b. Operational c. Pilot d. Proof of concept

c. Pilot

In a database where you keep track of records for a school, what tables should you expect to find? a. Student, Class, and Grade b. STU001, CLA002, and GRA003 c. Students, Classes, and Grades d. Students, Class, and Grade

c. Students, Classes, and Grades

What is the best reason for involving a business analyst in Solution Evaluation tasks? a. They bring technical skills to the solution assessment process. b. They have built relationships with all key project stakeholders. c. They are most knowledgeable about the business environment. d. They work closest with the project manager and the project team.

c. They are most knowledgeable about the business environment.

When modeling a many-to-many relationship, how should you name the linking table? a. LinkingTable b. Using capital letters c. with a combination of the names of the tables it's linking. d. A linking table has no name.

c. With a combination of the names of the tables it's linking.

When you need to create a many-to-many relationship, what do you need to generate? a. One large table to contain all the data b. You can't create relationships to allow many records to be associated with many other records. c. a linking table that has a one-to-many relationship with two or more tables d. a series of one-to-one relationships between each of the items you need to associate

c. a linking table that has a one-to-many relationship with two or more tables.

A one-to-one relationship _____. a. is how you connect one table to another table. b. doesn't exist in the real world. c. allows only one record to be connected to only one other record. d. allows one record to be connected to more than one other records.

c. allows only one record to be connected to only one other record.

When talking about data types, what do you call the group of types that represent text? a. String types b. Word types c. Boolean types d. Sentence types

a. String types

What does normalization help you do? a. accomplish all of these goals b. reduce redundancy c. organize tables d. improve integrity

a. accomplish all of these goals

First Normal Form tells you to do what? a. remove repeating groups b. check that data in fields matches the data type specified for them c. ensure that no non-key field is dependent on only part of a composite key d. ensure that no non-key field is dependent on another non-key field

a. remove repeating groups.

You are making decisions about replacing or retiring a solution. One factor you consider includes the money and effort that has already been committed to this current initiative. What factor are you considering? a. Sunk cost b. Necessity c. Opportunity cost d. Ongoing cost

a. sunk cost

Defining relationships helps you to do what? a. reduce the repetition of data across tables b. model real-world scenarios and requirements c. understand how your data should be stored d. all of these answers

d. All of these answers

When you move data from an unstructured form to a structured form, what benefit do you gain? a. The ability to easily locate data. b. The ability to use data programatically. c. The ability to easily sort data. d. All of these answers.

d. All of these answers.

In the ACID model, which term represents the fact that a transaction can't be divided into smaller parts? a. Durable b. Consistent c. Isolated d. Atomic

d. Atomic

According to the BACCM, a business analyst may recommend a change either to a solution or to the _____ to realize the potential value of a solution. a. Limitations b. Requirements c. Solution d. Enterprise

d. Enterprise

In the acronym CRUD, what does the "R" stand for? a. remove b. retrieve c. revise d. read

d. Read

When you store data in a database, what is one advantage you get over a plain spreadsheet? a. You can keep information stored in a regular, organized way. b. Data can be sorted by column. c. You can insert and delete rows of data. d. Rows of data can be associated with each other across tables.

d. Rows of data can be associated with each other across tables.

The definition of how data in a database will be organized is called the: a. settings b. table c. layout d. schema

d. Schema

A relationship connects two pieces of data in different _____ in the same _____. a. fields; row b. rows; databases c. columns; table d. tables; database

d. tables; database

SQL is a. outdated and obsolete b. a database management system c. only used by professional database administrators d. the language you use to communicate with a database

d. the language you use to communicate with a database