Home › Company › Careers › SQL Server Developer › SQL Server Developer Questionnaire
Please complete the questions below as part of our application process:
* = required field
*Phone: (XXX) XXX-XXXX
*Name:
*Email: name@email.com
*Address:
*City, State, Zip:
*County:
*1) In a data warehouse, what is the difference between a Star and Snowflake schema?
*2) A new column, EmailOptOut, has been added to the source OLTP system in the Customer table. Describe the steps required to propagate this new data all the way through the data warehouse system to a new attribute in the Customer dimension in the cube.
*3) A work table named WorkContracts has the following columns: ContractId, Product, and Value. A dimension named DimContracts has a surrogate key field called ContractKey and the same 3 columns above. ContractId is the unique business key. Write the most efficient statement that produces all rows in WorkContracts that are not in DimContracts.
*4) A table named DimAdvertisers has the following columns: AdvertiserKey, AdvertiserId, AdvertiserName, and City. AdvertiserKey is the primary key / unique clustered index for the table. There are no other indexes on the table. The following query is running slowly: Select AdvertiserId, AdvertiserName From Dim.Advertisers Where City = 'Denver' Write an index that would improve this query performance.
*5) What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
*6) A 100 GB flat file containing 18 columns of fact data is being dropped daily on your server. Describe the architecture (both hardware and software) required to 1) Recognize that a file has arrived and is ready for ingestion 2) Decompress the file and extract it into a staging schema in a reasonable amount of time (100GB = ~300M rows).
*7) List 3 steps you would take to improve the performance of a poor performing query?
*8) Describe one architectural difference between an OLTP database and a data warehouse:
*9) Given an OLAP cube named Cube, a dimension named Dates with an attribute named Year, and a calculated measure named Revenue: Write the simplest MDX query possible to produce a result set with revenue on the columns and years on the rows.:
*10) Please include the salary range you are looking for.
*11) Are you a US Citizen, or do you have a Green Card?
*12) Briefly describe the type of position you are looking for in your next career move.
*13) How did you hear about Decentrix? Select One Monster DICE LinkedIn Craigslist.org Other
NOTE: If you haven't already done so, please send your resume to jobapps@decentrix.net.
Copyright ©2001 - Decentrix Inc. All rights reserved.