Data Warehouse Design Processing
Which of the following data models comprises a set of rules according to which databases can be constructed?
Which of the following physical design structures comprises one or more data files, which are physical structures with the operating system one is using?
__________________ is the process of modelling and formalising data requirements in an intrinsic part of the database design process.
Which physical design structure is used to enforce business rules associated with one's database and to prevent having invalid information in the table?
Which of the following applications of RAID technology takes data that needs to be stored, and distributes it evenly between two or more hard drives?
Which of the following refers to delibrate splitting of a table and its index data into manageable parts?
____________________ should be used with highly redundant data, such as tables with many foreign keys. It can also speed up query execution.
_____________ is the idea of breaking down a task so that, instead of one process doing all the work in a query, many processes do part of the work at the same time.
Which of the following tasks in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons; one to standardise among data extractions from disparate source systems, and the other to make the fields usable and understandable to the users?
___________ are most commonly used in a data warehouse to index unique or near-unique keys.
_________________ allows data to be modelled and viewed in multiple dimensions.
Which of the following is referred to as the state of completeness, validity, consistency, timeliness and accuracy that makes data appropriate for a specific use?
Which of the following is widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions?
_______________ task is the rearrangement and simplification of individual fields to make them more useful for the data warehouse environment.
__________ is the operation of extracting data from a source system for further use in a data warehouse environment.