March 25, 2012 at 8:30 am
Hey all,
I'm preparing for this exam as I want to take it as soon as it drops. I'm having a tough time understanding what MS means in the outline for a few things... would you guys be so kind to help me out here? Everything makes perfect sense everywhere in the outline.. i'm just not 100% sure about what they are expecting for the bolded items in the below section. Maybe i'm overthinking it but any help would be greatly appreciated!
•Query data by using SELECT statements.
This objective may include but is not limited to: use the ranking function to select top(X) rows for multiple categories in a single query; write and perform queries efficiently using the new code items such as synonyms and joins (except, intersect); implement logic which uses dynamic SQL and system metadata; write efficient, technically complex SQL queries, including all types of joins versus the use of derived tables; determine what code may or may not execute based on the tables provided; given a table with constraints, determine which statement set would load a table; use and understand different data access technologies; CASE versus ISNULL versus COALESCE
March 25, 2012 at 10:01 am
Extract 1: Building up dynamic SQL statements using the system metadata tables.
Extract 2: Given a SQL statement and a set of tables, constraints, etc, determine (through logic) whether that query will run or not
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply