Explanation:
Box 1: Yes
The azureADOnlyAuthentication (bool) property is not present.
If set to true then Azure Active Directory only Authentication enabled.
Mixed authentication will be supported.
Box 2: No
We see sku tier is Standard.
Azure SQL databases with the Standard tier do not support autoscale. Autoscale is a feature available in the Serverless compute tier of Azure SQL Database, where resources scale automatically based on workload demands. The Standard tier, part of the provisioned compute model, requires manual scaling or the use of Elastic Pools for resource sharing and scaling.
Box 3: No
The first line of the BICEP template would have to be like:
resource managedInstance 'Microsoft.Sql/managedInstances@2021-11-01-preview' = { Reference:
https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/managedinstances?pivots=deployment-language-bicep
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-bicep-quickstart