Microsoft
70-776 · Question #17
70-776 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock 70-776 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
Question
You have an extract, transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse. You run the following statements to create the logon and user for an account that will run the nightly data load for the data warehouse. CREATE LOGIN LoaderLogin WITH PASSWORD = `mypassword'; CREATE USER LoaderUser for LOGIN LoaderLogin; You connect to the data warehouse. You need to ensure that the user can access the highest resource class. Which statement should you execute?
Options
- AALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;
- BEXEC sp_addrolemember
xlargerc',LoaderUser' - CALTER SERVER ROLE LargeRC ADD MEMBER LoaderUser;
- DEXEC sp_addrolemember
largerc',LoaderLogin'
Unlock 70-776 to see the answer
You've previewed enough free 70-776 questions. Unlock 70-776 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.