Alibaba Exam ACA-Sec1 Topic 8 Question 83 Discussion

Actual exam question for Alibaba's ACA-Sec1 exam

Question #: 83
Topic #: 8

[All ACA-Sec1 Questions]

Which of the following statements about the supported way of MySQL DB for backup are

true?(the number of correct answers: 2)

Ayou can use 'mysqldump' do logical backup

Byou can copy files directly to do physical backup

Cyou can use 'binlog' to do real time backup

Dyou must stop accessing to DB before you do logical backup

Show Suggested Answer

Suggested Answer: B

by Kirk at Mar 16, 2024, 03:16 PM

Limited Time Offer

25%

Off

Get Premium ACA-Sec1 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rozella

1 months ago

Logging binary data in real-time? Is this a MySQL backup or a spy movie?

upvoted 0 times

Nelida

4 days ago

A) you can use 'mysqldump' do logical backup

upvoted 0 times

...

Alana

1 months ago

Wait, can we really do a physical backup by just copying files? That's kind of genius if it works.

upvoted 0 times

...

Lennie

2 months ago

I'm pretty sure we need to stop the DB for a logical backup. Option D sounds right to me.

upvoted 0 times

Viola

11 days ago

Logical backup requires stopping access to the DB, so option D is correct.

upvoted 0 times

...

Adell

20 days ago

Yes, option D states that you must stop accessing the DB before doing a logical backup.

upvoted 0 times

...

Rosalyn

30 days ago

I agree, we need to stop accessing the DB for a logical backup.

upvoted 0 times

...

Diane

2 months ago

Hmm, I thought we had to stop the DB to do a physical backup. This is getting confusing.

upvoted 0 times

Eileen

24 days ago

C) you can use 'binlog' to do real time backup

upvoted 0 times

...

Levi

1 months ago

B) you can copy files directly to do physical backup

upvoted 0 times

...

Asuncion

1 months ago

A) you can use 'mysqldump' do logical backup

upvoted 0 times

...

Reita

2 months ago

Options A and B seem legit, but 'binlog' for real-time backup? That's news to me.

upvoted 0 times

Cordelia

10 days ago

User4: A) you can use 'mysqldump' do logical backup

upvoted 0 times

...

Tiara

11 days ago

User3: C) you can use 'binlog' to do real time backup

upvoted 0 times

...

Kallie

20 days ago

User2: B) you can copy files directly to do physical backup

upvoted 0 times

...

Alonzo

2 months ago

User1: A) you can use 'mysqldump' do logical backup

upvoted 0 times

...

Dyan

2 months ago

I'm not sure about D, do we really need to stop accessing the DB for logical backup?

upvoted 0 times

...

Oretha

2 months ago

I agree with Velda, 'mysqldump' and 'binlog' are commonly used for backup.

upvoted 0 times

...

Velda

2 months ago

I think A and C are correct.

upvoted 0 times

...