Ab Initio Data Warehousing Question:
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database)?
Answer:
Take an entire database backup and restore it in different instance.
Take a statistics of all valid and invalid objects and match.
Periodically refresh
Take a statistics of all valid and invalid objects and match.
Periodically refresh
| Previous Question | Next Question |
| How can i run the 2 GUI merge files? | How would you find out whether a SQL query is using the indices you expect? |