Hotspot Yes NoImplement AI capabilities in database solutions
Question 1. You have a database named db1. The schema is stored in a Git repository as an SDK-style SQL database project The repository Contains the following GitHub Action workflow. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Answer:
A. Unit tests run automatically whenever changes are pushed to main.
B. Schema validation occurs during the Build step.
C. Schema validation occurs during the Deploy step.
Multi SelectImplement AI capabilities in database solutions
Question 2. You have an Azure SQL database that contains a table named knowledgebase, knowledgebase stores human resources (HR) policy documents and contains columns named title, content, category, and embedding. You have an application named App1. App1 queries two relational tables named employee_pnofiles and benefits_enrollnent that contain HR data. App1 hosts a chatbot that calls a large language model (LLM) directly. Users report that the chatbot answers general HR questions correctly but provides outdated or incorrect answers when policies change. The chatbot also fails to answer questions that reference internal policy documents by title or category. You need to recommend a Retrieval Augmented Generation (RAG) solution to resolve the chatbot issues. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
A. employee_profiles and benefits_enrollment
B. knowledge base
C. PDF exports of the policies
D. The LLM training data
E. Perform keyword searches
F. Call the LLM first, and then store the response
G. Fine-tune the LLM by using the data in knowledge base
H. Generate query embeddings, and then run a vector similarity search
Drag OrderImplement AI capabilities in database solutions
Question 3. You have a database named DB1. The schema is stored in a GitHub repository as an SDK style SQL database project. You use a feature branch workflow to deploy changes to DB1 You need to update the local feature branch with the latest changes to main, and then create a pull request to merge the feature branch into main for review. How should you complete the GitHub CLI script? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:
A. git checkout main
B. git pull origin main
C. git checkout feature/db1-add-staticdata
D. git merge origin/main
E. gh pr create --title "Feature Update: DB1" --body "Apply latest improvements and updates for review" --repo <GitHubOwner>/DB1 --head feature/db1-add-staticdata --base main
Hotspot Yes NoImplement AI capabilities in database solutions
Question 4. You are creating a table that will store customer profiles. You have the following Transact-SQL code. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection Is worth one point. Answer:
A. The schema meets the security requirements for PII data.
B. Administrators of the Azure SQL server can see all the rows in dbo.CustomerProfiles when they use an application.
C. The masking rules will apply even when row-level security (RLS) filters out rows.