Where is the data stored for a table that is defined as using the FEDERATED Storage Engine?

Question

Options

• AThe data will always be stored on the local host.
• BThe data will always be stored on a remote host.
• CThe data can be stored on any host depending on the definition of the table.
• DThe data will always be stored on disk.
• EThe data will always be stored in memory.
• FThe data will be stored according to the storage engine of the referenced table.

• A
  17% (6)
• B
  3% (1)
• C
  71% (25)
• D
  6% (2)
• E
  3% (1)

Explanation

"Remote" in the preceding discussion actually is not quite accurate: FEDERATED tables can be defined for accessing tables from other servers running on the same host, or even other tables from the same server.

No community discussion yet for this question.