You have an extract transformation, and load (ETL) process for a Microsoft Azure SQL data warehouse.You run the followin
Posted: Wed Aug 17, 2022 7:02 am
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.You connect to the data warehouse.You need to ensure that the user can access the highest resource class.Which statement should you execute?
A. ALTER SERVER ROLE LargeRC ADD MEMBER LoaderUser;
B. EXEC sp_addrolemember "˜largerc"™, "˜LoaderLogin"™
C. ALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;
D. EXEC sp_addrolemember "˜xlargerc"™, "˜LoaderUser"™
- You Have An Ext 1 (24.39 KiB) Viewed 69 times
B. EXEC sp_addrolemember "˜largerc"™, "˜LoaderLogin"™
C. ALTER SERVER ROLE xLargeRC ADD MEMBER LoaderLogin;
D. EXEC sp_addrolemember "˜xlargerc"™, "˜LoaderUser"™