問題文
An app stores two kinds of objects in the consumer account: a table that records which thresholds the customer configured, and a set of stored procedures that implement the scoring logic. The provider ships a new version every few weeks. How should these be placed in the setup script?
選択肢
- The configuration table in a regular schema and the procedures in a versioned schema, so the settings survive each upgrade while the code is replaced.
- Both in a versioned schema, because the versioned schema is the mechanism that tracks what belongs to each version and that tracking is what keeps the settings intact.
- The configuration table in a versioned schema and the procedures in a regular schema, because settings are what identify a version.
- Both in a regular schema, because the setup script can drop and recreate whatever it needs and the schema type only affects which objects the consumer can list.