1.
Which of the following items are stored in the Reports.dic? Choose the 2 that apply.
2.
Your client highest priority is for consistency between reports and ease of maintenance of reports. What Your client? highest priority is for consistency between reports and ease of maintenance of reports. What is the
simplest way to accomplish this?
3.
Which file contains all Great Plains default settings?
4.
Which of the following database options will negatively impact Great Plains performance when selected? Choose the 2 that apply.
5.
Which Microsoft Business Solutions recommended DBCC command can repair minor database problems?
6.
Which SQL Server option does Microsoft Business Solutions recommend using to schedule all of the Great Plains recommended periodic maintenance procedures?
7.
If a customer is experiencing less than optimal SQL performance, which tools could you use to determine the cause? Choose the 3 that apply.
8.
What is the recommended RAID setup for Great Plains files?
9.
You wish to optimize your stored procedures by triggering the stored procedures to re-write themselves. Which SQL Maintenance procedure do you run?
10.
Your goal is to optimize SQL Server and Great Plains performance. Which of the following selections would you make? Choose the 2 that apply.