[Az-CLI Test] SQL module test failure due to unavailability of test resources #32004
Description
Describe the bug
A SQL module test SqlServerDbMgmtScenarioTest::test_sql_per_db_cmk require some pre-existing resources for this test to run. These hard-coded resources in the test are dropped and doesn't exist anymore due to which this test is failing always in record mode, and have started failing in pipeline runs also with new API update.
Related command
azdev test SqlServerDbMgmtScenarioTest --live --lf --no-exitfirst
Errors
FAILED src\azure-cli\azure\cli\command_modules\sql\tests\latest\test_sql_commands.py::SqlServerDbMgmtScenarioTest::test_sql_per_db_cmk - azure.core.exceptions.ResourceNotFoundError: (ResourceGroupNotFound) Resource group 'pstest' could not be found.
Issue script & Debug output
NA
Expected behavior
Expected behavior is the test should execute in record mode or in pipeline runs (with playback mode)
Environment Summary
(env) E:\azure-cli>az --version
azure-cli 2.76.0
core 2.76.0
telemetry 1.1.0
Dependencies:
msal 1.34.0b1
azure-mgmt-resource 23.3.0
Python location 'E:\azure-cli\env\Scripts\python.exe'
Config directory 'C:\Users\mohitagarwal.azure'
Extensions directory 'C:\Users\mohitagarwal.azure\cliextensions'
Development extension sources:
E:\azure-cli-extensions
Python (Windows) 3.12.0 (tags/v3.12.0:0fb18b0, Oct 2 2023, 13:03:39) [MSC v.1935 64 bit (AMD64)]
Legal docs and information: aka.ms/AzureCliLegal
Your CLI is up-to-date.
Additional context
No response