MicrosoftCurrently I am studying to take th DP-800. Is it required to know the T-SQL syntax by memory or is the exam adjusted to actual modern AI-development where you tell the llm 'wirte me a view for table Products with x y z etc' and let it write the syntax for you?
For example during one of the applied skills tests (for another but related learning path) an assignment was "In DatabaseProjectdb1, create a stored procedure named usp_ProductCategory in SalesLT. The stored procedure must return the ProductID, Name and ProductNumber from SalesLT.Product, and then return Name from SalesLT.ProductCategory. Alias the Product.Name column as ProductName and alias the ProductCategory.Name column as ProductCategory."
I would be able to do that but even for such a simple thing writing the T-SQL code all by myself is very time consuming. In my day to day tasks I would always start with an llm written code and go from there. Then considering the more advanced functions like JSON_xxx, Row level security or Dynamic data masking: should I be spending time on remembering the syntax by heart or would it be sufficient to know what it can do and what is necessary to implement it ?
I cannot answer for DP-800 but in general, Applied Skills require you to complete activities e.g. by writing/completing code or T-SQL statements.
In developer exams you will not be ask to write code, you will be provided by a code block and then asked either to select the missing line, explain what a line does, to select from drop-downs to complete the missing methods or classes. You will need to understand syntax so that you can answer the question but you will also have access to Microsoft Learn to help you.
Looking at the study guide Study Guide for Exam DP-800: Developing AI-Enabled Database Solutions | Microsoft Learn besides the Implement programmability objects objective, there is a whole other objective, Write advanced T-SQL code, so I would expect items about detailed T-SQL code and T-SQL constructs.
