I think 90% the answer is A
https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-use-the-utility?view=sql-server-ver15
Az cli is perfect to create and manage the DB but to query sqlcmd is the tool
Yes, Use the [sqlcmd][sqlcmd] command-line utility to connect to and query a SQL pool. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-get-started-connect-sqlcmd
Correct answer: A
Azure CLI page: https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=single-database
"You can configure Azure SQL Database and SQL Managed Instance by using the Azure CLI."
You cannot execute queries though.
sqlcmd: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15
It is clearly mentioned that Azure SQL is supported, and Query examples are provided in the link above.
A is good.
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files through a variety of available modes:
At the command prompt.
In Query Editor in SQLCMD mode.
In a Windows script file.
In an operating system (Cmd.exe) job step of a SQL Server Agent job.
"Azure Data CLI (azdata) is a command-line utility written in Python to bootstrap and manage the data services via REST APIs."
Reference: https://docs.microsoft.com/en-us/sql/azdata/install/deploy-install-azdata?view=sql-server-ver16
The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files through a variety of available modes:
At the command prompt.
In Query Editor in SQLCMD mode.
In a Windows script file.
In an operating system (Cmd.exe) job step of a SQL Server Agent job.
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sc2
Highly Voted 4 years, 1 month agoHaidardba
3 years, 11 months agosreekarv
3 years, 11 months agoExamPwnr
Highly Voted 4 years, 1 month agoAGTraining
Most Recent 7 months, 4 weeks agoindiaraj460
10 months, 2 weeks agoakhil5432
1 year, 2 months agochiiiweiii
1 year, 7 months agoiesRuben
1 year, 11 months agoAlbertKwan
1 year, 11 months agoVergee
2 years, 4 months agosimplex06
2 years, 4 months agobfan95
2 years, 6 months agowillyto
2 years, 10 months agomudassirsmk27
2 years, 10 months agoHaidardba
2 years, 11 months agoHaidardba
2 years, 11 months agocadio30
3 years, 1 month agoFeliasg9
3 years, 1 month ago