Step 1: Understanding the Partial Correlation.
The partial correlation coefficient between two variables, keeping another variable fixed, can be computed using the formula for partial correlation in terms of the covariance matrix \( \Sigma \). The formula for the partial correlation between \( X_2 \) and \( X_3 \), with \( X_1 \) held constant, is given by:
\[
\rho_{23 \cdot 1} = \frac{\Sigma_{23} - \Sigma_{21} \Sigma_{11}^{-1} \Sigma_{13}}{\sqrt{(\Sigma_{22} - \Sigma_{21} \Sigma_{11}^{-1} \Sigma_{12})(\Sigma_{33} - \Sigma_{13} \Sigma_{11}^{-1} \Sigma_{31})}}.
\]
Where \( \Sigma_{ij} \) represents the element in the \( i \)-th row and \( j \)-th column of the covariance matrix \( \Sigma \).
Step 2: Using the covariance matrix.
Given the covariance matrix \( \Sigma \), we can extract the necessary values:
\[
\Sigma = \begin{pmatrix} 4 & -1 & 1
-1 & 2 & a
1 & a & 2 \end{pmatrix}
\]
We are given that the partial correlation coefficient \( \rho_{23 \cdot 1} = \frac{5}{7} \). Substituting the values into the formula and solving for \( a \), we find that:
\[
a = 3.
\]
Step 3: Conclusion.
Therefore, the value of \( a \) is \( 3 \), and the correct answer is (C).