DMT Code Review Process
Informal code review is done via email. How is a formal review completed?
Meeting
True or False: DML changes include updates to Xref tables.
TRUE
What does CAB stand for?
Change Approval Board
Which change process needs to be followed for changes done in weekly deployment windows?
Standard
Daily Double: What is included in deployment list? Soldiers being sent overseas; changes being deployed; every deployed object and any change mitigation; every change that is in production.
Every deployed object and any change mitigation.
Once code is ready to review who is responsible to notify the code reviewer?
Developer
What tool should be used to push up to different environments?
Visual Studio
Daily Double: What is a Stage Gate Review?
evaluation that takes place to authorize a project to move from one life cycle phase to another
When is the deadline for an expedited change approval?
Noon
What technology tool do the Apps Data Ops analyst use to hand over the deployment list to the CM support Team?
Name the 2 of the 3 participating roles of the code review process.
developer, Peer, Manager
True or False: Visual Studio cannot handle automated deployments.
FALSE
How many people are responsible for Stage Gate review coordination and facilitation?
one; a single individual the Critical Partner unless otherwise designated
Up to which environment can a developer deploy code on PIDPyper? UAT; SIT; TRN; PreProd
UAT
How does the VM support team acknowledge the hand off from Apps Data Ops Team?
Respond to the email.
Daily Double: What type of testing needs to be completed without errors before report is promoted to the next higher environment?
Unit Testing
Where should one perform a schema compare?
Visual Studio (via SQL menu item)
What happens once the Stage Gate review meeting is completed?
All results are shared with Business Owner, project team
True or Fales: During deployment process, team member manually performs deployment/integration testing. If defect is found, issue is analysis/resolved by Developer while going back through DMT Development Process. Change Approval needed for this to start.
TRUE
When does the assigned DMT analyst performs DMT Handoff to Support Process.
Once changes are in production.
What 2 of the 3 classifications of a medium code review complexity level?
Changes =11>25 columns and >=16<80 hours of work. Somewhat complex with minor calculations
What is the next thing one should do after a schema change gets pushed?
Use PIDPyper to import the metadata.
Name 2/3 possible inputs to a Stage Gate review
architecture review, baseline reviews, audits, cost & scheduling report, testing reviews
Name one of 2 teams the developer works with to determine scheduling of app on PIDPyper in deployment process.
App DataOps Group or Qlik group
What is included in a change mitigation?
Possible issues and resolutions affected or caused by a deployed object.