Which two are true regarding MySQL binary and text backups?
A.
Binary backups are usually faster than text backups.
B.
Binary backups are usually slower than text backups.
C.
Text backups are human-readable while binary backups are not.
D.
Binary backups are not portable across different operating systems.
Explanation:
C should be obvious
D – “Backups are portable only to other machines that have identical or similar hardware characteristics”
Ref: http://dev.mysql.com/doc/refman/5.6/en/backup-types.html
AC
for A not B:
– Physical backup methods are faster than logical because they involve only file copying without conversion.
– Backup (logical) is slower than physical methods because the server must access database information and convert it to logical format. If the output is written on the client side, the server must also send it to the backup program.
not C 114%
not D you can restore data from win2000 to win2003 😉
Not true , D is correct. Pls try restore binary backup from Solaris on Linux or Windows. Good luck. Windows 2000 and 2003 are moreover the same system low endian windows based but one is little newer, according to such comparison ubuntu 12.02 is completely different OS than ubuntu 14.02. Different operating system is Linux and Windows.
Supported systems http://www.mysql.com/support/supportedplatforms/database.html
“Physical backup not always is faste. Imagine table file having more than 27 GB ,but recently almost all of data was deleted with delete command, file still have 27 GB of size but data inside are 1MB, gues what logical backup will be faster , surprised ?
But the question says “USUALLY binary backups are faster”, not “ALWAYS binary backup are faster”
I have no experience restoring binary backups between Linux and Windows, but I know for sure, becouse I did it, the binary backups are portable between Linux on x86_64 and Linux on the Mainframe, wich use a different endian type.
This does not work on Oracle database binary backups.
*mysql* binary backups are portable between windows and linux.
I usually do it.
A and C
what the answer for this? AC or CD?
A, C.
hi,,
i just sit for this exam and failed.
i want to retake the exam but my voucher cannot be used with appointments scheduled after 30 Nov 2014.
i try to re-sit before 30 Nov 2014, but the retake policy state that candidates must wait 14 days before retaking a failed exam.
i have 2 voucher for this exam that expired on 30 Nov 2014.anyone here want to exchange the voucher with me?? pleaseee….
how i wish i found this page earlier…huhu…
Hi,
This exam has all these questions? The same thing?
C,D.
C for sure.
I’m not sure if A or D
A, C
https://dev.mysql.com/doc/refman/5.6/en/backup-types.html
just for info…
Today I passed this exam.
# of question is 100 and you need at least 65 correct answers
my score is 70 and I marked that only 53 questions are same and the rest are new.
I think it is A,C
A, C
AC