Skillset can help you prepare! Sign up for your free Skillset account and take the first steps towards your certification.
A database administrator (DBA) is responsible for carrying out security policy, which includes controlling which users have access to which data. The DBA has been asked to make just certain fields in some database tables visible to some new users. What is the best course of action for the DBA to take?
Export the table to a data warehouse
Clone the table
Implement column-based access controls
Create a view that contains only the fields that the users are permitted to see
The correct answer is 'Create a view that contains only the fields that the users are permitted to see '.
Train with Skillset and pass your certification exam. Faster. Guaranteed.
Study thousands of practice questions that organized by skills and ranked by difficulty.
Create a tailored training plan based on the knowledge you already possess.
Know when you’re ready for the high-stakes exam. Have the confidence that you will pass on your first attempt.