Which scenario is a typical use case for cloud-based database storage?

A small startup that needs to scale quickly without investing in physical hardware

A legacy application that only runs on a specific local server

A company with a strict no-internet policy for its internal systems

A government agency that requires all data to remain on-premises for legal reasons

A database user wants to create a query that will ask for a specific date each time it is run, and then show all orders placed on that date. Which type of query should be used?

A SELECT query with a hard-coded date

A report with no query behind it

What does scalability mean in the context of databases?

The ability to automatically back up data to the cloud

The ability to compress data to save storage space

The ability to encrypt data for security

The ability to handle increasing amounts of data and users without performance degradation

How are reports typically created from database data?

By using a report generator tool that pulls data from tables or queries

By writing a script that manually types data into a document

By exporting the entire database to a PDF file

By using a web browser to view raw database files

A retail chain with 50 stores wants all store managers to access the same up-to-date inventory database from any store location. The company does not want to maintain servers at each store. Which solution is most suitable?

A separate local database at each store

A database on the company president's laptop

A database stored on a single USB drive mailed between stores

CompTIAIT Fundamentals+ (ITF+)

Domain 5Objective 3

Database Use: Queries, Reports, Scalability, Cloud vs. Local Storage. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 6)

Part of the Data and database fundamentals domain, which accounts for 13% of the IT-FUNDAMENTALS-ITF-CERTIFICATION exam.

38questions here

8free pages

10concepts

13%of the exam

Questions 26–30

26foundation · easy
Which scenario is a typical use case for cloud-based database storage?
Select an answer first
27application · medium
A database user wants to create a query that will ask for a specific date each time it is run, and then show all orders placed on that date. Which type of query should be used?
Select an answer first
28foundation · easy
What does scalability mean in the context of databases?
Select an answer first
29foundation · easy
How are reports typically created from database data?
Select an answer first
30application · medium
A retail chain with 50 stores wants all store managers to access the same up-to-date inventory database from any store location. The company does not want to maintain servers at each store. Which solution is most suitable?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to IT-FUNDAMENTALS-ITF-CERTIFICATION

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “IT-FUNDAMENTALS-ITF-CERTIFICATION” is a trademark of its owner, used for identification only.