1.
What is a benefit of extrapolated and propagated statistics?
2.
A customer has an Active Data Warehouse and restricts database access during financial month-end close, allowing only data loads and a limited number of power users to access the system. Which process should be used to implement the restrictions?
3.
A new application was introduced to the production system. End users are reporting slower than expected response times. The database administrator suspects AMP-level skewing is causing performance issues. Which ResUsage table can be used to identify processing skew?
4.
Which data should be collected to project future system capacity needs?
5.
Database Accounting_DB is defined with 5 GB of PERM space. It has a User_Accounts table and 5 views defined in it. While loading 2 GB of data into the empty User_Accounts, the load process failed with a message that there is no more Perm Space in Accounting_DB. Which is a valid reason for the failure?
6.
While executing the FastLoad job to load a Fallback table, a database full condition occurs during End Loading Phase (Phase 2). Which action needs to be performed to complete the load?
7.
A system administrator is upgrading a system to a newer software release. After the system is upgraded, the administrator is interested in knowing which changes occurred in the execution plans as a result of the upgrade. Which tool can be used to compare the before and after execution plans?
8.
Which feature is allowed in combination with Online Archive?
9.
An application user logs on and submits several queries with every transaction. A system administrator wants to analyze AMP level I/O skew per query for this application. Which Account String Expansion (ASE) variables would enable this analysis?
10.
You are receiving calls from various user communities that their queries are taking longer to run than normal. Which tool can be used to check if hardware components have failed?