Which change reduces memory usage by adjusting how DateTime data is stored?

Which change reduces memory usage by adjusting how DateTime data is stored?

• A. Split DateTime into separate date and time columns
• B. Replace TotalQuantity with a calculated column
• C. Convert Quantity to the Text data type
• D. Replace TotalSalesAmount with a measure

Answer: (A)

Splitting DateTime into separate date and time columns reduces memory usage because it lets you store each component with a more compact data type. A single DateTime value often occupies more bytes than the sum of two smaller fields (a Date and a Time). When most operations only need the date portion, you avoid carrying the extra time information, and when both are needed, the combined storage of two smaller fields can be comparable to or smaller than one larger DateTime. This approach also can improve caching and query efficiency by reducing the amount of data moved in results or intermediate storage. Other options focus on derived values or different data representations for the same field, which doesn’t directly address how DateTime is stored in the table. Replacing a numeric field with a calculated column, converting quantity to text, or using a measure affects storage or computation in different ways, but they don’t specifically reduce the memory footprint of a DateTime value.

Splitting DateTime into separate date and time columns reduces memory usage because it lets you store each component with a more compact data type. A single DateTime value often occupies more bytes than the sum of two smaller fields (a Date and a Time). When most operations only need the date portion, you avoid carrying the extra time information, and when both are needed, the combined storage of two smaller fields can be comparable to or smaller than one larger DateTime. This approach also can improve caching and query efficiency by reducing the amount of data moved in results or intermediate storage.

Other options focus on derived values or different data representations for the same field, which doesn’t directly address how DateTime is stored in the table. Replacing a numeric field with a calculated column, converting quantity to text, or using a measure affects storage or computation in different ways, but they don’t specifically reduce the memory footprint of a DateTime value.