Local Backup will be created on your Device Internal Memory/SD Card. Google Drive backup is taken on your free Google drive space.
Local backup is taken at 3 AM daily. If the app is not launched at 3 AM, backup is taken at next app launch (foreground or background). Google drive backup is taken post the local backup that day, according to the user settings.