Four fundamental properties introduced in TFDDataSet (thus, available in every one of its subclasses) are FetchOptions, FormatOptions, ResourceOptions, and UpdateOptions.
These property sets model the majority of FireDAC behaviors and their values are used to fine-tune how each component instance actually works. A nice thing to note is that the options system of FireDAC is multi-level with fallback definition, meaning that in a real use case you probably have a dataset (that is, TFDQuery) that is making use of a connection (TFDConnection) that has been created from a definition by the FireDAC manager (TFDManager).
Each of these three elements can specify options and there is a fall-back mechanism that will enable you to define the default behavior once per application (setting the option sets of TFDManager) and then eventually override each option item at the connection and dataset levels.
Let's have a closer look at some of these properties...
