A reporting template can be used to create multiple reports with the same configurations, thus allowing users to create multiple reports with the same configurations. Additionally, templates can be deleted as per the requirement, if it is not needed anymore. But it's important to note that once a template is deleted, all reports created from that template will be deleted as well.
Question 2
Which mode must be used for Always On Availability Group clustering?
Options:
A.
Mixed mode
B.
Directory Connection
C.
Windows Authentication
D.
SQL Authentication
Answer:
C
Explanation:
Explanation:
Windows Authentication allows users to connect to SQL Server using their Windows credentials. It uses Kerberos security protocol for authentication and it's considered more secure than SQL Server Authentication.
Always On Availability Groups (AGs) is a feature of Microsoft SQL Server that provides high availability and disaster recovery for a group of user databases. Windows Authentication is required for all the SQL Server instances that participate in an availability group.
It's important to note that, the specific configuration options and settings may vary depending on the version of SQL Server and the specific requirements of the organization. It's recommended to consult the Microsoft documentation and your SQL Server support team for further assistance.
References:
Microsoft: Always On Availability Groups (SQL Server)
Microsoft: Configure the Server Authentication Mode
Microsoft: Connect to the Primary Replica of an Always On Availability Group (SQL Server)
Question 3
Which two integration tasks are needed to get CUIC to communicate with ECE? (Choose two.)
Options:
A.
Create a SQL User with db_datareader rights to the eGReportsDB on the ECE Reporting server.
B.
Single-mode authentication must be enabled on the ECE Reporting server.
C.
Create a SQL User with db_user rights to the eGsideDB on the ECE Reporting server.
D.
Mixed mode authentication must be enabled on the ECE Reporting server.
E.
Create a SQL User with db_user rights to the eGReportsDB on the ECE Reporting server.
F.
Mixed mode authentication must be enabled on the CUIC publisher.
Answer:
E, F
Explanation:
Explanation:
E. Create a SQL User with db_user rights to the eGReportsDB on the ECE Reporting server: CUIC needs to access the ECE Reporting server's eGReportsDB to retrieve data and perform reporting. A SQL user with db_user rights to the eGReportsDB is needed to allow CUIC to access and read the data.
F. Mixed mode authentication must be enabled on the CUIC publisher: CUIC and ECE use different authentication methods, in order for CUIC to communicate with ECE, mixed mode authentication must be enabled on the CUIC publisher. This allows CUIC to use both Windows and SQL Server authentication to connect to ECE.