APICS Certified Supply Chain Professional (CSCP) — Question 348

A new data engineering team team has been assigned to an ELT project. The new data engineering team will need full privileges on the table sales to fully manage the project.

Which of the following commands can be used to grant full permissions on the database to the new data engineering team?

Answer options

• A. GRANT ALL PRIVILEGES ON TABLE sales TO team;
• B. GRANT SELECT CREATE MODIFY ON TABLE sales TO team;
• C. GRANT SELECT ON TABLE sales TO team;
• D. GRANT USAGE ON TABLE sales TO team;
• E. GRANT ALL PRIVILEGES ON TABLE team TO sales;

Correct answer: A

Explanation

The correct command is A because it grants all permissions on the sales table to the team, which is necessary for full management. Option B incorrectly includes 'CREATE' and 'MODIFY,' which are not standard SQL privileges. Option C only grants SELECT permission, and D only gives USAGE, neither of which are sufficient for full management. Option E incorrectly grants permissions on the team instead of the sales table.