Module 13 Flashcards
In a veterinarian’s database, data about an individual pet is stored as a separate _____________.
A.
field
B.
table
C.
record
D.
column
C. record
Reasoning: In databases, a record represents a single entry that holds data about a specific item, such as an individual pet. Each pet’s information would be stored as a unique record within a table
Which data type would be best for a username field?
A.
Long text
B.
Short text
C.
AutoNumber
D.
Hyperlink
B. Short text
Reasoning: Usernames are typically short text fields since they involve characters and have a limited length, making “Short text” the best choice
Aimee works for a martial arts studio. Which of the following tables will give her contact information for the mother of a student who requested more information about a new class being offered?
A.
Locations
B.
Instructors
C.
Students
D.
Classes
C. Students
Reasoning: A “Students” table would likely contain information on students and their guardians, including contact details needed by Aimee
Which SQL statement would show the type of pet most preferred by retirees?
A.
SELECT Species
FROM TblPets
WHERE OwnerAge >64
B.
SELECT OwnerAge
FROM TblOwner
WHERE OwnerAge >64
C.
INSERT INTO TblPets (Owner, Species)
VALUES (‘Retired’, ‘Pet’)
D.
SELECT Species
FROM TblOwners
WHERE Pet=’Yes’
A. SELECT Species FROM TblPets WHERE OwnerAge >64
Reasoning: This query selects the species of pets owned by people over 64, targeting retirees’ preferences based on age
Nadine can check her _____________ for updated, at-a-glance information on current stock prices.
A.
data warehouse
B.
data lake
C.
dashboard
D.
relational database
C. dashboard
Reasoning: A dashboard is designed to provide at-a-glance updates and visual insights on data, such as stock prices
Which aspect of the CIA triad requires that passwords in a database be encrypted?
A.
Availability
B.
Scalability
C.
Integrity
D.
Confidentiality
D. Confidentiality
Reasoning: The confidentiality aspect of the CIA triad focuses on protecting data privacy, which requires encrypting sensitive information like passwords
What’s the most important reason that Big Data is often managed in a cloud environment?
A.
Value
B.
Veracity
C.
Volume
D.
Variety
C. Volume
Reasoning: Cloud environments are capable of handling the large volumes associated with Big Data, which is a primary reason for using cloud solutions
Chantelle wants to change the color scheme for her company’s web app, and she needs to get the logos updated. What kind of developer should she talk to?
A.
Back-end
B.
Front-end
C.
DBA
B. DBA
D.
Mobile
B. Front-end
Reasoning: Front-end developers are responsible for the visual aspects of a web application, including design elements like color schemes and logos
Which database object is best suited to print and hand out during a presentation to a board of advisors?
A.
Query
B.
Report
C.
Form
D.
Table
B. Report
Reasoning: A report is formatted for easy reading and presentation, making it suitable for distribution in meetings
Mpho’s small start-up company can’t afford its own servers, but they need a robust database for their new web app. Which of the following is the best fit for Mpho’s needs?
A.
Microsoft SQL Server
B.
Google Docs
C.
Amazon Aurora
D.
Microsoft Excel
C. Amazon Aurora
Reasoning: Amazon Aurora is a managed cloud database service, providing robustness and scalability for startups without requiring in-house servers
A database for a website where thousands of users will post their own photos needs to be highly ________________ to handle the quickly increasing number of files.
A.
distributed
B.
scalable
C.
consistent
D.
available
B. Allow any user to delete tables
Reasoning: Allowing unrestricted deletion of tables poses significant security risks and threatens data integrity within a database
