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

Snapshot's include meta-data and Data block

  1. True

  2. False


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

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


Correct Option: A

AI Explanation

To answer this question, you need to understand the concepts of SAN (Storage Area Network) and NAS (Network Attached Storage).

Option A) SAN and NAS - This option is correct because both SAN and NAS are network storage systems that allow computers to share large volumes of data across high-speed LAN connections.

Option B) SAN - This option is incorrect because SAN alone does not provide the capability to share data across LAN connections. SAN is a dedicated network that connects storage devices to servers and provides block-level access to data.

Option C) NAS - This option is incorrect because NAS alone does not provide the capability to share data across LAN connections. NAS is a file-level storage system that connects to a LAN and allows multiple devices to access shared files.

Option D) TSM - This option is incorrect as TSM (Tivoli Storage Manager) is a data protection and backup software, not a network storage system.

The correct answer is A) SAN and NAS. This option is correct because both SAN and NAS provide the capability to share large volumes of data across high-speed LAN connections.

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

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
  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

CFD refresh happens

  1. Daily

  2. Weekly

  3. Monthly

  4. None of the above


Correct Option: A
- Hide questions