When a poor choice of distribution key is made, what is the impact to storage allocation?
What is the maximum number of columns you can choose as organizing keys for clustered base table?
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?
Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?
A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?
What is the only predefined database user, which is able to access all objects and perform all tasks against the database?
The PureData System for Analytics implements which level of transaction isolation?
You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?
Given a plan ID, how would you obtain the query execution plan? (Choose two.)
The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?