The database files are configured as shown in the database properties exhibit.
The database developers have been creating new tables and indexes without specifying a filegroup.
The primary filegroup is reaching its maximum capacity.
You want the developers to continue adding new objects, but you do not want then to change the way they create objects. You do not want to run out of disk space. You also want to minimize the time it takes to administer the database.
What should you do?
A.Back up the existing objects on the PRIMARY filegroup. Drop them from the database. Re-create them on the SECONDARY filegroup.
B.Set the file growth on the PRIMARY filegroup to UNLIMITED.
C.Set the PRIMARY filegroup so that it is read-only.
D.Set the SECONDARY filegroup as the default filegroup.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!