1D0-441 · Question #119
Which of the following best describes the two-tier database architecture?
The correct answer is D. The user interface and data-processing logic are performed by the client whereas the server. See the full explanation below for the reasoning.
Question
Options
- AThe user accesses a database server using a terminal.
- BThe user interface, data-processing logic, database access and data validation functions are
- CThe user interface and data validation functions are performed by the client whereas the data-
- DThe user interface and data-processing logic are performed by the client whereas the server
How the community answered
(28 responses)- A7% (2)
- B18% (5)
- C4% (1)
- D71% (20)
Community Discussion
9The answer is D, and here is why that matters for your blueprint. Two-tier architecture splits the workload between exactly two layers, and the defining characteristic is that the client carries both the user interface AND the data-processing logic, while the server handles database storage and retrieval. A good mnemonic is "Fat Client, Thin Server," because all the heavy lifting of processing happens on the client side before a query even touches the server. Option C trips up a lot of candidates because it sounds close, but pushing only validation to the client while leaving processing on the server describes a different split that does not match the classic two-tier model. Keep this straight by contrast with three-tier, where processing logic moves off the client and onto its own dedicated middle tier, which is a common blueprint follow-up on this topic.
The fat-client framing is solid, though it helps to also spin up a two-tier app in something like a local SQL Server sandbox so you can watch the client code handle all the business logic directly against the DB, because that hands-on picture makes the contrast with three-tier click a lot faster than any mnemonic.
Grabbed C first, but D owns the processing logic, not just UI.
D is the right pull once you notice the stem says "handles" rather than "displays," because that verb alone eliminates all the UI-only choices before you even read the options.
In two-tier, the client handles UI and logic, right, so what stays on the server?
Client holds UI and sometimes presentation logic, but business logic and data live on the server, which is the whole point of the tier split.
Almost picked C, then remembered two-tier puts processing on the client.
Fat client is the mnemonic that seals it for two-tier, and knowing that fat client equals poor scalability is what makes three-tier the go-to when any exam stem mentions distributing load or centralizing business logic updates.
Good one to pause on, because the trap here is confusing where the logic lives in two-tier versus three-tier. If you can name which layer owns the data-processing logic in a two-tier setup, you will lock in the right answer every time.