can produce a table with several different analytical calculations such as a count, sum and average can PIVOT (slice) a dimension into sections based on each value of the measure produce a table with a hierarchy in the dimensions condense a large amount of data into a succinct table
As demonstrated, which of the following capabilities can SQL Pivot queries perform?
can produce a table with several different analytical calculations such as a count, sum and average
can PIVOT (slice) a dimension into sections based on each value of the measure
produce a table with a hierarchy in the dimensions
condense a large amount of data into a succinct table
Which of the following is not true about PIVOT() queries
the base query can retrieve data using an extensive set of INNER JOINS
the base query can JOIN a maximum of three tables
the base query can be used to pre-process data such as using a GROUP BY()
the base query can be used to change the column names that will be displayed
Which of the following was taught as a requirement about using PIVOT() queries
place the higher cardinality dimension on the columns
you must use all the values of the dimension that specifies the columns
you must specify only three columns of data in the base SELECT query
You can use dates such as months, but not textual dimensions in the columns
Regarding the results of a PIVOT() query
the descriptive categorization can also be formatted with percentiles
the processing can improve the presentation of data when the granularity of the data is too high
the results are best used in a pie-chart
the will be close but not exactly the same as results yielded from using an Excel Pivot table
Which of the following is not a reason to use categories to analyze data?
using a crosstab to analyze a metric by region can give strong insight
putting data into months can help to identify trends
data with high granularity is difficult to understand because there is so much of it
all are reasons to use categories to analyze data
Which SQL function below puts an equal amount of rows of data into each category?
NTILE() statements
CASE () statements
GROUP BY() statements
none of the options.
Which SQL function below puts data into programmer-defined categories
NTILE() statements
CASE () statements
GROUP BY() statements
none of the options.
Subject: MYSQL
Trending now
This is a popular solution!
Step by step
Solved in 2 steps