@Rifka Khairani Thank you for reaching out.
My understanding is that you have 2 azure SQL Databases created on the same logical server with general purpose service tier. Running the Invoke-AzSqlDatabaseFailover PowerShell command on an Azure SQL database returned success on both Databases with zone redundant enabled and disabled (with locally redundant).
The command Invoke-AzSqlDatabaseFailover induces fault for SQL database and helps us to witness resiliency in action. If executed against a non-zone redundant database, the database would be brought online from any datacenter within a region. If executed on a zone redundant database, the database would be brought online from a different zone than the current one.
Regarding your second question, after manually executing failover on an Azure SQL database with zone redundancy enabled. You cannot see zone number or region for a zone redundant database. It is something that is automatically taken care. We do plan to expose the info in future, but we don't have any ETA yet.
Hope that clarifies your ask.
Regards,
Oury