ExamGecko
Question list
Search
Search

Question 280 - TDS-C01 discussion

Report
Export

What are two benefits of using a live connection to a data source as compared to an extract? Choose two.

A.
Alive connection to a database server requires less network overhead than an extract.
Answers
A.
Alive connection to a database server requires less network overhead than an extract.
B.
A workbook connected to a live connection will have fresher data than a workbook connected to an extract.
Answers
B.
A workbook connected to a live connection will have fresher data than a workbook connected to an extract.
C.
A live connection reduces the amount of memory used on a client computer as compared to an extract.
Answers
C.
A live connection reduces the amount of memory used on a client computer as compared to an extract.
D.
A live connection is always faster than an extract.
Answers
D.
A live connection is always faster than an extract.
Suggested answer: B, C

Explanation:

The benefits of using a live connection over an extract include:

B: A live connection ensures that the data in the workbook is as up-to-date as the database itself, providing fresher data compared to a static extract which is updated at intervals.

C: A live connection queries the database server directly, which means it uses the server's memory and processing power rather than relying on the client computer's resources.

A live connection does not necessarily require less network overhead (A) as it may continually send queries over the network, and it is not always faster than an extract (D) because extracts can provide quicker response times for complex queries or large datasets.

asked 23/09/2024
Allen J Tyson
30 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first