To identify long-running queries in an Azure SQL Database using Extended Events, the primary event to use is sql_statement_completed.
Reference:
https://richardswinbank.net/admin/identify_long-running_queries

We reduce the max length of the column from 400 to 200.
Incorrect:
Not A: Sparse column is useful when there are many null columns.
The SQL Server Database Engine uses the SPARSE keyword in a column definition to optimize the storage of values in that column. Therefore, when the column value is NULL for any row in the table, the values require no storage.
Not B, Not C: SQL Server 2005 got around the limitation of 8KB storage size and provided a workaround with varchar(max). It is a non-Unicode large variable- length character data type and can store a maximum of 2^31-1 bytes (2 GB) of non-Unicode characters.
Reference:
https://www.sqlshack.com/sql-varchar-data-type-deep-dive/
https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-patching?view=azuresql Choose only one option to automatically update your VM as overlapping tools may lead to failed updates.

vCore purchasing model - Azure SQL Database
Select hardware configuration
You can select hardware configuration for a database or elastic pool in SQL Database at the time of creation. You can also change hardware configuration of an existing database or elastic pool.
To select a hardware configuration when creating a SQL Database or pool Step 1: Start Azure portal Step 2: Go the Azure SQL page, select db1.
Step 3: On the Overview page, select the Pricing tier link:

Step 4: Select the Change configuration link:

Step 5: Select the desired hardware configuration:
Specify:
Max vCores: 4
Max storage: 45 GB

Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore