Data Warehouse Storage Infrastructure and Data Flow

Covers data warehouse storage technologies including SAN, NAS, VTL, and data refresh processes (CFD, DWH)

20 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

What is Replication ?

  1. Writing data on primary and secondary at the same time.
  2. Writing data on primary, then copying to secondary storage
  3. Mirroring data from primary to secondary
  4. None of the above
Question 2 Multiple Choice (Single Answer)

What is a snapshot ?

  1. Copy of Data
  2. Point in time read-only copy of Data
  3. Backup of data
  4. None of the above
Question 3 True/False

Snapshot's include meta-data and Data block

  1. True
  2. False
Question 4 Multiple Choice (Single Answer)

What is “Shoe Shining”

  1. Rewinding the Tape
  2. Stop the tape and re-wind to beginning
  3. rewind to a seek position
  4. Stop, rewind and seek where last streaming end
Question 5 True/False

SANs often utilise a Fibre Channel topology

  1. True
  2. False
Question 6 Multiple Choice (Multiple Answers)

SAN LUN's functionality are

  1. Logical drives
  2. Can be shared between several servers
  3. Soft partitions
  4. Hard partitions
Question 7 Multiple Choice (Single Answer)

A network storage system allows computers to share large volumes of data across high-speed LAN connections?

  1. SAN and NAS
  2. SAN
  3. NAS
  4. TSM
Question 8 Multiple Choice (Multiple Answers)

The following protocols used by NAS (network attached storage)

  1. SCSI
  2. TCP/IP
  3. NFS
  4. HTTP
Question 9 True/False

A virtual tape library (VTL) is a data storage virtualization technology used typically for backup and recovery purposes?

  1. True
  2. False
Question 10 Multiple Choice (Single Answer)

Host Bus Adapter (HBA) is frequently used for?

  1. SAS adapters
  2. iSCSI adapters
  3. Fibre Channel interface cards
  4. Standard ethernet adapters
Question 11 Multiple Choice (Multiple Answers)

Major manufacturers of Fibre Channel switches are?

  1. Cisco
  2. Brocade
  3. DLink
  4. QLogic
Question 12 True/False

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.

  1. True
  2. False
Question 13 Multiple Choice (Multiple Answers)

CFD database hold data for

  1. Current DWH date
  2. Thursdays
  3. Last working day of the month
  4. Month end
Question 14 Multiple Choice (Single Answer)

Secure web and External web primarily source data from

  1. DWH
  2. Core System
  3. CFD
  4. RRS
Question 15 Multiple Choice (Single Answer)

CFD refresh happens

  1. Daily
  2. Weekly
  3. Monthly
  4. None of the above
Question 16 Multiple Choice (Single Answer)

iFIN DWH is refreshed with

  1. Two Half day loads
  2. Daily load
  3. Week end Load
  4. Monthly load
Question 17 Multiple Choice (Multiple Answers)

CFD database hold data for

  1. Current DWH date
  2. Thursdays
  3. Last working day of the month
  4. Month end
Question 18 Multiple Choice (Single Answer)

Secure web and External web primarily source data from

  1. DWH
  2. Core System
  3. CFD
  4. RRS
Question 19 Multiple Choice (Single Answer)

CFD refresh happens

  1. Daily
  2. Weekly
  3. Monthly
  4. None of the above