PROFESSIONAL-CLOUD-DEVELOPER Question #72: Real Exam Question with Answer & Explanation

Question

Your company has a BigQuery dataset named "Master" that keeps information about employee travel and expenses. This information is organized by employee department. That means employees should only be able to view information for their department. You want to apply a security framework to enforce this requirement with the minimum number of steps. What should you do?

Options

• ACreate a separate dataset for each department. Create a view with an appropriate WHERE
• BCreate a separate dataset for each department. Create a data pipeline for each department to
• CCreate a dataset named Master dataset. Create a separate view for each department in the
• DCreate a dataset named Master dataset. Create a separate table for each department in the