0

Data warehouse Storage tools Quiz - 1

Description: Data warehouse Storage tools Quiz - 1
Number of Questions: 20
Created by:
Tags: storage
Attempted 0/19 Correct 0 Score 0

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


Correct Option: B

AI Explanation

To answer this question, we need to understand the concept of replication.

Replication is the process of creating and maintaining multiple copies of data in different locations. It is commonly used in database management systems to ensure data availability, fault tolerance, and disaster recovery.

Let's go through each option to understand why it is correct or incorrect:

Option A) Writing data on primary and secondary at the same time - This option is incorrect. Replication involves copying or synchronizing data from one location to another, it does not write data on both primary and secondary simultaneously.

Option B) Writing data on primary, then copying to secondary storage - This option is correct. Replication typically involves writing data on the primary storage and then copying or synchronizing that data to secondary storage. This ensures that the secondary storage contains an up-to-date copy of the data.

Option C) Mirroring data from primary to secondary - This option is similar to Option B and is also correct. Mirroring is a form of replication where the data is copied or mirrored from the primary storage to the secondary storage.

Option D) None of the above - This option is incorrect, as Option B and Option C both correctly describe the process of replication.

The correct answer is B) Writing data on primary, then copying to secondary storage. This option accurately describes the process of replication, where data is first written on the primary storage and then copied or synchronized to the secondary storage.

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


Correct Option: B

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


Correct Option: D

SANs often utilise a Fibre Channel topology

  1. True

  2. False


Correct Option: A

SAN LUN's functionality are

  1. Logical drives

  2. Can be shared between several servers

  3. Soft partitions

  4. Hard partitions


Correct Option: A,B,C

The following protocols used by NAS (network attached storage)

  1. SCSI

  2. TCP/IP

  3. NFS

  4. HTTP


Correct Option: B,C,D

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

  1. True

  2. False


Correct Option: A

Host Bus Adapter (HBA) is frequently used for?

  1. SAS adapters

  2. iSCSI adapters

  3. Fibre Channel interface cards

  4. Standard ethernet adapters


Correct Option: C

Major manufacturers of Fibre Channel switches are?

  1. Cisco

  2. Brocade

  3. DLink

  4. QLogic


Correct Option: A,B,D

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


Correct Option: A

CFD database hold data for

  1. Current DWH date

  2. Thursdays

  3. Last working day of the month

  4. Month end


Correct Option: A,D

Secure web and External web primarily source data from

  1. DWH

  2. Core System

  3. CFD

  4. RRS


Correct Option: C

CFD refresh happens

  1. Daily

  2. Weekly

  3. Monthly

  4. None of the above


Correct Option: A
  1. Two Half day loads

  2. Daily load

  3. Week end Load

  4. Monthly load


Correct Option: B

CFD database hold data for

  1. Current DWH date

  2. Thursdays

  3. Last working day of the month

  4. Month end


Correct Option: A,D

Secure web and External web primarily source data from

  1. DWH

  2. Core System

  3. CFD

  4. RRS


Correct Option: C

CFD refresh happens

  1. Daily

  2. Weekly

  3. Monthly

  4. None of the above


Correct Option: A
- Hide questions