A.) master B.) tempdb C.) msdb D.) model
A.) Constraints B.) Triggers C.) Views D.) Foreign keys
A.) An index that enforces data integrity rules B.) An index that defines the primary key for a table C.) An index that determines the physical order of data in a table D.) An index that allows duplicate values
A.) SQL Server Reporting Services (SSRS) B.) SQL Server Analysis Services (SSAS) C.) SQL Server Integration Services (SSIS) D.) SQL Server Backup and Restore
A.) To automatically generate reports B.) To enforce data integrity rules C.) To schedule database maintenance tasks D.) To respond to specific database events
A.) SQL Server Integration Services (SSIS) B.) SQL Server Analysis Services (SSAS) C.) SQL Server Reporting Services (SSRS) D.) SQL Server Data Tools (SSDT)
A.) To analyze query performance and find bottlenecks B.) To create and manage user accounts C.) To monitor server hardware usage D.) To design database schemas
A.) SQL Server Analysis Services (SSAS) B.) SQL Server Integration Services (SSIS) C.) SQL Server Reporting Services (SSRS) D.) SQL Server Database Engine
A.) To manage SQL Server instances B.) To create and design databases C.) To write and execute SQL queries D.) develop business intelligence solutions
A.) Windows Authentication Mode B.) SQL Server Authentication Mode C.) Mixed Mode D.) Integrated Authentication Mode