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 2
What are two required configurations when setting up user accounts and permissions? (Choose two.)
Options:
A.
The ECE web server can be installed in DMZ and must use the same domain account.
B.
All the servers except the ECE web server must use the domain account to install the software.
C.
All the servers must use the same domain account to install the software.
D.
Domain account is not mandatory to install the software. The local account with administrator privilege can be used.
E.
The ECE web server can be installed in DMZ and can have a different domain account.
Answer:
C, E
Explanation:
Explanation:
When setting up user accounts and permissions, it is necessary to configure all the servers to use the same domain account in order to install the software. Additionally, the ECE web server can be installed in a DMZ and can have a different domain account from the rest of the servers.
References: [1] [2]
When setting up user accounts and permissions, it is important to ensure that all servers are using the same domain account to install the software. This will ensure that all servers have the same level of access and permissions, and that the installation process goes smoothly. Additionally, if the ECE web server is installed in DMZ, it can have a different domain account, which would be more secure.
You can find more information on user accounts and permissions, including best practices for setting them up, in the Avaya Aura Experience Portal Administrator Guide and Avaya Aura Contact Center Administrator Guide.
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.