Microsoft
70-776 · Question #17
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…
The correct answer is B. EXEC sp_addrolemember `xlargerc', `LoaderUser'. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-develop-
Operate and manage Big Data solutions
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'
How the community answered
(39 responses)- A8% (3)
- B74% (29)
- C3% (1)
- D15% (6)
Explanation
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-develop-
Topics
#Azure SQL Data Warehouse#resource classes#xlargerc#user permissions
Community Discussion
No community discussion yet for this question.