Google Cloud SQL - Data import/export best practices MCQ

Google Cloud SQL – 33 – Data import/export best practices MCQ

1 / 25

1. What is the recommended intermediary service for data transfer in Google Cloud SQL?

Cloud Functions

BigQuery

Google Cloud Storage

Cloud Pub/Sub

2 / 25

2. Which data format is NOT commonly used for data import/export in Google Cloud SQL?

CSV

XML

SQL dump files

Avro

3 / 25

3. Which utility is used for logical backups in MySQL on Cloud SQL?

gcloud sql export

pg_dump

mysqlimport

mysqldump

4 / 25

4. What is the equivalent utility to mysqldump for PostgreSQL on Cloud SQL?

pg_dump

mysqldump

mysqlimport

gcloud sql export

5 / 25

5. What is a common method for transferring data from Cloud SQL to Cloud Storage?

Direct database-to-database transfer

Manual file uploads

Exporting data to Cloud Storage buckets

Using the psql command

6 / 25

6. Which action should be taken to maintain database version compatibility during data import/export?

Convert all data to Avro format

Use the latest database version available

Always export in SQL dump format

Check for feature differences or incompatibilities

7 / 25

7. In cases involving large datasets, what strategy can be used to improve export/import performance?

Use the psql utility for all operations

Use only a single Cloud Storage bucket

Implement parallel export/import processes

Perform sequential exports/imports

8 / 25

8. What is the primary purpose of data validation after importing data into Cloud SQL?

Ensuring data privacy

Confirming data accuracy and integrity

Reducing storage costs

Optimizing query performance

9 / 25

9. In the context of error handling during data transfer, what is the role of a retry strategy?

To ensure data privacy

To reduce storage costs

To optimize query performance

To gracefully handle errors and recover from failures

10 / 25

10. Which security measure should be taken when transferring data between Cloud SQL and Cloud Storage?

Use unencrypted channels for faster transfer

Avoid SSL/TLS encryption to reduce latency

Implement SSL/TLS encryption for secure data transfer

Transfer sensitive data in plain text

11 / 25

11. What does “least privilege” mean in the context of access and permissions for data import/export operations?

Providing maximum access to all users

Restricting access to the fewest necessary privileges

Removing all access to the data

Granting administrative access to all users

12 / 25

12. What should you do before starting any data transfer operation in Google Cloud SQL?

Perform a database schema change

Disable audit logging

Optimize query performance

Create a backup of your database

13 / 25

13. What is the primary benefit of using Google Cloud Storage as an intermediary for data import/export?

Avoiding the need for data format conversion

Reducing data export costs

Enhancing data security and reliability

Reducing data storage costs

14 / 25

14. Which Google Cloud tool can be used to monitor the progress and performance of data import/export operations?

Google Cloud Monitoring

Google Cloud Pub/Sub

Google Cloud Vision

Google Cloud Functions

15 / 25

15. In data import/export scenarios, what is the primary role of SSL/TLS encryption?

Simplifying data format conversion

Ensuring data security during transfer

Reducing query latency

Optimizing data storage

16 / 25

16. Which practice is recommended to restrict access to Cloud Storage buckets and Cloud SQL instances used for data import/export?

Share access keys publicly

Provide wide-open access to all users

Keep all access unrestricted

Use "least privilege" principles for access

17 / 25

17. What is the primary focus of implementing a retry strategy for error handling during data transfer?

Reducing storage costs

Gracefully handling errors and recovering from failures

Ensuring data privacy

Optimizing query performance

18 / 25

18. Which of the following actions is NOT a part of best practices for data import/export in Google Cloud SQL?

Avoiding SSL/TLS encryption for faster transfer

Validating data accuracy after transfer

Using a compatible data format

Monitoring the progress of data transfer

19 / 25

19. Which Google Cloud service is commonly used for data analysis after data is exported from Cloud SQL?

Google Cloud Pub/Sub

Google Cloud Functions

Google Cloud Storage

Google BigQuery

20 / 25

20. Why is it essential to perform data validation after importing data into Cloud SQL?

To confirm data accuracy and integrity

To reduce storage costs

To ensure data privacy

To optimize query performance

21 / 25

21. In a scenario involving the export of a large dataset from Cloud SQL to Cloud Storage, what can be done to improve performance?

Use a single Cloud Storage bucket

Implement parallel export processes

Perform sequential exports

Avoid exporting large datasets

22 / 25

22. What is the recommended security measure when transferring data between Cloud SQL and Cloud Storage?

Use unencrypted channels for simplicity

Avoid SSL/TLS encryption for faster transfer

Transfer sensitive data in plain text

Implement SSL/TLS encryption for secure transfer

23 / 25

23. What does the principle of “least privilege” mean in the context of access control for data import/export?

Providing maximum access to all users

Restricting access to the fewest necessary privileges

Granting administrative access to all users

Removing all access to the data

24 / 25

24. Which action is advised before initiating any data transfer operation in Google Cloud SQL?

Create a backup of your database

Disable audit logging

Optimize query performance

Perform a database schema change

25 / 25

25. What is the primary advantage of using Google Cloud Storage as an intermediary for data import/export?

Avoiding the need for data format conversion

Enhancing data security and reliability

Reducing data export costs

Reducing data storage costs

Your score is

Google Cloud SQL – Data import/export best practices MCQ