24. A company’s database contains a table Sales with millions of rows, and the following SQL query is executed frequently: Which of the following optimizations would most effectively improve the query performance?(A) Adding an index on SalesAmount(B) Creating a composite index on (Region, ProductID)(C) Partitioning the table by ProductID(D) Using HAVING SUM(SalesAmount) > 0 to filter results(E) Adding an index on ProductID only

3. Suppose you are using the MNIST dataset to train a neural network model to recognize handwritten digits. Which of the following settings is practical? (A) To accelerate convergence, you can set the learning rate to 256 initially. (B) To make the model more generalized, you can randomly apply image mirroring with a probability of 1/2. (C) To avoid gradient explosion, you can limit the gradient size to 2. (D) To avoid difficulty in training the model, the order of the images should be fixed during training. (E) Since the goal of training is to classify digits from 0 to 9, which is a regression problem, you should set the number of output nodes to 1 and use mean square error as the loss function.

相關試題

相關試卷