office.com/Pages/ResponsePage.aspx?id-DOSIKW.WOyxEjujBLZIQA MAANAASegCqhUjMOVpXS1VHNESHTOUT 8. List some of the functionalities of Active Directory (AD) Enter your answer 9. What is the advantage and disadvantages of Per Core licensing over Client Access Licensing? Enter your answer 10. List at least 5 types of database objects in SQL Server Enter your answer 11. What is the reason behind for a DBA to have good understanding of SQL Server licensing options? 12. Why do we need the following different environments/servers to support SQL Server and applications that use SQL Server as their backend data storage? O HI hp /Pages/ResponsePage.aspx?id=DOSIKWdsWOyxEjajBLZtrQAAAAAAAAAAAANAASegCqhuQjVMOVpXSIVHNEHTO 12. Why do we need the following different environments/servers to support SQL Server and applications that use SQL Server as their backend data storage? Production environment/Production Servers - Test environment/Test Servers Development environment/Development Servers - QA environment/QA Servers Staging environment/Staging Servers - Enter your answer 13. Application owners claim that the application is more important than the database whereas database administrators claim that the database is more important the application. Even though both of them are needed to give service for the business, why do you think we as a DBA claim that the database is more important than the application? Submit Torget your word report abuse This content is created by the owner of the other that you se sent to the form owne. Mais not responsible for the a O 3 lop 4. What is over normalization and explain why over normalization can cause performance issues? Enter your answer 5. How do you mitigate the performance impacts of over normalized database? Enter your answer 6. What is Database Diagram and what is the advantage of it? Enter your answer 7. Write the steps to display the database diagram of a given database in SQL Server. Enter your answer 8. Write the steps to configure maximum server memory of the SQLSERVER? o ! a (hp) 9. Explain why we need to allocate the maxim server memory in SQLSERVER from performance point of view. Enter your answer 10. What are the two system databases that are going to be created when we install and configure SQL Server Reporting Services? Enter your answer 11. What is the name of the system database that is going to be created when we setup replication in SQL Server? Enter your answer A 12. How many types of files can be available in SQL Server database and what is the recommended file name extension of each type of files? Enter your answer ramai naudate and seconda diatas 2 please reronch o 14. We have a system file group and a user file groups (optional) in SQL Server. What is the name of the system file group in any given database? Enter your answer 15. It is possible to add Transaction Log file in a file group True False 16. Why it is not advised to add additional Transaction log file in a database? Enter your answer 17. What is the maximum number of databases that can be created in SQL Server instance? FYI. As per my experience, I haven't seen a SQL Server Instance hosting more than 60 databases and the majority of the Instances I was exposed so far have less than 20 databases. Enter your answer 2. What is a Relational Database? Enter your answer 3. List at least five types of RDBMS software in the market? Enter your
