Google Professional Data Engineer

Google Professional Data Engineer

Get started today

Ultimate access to all questions.


Your company experiences heavy load on its MySQL cluster databases that store customer and order information. This high load complicates performing analytics directly on the live databases, as it could disrupt normal operations. Currently, you take nightly backups of these databases using mysqldump. You need to find a way to conduct analytics without adversely affecting the operational performance of your databases. What approach should you take?