Data Warehouse Storage Infrastructure and Data Flow
Covers data warehouse storage technologies including SAN, NAS, VTL, and data refresh processes (CFD, DWH)
Questions
What is Replication ?
- Writing data on primary and secondary at the same time.
- Writing data on primary, then copying to secondary storage
- Mirroring data from primary to secondary
- None of the above
What is a snapshot ?
- Copy of Data
- Point in time read-only copy of Data
- Backup of data
- None of the above
Snapshot's include meta-data and Data block
- True
- False
What is “Shoe Shining”
- Rewinding the Tape
- Stop the tape and re-wind to beginning
- rewind to a seek position
- Stop, rewind and seek where last streaming end
SANs often utilise a Fibre Channel topology
- True
- False
SAN LUN's functionality are
- Logical drives
- Can be shared between several servers
- Soft partitions
- Hard partitions
A network storage system allows computers to share large volumes of data across high-speed LAN connections?
- SAN and NAS
- SAN
- NAS
- TSM
The following protocols used by NAS (network attached storage)
- SCSI
- TCP/IP
- NFS
- HTTP
A virtual tape library (VTL) is a data storage virtualization technology used typically for backup and recovery purposes?
- True
- False
Host Bus Adapter (HBA) is frequently used for?
- SAS adapters
- iSCSI adapters
- Fibre Channel interface cards
- Standard ethernet adapters
Major manufacturers of Fibre Channel switches are?
- Cisco
- Brocade
- DLink
- QLogic
In the event one of the disks in the SAN is faulty, depending on the RAID technology practiced, the SAN is able to rebuild data from the faulty disk onto a spare disk.
- True
- False
CFD database hold data for
- Current DWH date
- Thursdays
- Last working day of the month
- Month end
Secure web and External web primarily source data from
- DWH
- Core System
- CFD
- RRS
CFD refresh happens
- Daily
- Weekly
- Monthly
- None of the above
iFIN DWH is refreshed with
- Two Half day loads
- Daily load
- Week end Load
- Monthly load
CFD database hold data for
- Current DWH date
- Thursdays
- Last working day of the month
- Month end
Secure web and External web primarily source data from
- DWH
- Core System
- CFD
- RRS
CFD refresh happens
- Daily
- Weekly
- Monthly
- None of the above