BCOR 330 EXAM 2 QUESTIONS & ANSWERS
1. When multiple lists and data integrity. sources are maintained, information can become ,
leading to decreased data.: inconsistent
2. Data integrity means the database is reliable, , and aligned
to the goals of the organization.: accurate
3. The common characteristics of big data include: volume, variety, veracity, velocity
4. Referential integrity is the and of data within a table relation-
ship in a database.: accuracy and consistency
5. A cloud database is a type of database developed on a
platform and retrieved by a cloud platform.
Multiple Choiceclouddesktop computerintegratedpaper: cloud
6. Using multiple lists and data sources can lead to a(n) in data
integrity. Multiple Choiceinconsistentdecreaseefficientincrease: decrease
7. Basic DBMS functions allow users to , read, , and dat
8. What type of field is used in both tables to create a relationship? Multiple
Choicecolumnprimaryforeigncommon: common
9. Traditional file systems use , files, and
documents. Multiple Choiceleadhard drivesfloppy diskspaper: paper
10. To set a primary key field in a database table, you must click the k
Multiple Choicedatabasesecondaryprimaryforeign: primary
11. When working in Microsoft Power BI, which three tiers are available? Check All That
ApplyPower BI ProPower BI ProPower BI ExplorerPower BI
ExplorerPower BI PremiumPower BI PremiumPower BI DesktopPower BI Desk- top: Power BI Pro, Power BI
Premium, Power BI Desktop
12. Data analysts are likely to have achieved what education level when begin- ning their career?
Multiple Choicehigh school diplomaAssociate's degreeBachelor's degreedoc- torate (Ph.D.): Bachelor's
degree
1/2
1. When multiple lists and data integrity. sources are maintained, information can become ,
leading to decreased data.: inconsistent
2. Data integrity means the database is reliable, , and aligned
to the goals of the organization.: accurate
3. The common characteristics of big data include: volume, variety, veracity, velocity
4. Referential integrity is the and of data within a table relation-
ship in a database.: accuracy and consistency
5. A cloud database is a type of database developed on a
platform and retrieved by a cloud platform.
Multiple Choiceclouddesktop computerintegratedpaper: cloud
6. Using multiple lists and data sources can lead to a(n) in data
integrity. Multiple Choiceinconsistentdecreaseefficientincrease: decrease
7. Basic DBMS functions allow users to , read, , and dat
8. What type of field is used in both tables to create a relationship? Multiple
Choicecolumnprimaryforeigncommon: common
9. Traditional file systems use , files, and
documents. Multiple Choiceleadhard drivesfloppy diskspaper: paper
10. To set a primary key field in a database table, you must click the k
Multiple Choicedatabasesecondaryprimaryforeign: primary
11. When working in Microsoft Power BI, which three tiers are available? Check All That
ApplyPower BI ProPower BI ProPower BI ExplorerPower BI
ExplorerPower BI PremiumPower BI PremiumPower BI DesktopPower BI Desk- top: Power BI Pro, Power BI
Premium, Power BI Desktop
12. Data analysts are likely to have achieved what education level when begin- ning their career?
Multiple Choicehigh school diplomaAssociate's degreeBachelor's degreedoc- torate (Ph.D.): Bachelor's
degree
1/2
