What three areas are regularly monitored by the Performance Data Warehouse? Performance, Application Performance, User Activity System t 20. When troubleshooting transactional replication using the Replication Monitor, what should you do to test whether a firewall is blocking the replication between snapshots? Diagnosing and resolving transactional replication issues in SQL Server, particularly those related to firewalls, is a process that requires a comprehensive understanding of both SQL Server and network configurations. It involves methodical testing, careful examination of logs, and often collaboration with network professionals. By systematically addressing potential issues and understanding the underlying infrastructure, you can identify and resolve the root causes of replication problems, ensuring data consistency and system reliability. x 24. You wish to create a series of maintenance plans to automate the maintenance of your SQL server. What tasks should you schedule weekly at minimum? List 3 (2 marks): **Database Backup** **Database Integrity Check**: **Update Statistics** x describes how data should be organized and 26. What is the primary purpose of schemas? how the table relationships should be built within a particular database 27. What SQL feature can you create and enable to check all of your databases for a particular setting (e.g. Recovery Model not equal to Simple) every day? X 28. After configuring an email account using Database Mail, what must you configure in order to send email to jason.eckert@trios.com? To send an email to jason.eckert@trios.com using Database Mail in SQL Server, you need to configure a Database Mail profile and a Database Mail account. Here are the steps: 1. **Create a Database Mail Account**: This account is used to send an email. It contains the details of the email server that will send the email. ```sql EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = 'MailAccount', @description = 'Mail account for sending email', @email_address = 'your-email@example.com', @display_name = 'Your Name', @mailserver_name= 'smtp.example.com' 2. **Create a Database Mail Profile**: This profile Which database option is used to cache transaction results in RAM for faster speed? Memory Database" (IMDB) or "In-Memory Caching". "In- Xi 8. Which two database options are used to ensure that statistics are automatically obtained for your Auto Update Statistics, Auto Create Statistics database? 9. What two recovery models are supported by Database Log Shipping? 1. Full Recovery Model 2. Bulk-Logged Recovery Model 10. What recovery model is supported by Database Mirroring? bulk-logged, or full. X X 21. Which counter in the Performance Monitor console can be used to monitor SQL RAM usage? Diagnosing and resolving transactional replication issues in SQL Server, particularly those related to firewalls, is a process that requires a comprehensive understanding of both SQL Server and network configurations. It involves methodical testing, careful examination of logs, and often collaboration with network professionals. By systematically addressing potential issues and understanding the underlying infrastructure, you can identify and resolve the root causes of replication problems, ensuring data consistency and system reliability.