Hello,
I just failed the exam with 69% correct, but needed 75%.
The hardest questions for me was the link table a concatenate questions. Not that i dont understand the two concepts, but its hard to decide which one is the best approach when lacking of experience:
example:
Budget table:
Product
Year
Name
Budgetamount
ActualTable:
Product
Year
Month
Date
ActualAmount
These tables create syntheic keys, how would you approch the solution eliminating syntheic keys
1: concatenate
2: left join
3: Create a concatenate key of product-year-month
4: Rename to BudgetYear and BudgetMonth
Furthermore there were questions which approach a developer would take to optimize performance.
The expressions questions are not that hard and really simple set analysis questions.
And some questions can be hard to understand or to decided what is correct, heres is an example:
When should a developer make a new tab in edit script
1: when code exceeds 255 lines
2: When he first time access edit script
3: when the script is no more logically related
A thing i dont understand is that there is no feedback, so i dont know where im good and where im wrong. So next time i might could study an area to be better!
