You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()A.The snapshot size will continue to grow as changes to t

题目
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?()

A.The snapshot size will continue to grow as changes to the volume are made

B.The snapshots take a significant amount of disk space as they are a duplicate copy of the data

C.The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup

D.The system keeps a copy of changes in memory and can cause an out of memory event

相似考题

1.YoudiscoverthatthemsdbdatabaseonaSQLServer2005computeriscorruptandmustberestored.Databasesarebackedupdaily.Thedatabasebackupfilesarewrittentoanetworkshare，butthefilenamesdonotclearlyindicatewhichdatabasesareineachfile.Youneedtolocatethecorrectbackupfileasquicklyaspossible.ThefirstfileinthelistisnamedDBBackup.bak.WhichTransact-SQLstatementshouldyouuse？（）A.RESTORELABELONLYFROMDISK=N\\Server1\Backup\DBBackup.bakB.RESTOREHEADERONLYFROMDISK=N\\Server1\Backup\DBBackup.bakC.RESTOREVERIFYONLYFROMDISK=N\\Server1\Backup\DBBackup.bakD.RESTOREDATABASEMSDBFROMDISK=N\\Server1\Backup\DBBackup.bak

2.Youbackedupthedatabaseat8a.m.todayusinganonlinebackup.Accountingmadealargechangetotheunderlyingdatabetween10a.m.andnoon.Whichofthefollowingactionswouldensurethatthechangescouldberecoveredusingthe8a.m.backup？（）A.Createamanualincrementalonlinedatabasebackup.B.Backupallthearchivedredologsgeneratedsincethe8a.m.backup.C.Createabrand-newbackupafterallthechangeshavebeenapplied.D.Thereisnowaytomakethechangesrecoverablebasedonthe8a.m.backup.E.Performanonlinebackupofthetablespace（s）thatcontainedchangeddata.

3.Youperformdifferentialincrementallevel1backupsofyourdatabaseoneachworkingdayandlevel0backuponSundays,totape.Whichtwostatementsaretrueaboutdifferentialincrementalbackups()A.ThebackupperformedonSundayscontainsalltheblocksthathaveeverbeenusedinthedatabase.B.ThebackupperformedonSundayscontainsalltheblocksthathavechangedsincethelastlevel1backup.C.Thebackupperformedoneachworkingdaycontainsalltheblocksthathavechangedsincethelastlevel0 backup.D.ThebackupperformedonMondaycontainsalltheblocksthathavechangedsincethelevel0backup，and everyotherworkingdaycontainsalltheblocksthathavechangedsincethelevel1backup

4.Whichviewprovidesinformationonthebackupstatusofthedatafilesinthedatabase?()A.V$BACKUPB.V$BACKUP_STATUSC.V$BACKUP_DATAFILED.V$DATAFILE_BACKUPE.V$TABLESPCE_BACKUP

更多“You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?() ”相关问题

  • 第1题：

    WherecanyouobtaininformationaboutfulldatabasebackupsetcreatedusingRMAN,ifthecontrolfilewasusedastherepository?()

    A.V$BACKUPSET

    B.RC_DATABASE

    C.V$BACKUP_SET

    D.RC_BACKUP_SET


    参考答案：C

  • 第2题：

    Whileusingthesmitinstall_removemenustoremovesomefilesetsonanAIX5.3server，asystemadministratornoticesthe/usrfilesystemisnowunnecessarilylarge.Whichofthefollowingactionswillreducethesizeofthe/usrfilesystem（）

    A.Backup，unmount，remove，recreateandrestorethefilesystem.

    B.BootfrommksysbtapeandselectShrinkfilesystemsonrestore.

    C.Unmount，rundefragfs/usrandthereducefs-sizen/usrcommands.

    D.Updatethe/image.datafilewiththedesiredsizefor/usrandrebootthesystem.


    参考答案：B

  • 第3题：

    【单选题】实现MYSQL导入数据的命令是（）

    A．MYSQLDUMP

    B．MYSQLIMPORT

    C．RETURN

    D．BACKUP


    mysql

  • 第4题：

    An administrator wants to restore the /etc/resolv.conf file from a mksysb backup onto server1. After the mksysb is mounted in /mnt/backup/ from the local nim server.Which command should be run to restore the file?（）

    A.tar -xvf /mnt/backup/server1.mksysb ./etc/resolv.conf

    B.restore -Tvf /mnt/backup/server1.mksysb ./etc/resolv.conf

    C.listvgbackup -f /mnt/backup/server1.mksysb -r ./etc/resolv.conf

    D.restorevgfiles -xrm /mnt/backup/server1.mksysb ./etc/resolv.conf


    参考答案：C

  • 第5题：

    Examinethissyntaxwhichallocateschannelsduringaparallelimagecopy：RMAN>CONFIGUREDEVICETYPEdiskparallelism4：2>COPY3>datafile1TO‘/BACKUP/datafile1.dbf’，4>datafile2TO‘/BACKUP/datafile2.dbf’，5>datafile3TO‘/BACKUP/datafile3.dbf；RMAN>COPY2>datafile4TO‘/BACKUP/datafile4.dbf’；Howmanychannelsareused？（）

    A.0

    B.1

    C.3

    D.4


    参考答案：D

  • 第6题：

    【单选题】备份MySQL数据库的命令是（）

    A．mysqldump

    B．mysql

    C．copy

    D．backup


    mysqldump -u root -p --opt mysql>/mysqlbak.sql

相关内容