70-516 TS: Accessing Data with Microsoft .NET Framework 4

youtu.be/L7wdTgL1RHI

캬... 8년이나 되었구낰ㅋ 미국에서 출장 중에 딴 마소 자격증이다. mcp.microsoft.com 사이트에서는 위와 같이 확인한다.

 

 

Microsoft_Certified_Professional_Certificate_0.pdf

0.75MB

Microsoft_Certified_Professional_Certificate_1.pdf

0.72MB

 

올리는 김에 pdf 도 올려 본다. 블로그가 그렇게 인기가 없어서 개인 저장소로도 사용 중인데 다음에서 잘 만들어서 훌륭하기 때문이다. 테터툴즈부터(이 당시 서버 호스팅 사업도 했었었지) 잘 썼었다. 미주 개발팀이라 미국 출장이 참 많았었는데, 3년에 걸쳐 10번 넘게 그것도 한 번에 한 달 넘게 출장을 나가다 보니 대부분의 시간은 소고기와 술로 지냈다. 그러다가 정신 차리고 원서를 많이 읽었었는데 한창 리눅스와 안드로이드만 할 때지만, 마이크로소프트의 서버는 싫어 하지 않는 다는 의미에서 도전했던 자격증이었다. 지금도 윈도우 데이터 센터 서버 사용 중인데 윈도우 서버 정말 나쁘지 않다. 덕분에 Azure 나오고 얼마 안되서 한 창 홍보하던 때가 있었는데... 지금은 윈도우 서버는 한 대 밖에 사용 안하고 AWS 랑 IDC 에 집어 넣은 리눅스 서버들만 쓰는 것을 보면 비용이 참 중요하다는 생각이 든다. 윈도우 서버는 OS 비용도 있지만 SQL 서버 비용도 만만치 않다. 그러나 가끔 알바할 때면 윈도우 서버로 구축해 준 기업이 몇 개 되었는데 당시엔 asp가 참 편했었기 때문이다. 지금은 java 진영, google 과 node, HTML5 가 다 먹어버린 시장이라 지금 실무에서 같이 일하는 분 중 마소 솔루션만 하셨던 분들도 먹고 살고는 계시지만 조금씩 java도 하신다. 

내가 먹고 사는 분야랑 전혀 관련이 없던 자격증이라 도움된 것은 영어 공부 했다는 것? 밖에 없었다. 2번이나 신청 했던 실물 자격증도 결국 받지 못했다. FSF new letter를 지금도 받고 있는데 그 때는 매 달 오는데다 해외 우편물을 많이 받고 있던 터라 실망을 했었고. 삼성 계정으로 메일 보낼 때는 1~2 business day 내에 응대를 잘 해주는 마소가 개인 메일로 뭔가를 물어보면 몇 달 뒤에 답변을 주는 것을 보고 2번 실망했었다. 자격증 신청 비용 정확히 기억은 안나지만 그래도 몇 만원 했었던 것 같은데 결국 자격증은 못 받았다. 지금도 badge 탭은 동작하지 않네...

믓튼, 어떤 운영체제에서나 DB를 두고 연결 소켓을 써서 CRUD 할 수 있는 능력이 있다는 것을 어필할 수 있다면 혼자서 밥 먹고 사는데는 지장 없는 것 같다.

microsoft_certified_professional_transcript.pdf

0.01MB

• Published:

   September 17, 2012

• Languages:

   English

• Audiences:

  IT professionals

• Technology:

   Windows Server 2012

• Credit toward certification:

   Microsoft Certified Technology Specialist (MCTS)

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Hide all

Model data (20%)

• Map entities and relationships by using the Entity Data Model
  • Use the Visual Designer, build an Entity Data Model from an existing database, manage complex entity mappings in EDMX, edit EDM XML, map to stored procedures, create user-defined associations between entities, generate classes with inheritance and map them to tables
  • This objective does not include: using MetadataWorkspace
• Map entities and relationships by using LINQ to SQL
  • Use the Visual Designer, build a LINQ to SQL model from an existing database, map to stored procedures
• Create and customize entity objects
  • Configure changes to an Entity Framework entity, use the ADO.NET EntityObject Generator (T4), extending, self-tracking entities, snapshot change tracking, ObjectStateManager, partial classes, partial methods in the Entity Framework
• Connect a POCO model to the Entity Framework
  • Implement the Entity Framework with persistence ignorance, user-created POCO entities
  • This objective does not include: use the POCO templates
• Create the database from the Entity Framework model
  • Customize the Data Definition Language (DDL) (templates) generation process, generate scripts for a database, Entity Data Model tools
• Create model-defined functions
  • Edit the Conceptual Schema Definition Language (CSDL), enable model-defined functions by using the EdmFunction attribute, complex types

Manage connections and context (18%)

• Configure connection strings and providers
  • Manage connection strings, including Entity Framework connection strings; use the Configuration Manager; correctly address the Microsoft SQL Server instance; implement connection pooling; manage User Instance and AttachDBfilename; switch providers; implement multiple active result sets (MARS)
  • This objective does not include: use the ConnectionStringBuilder, Oracle data provider, create and use a custom provider, use third-party providers
• Create and manage a data connection
  • Connect to a data source, close connections, maintain the life cycle of a connection
• Secure a connection
  • Encrypt and decrypt connection strings, use Security Support Provider Interface (SSPI) or SQL Server authentication, read-only versus read/write connections
  • This objective does not include: Secure Sockets Layer (SSL)
• Manage the DataContext and ObjectContext
  • Manage the life cycle of DataContext and ObjectContext, extend the DataContext and ObjectContext, support POCO
• Implement eager loading
  • Configure loading strategy by using LazyLoadingEnabled, support lazy loading with POCO, explicitly loading entities
• Cache data
  • DataContext and ObjectContext cache, including identity map; local data cache
  • This objective does not include: Velocity, SqlCacheDependency
• Configure ADO.NET Data Services
  • Create access rules for entities, configure authorization and authentication, configure HTTP verbs

Query data (22%)

• Execute a SQL query
  • DBCommand, DataReader, DataAdapters, DataSets, manage data retrieval by using stored procedures, use parameters, System.Data.Common namespace classes
• Create a LINQ query
  • Syntax-based and method-based queries, join, filter, sort, group, aggregation, lambda expressions, paging, projection
  • This objective does not include: compile queries
• Create an Entity SQL (ESQL) query
  • Join, filter, sort, group, aggregation, paging, use functions, query plan caching, return a reference to an entity instance, use parameters with ESQL, functionality related to EntityClient classes
• Handle special data types
  • Query BLOBs, filestream, spatial and table-valued parameters
  • This objective does not include: implement data types for unstructured data, user-defined types, Common Language Runtime (CLR) types
• Query XML
  • LINQ to XML, XmlReader, XmlDocuments, XPath
  • This objective does not include: XSLT, XmlWriter
• Query data by using WCF.NET Data Services
  • Implement filtering and entitlement in WCF.NET Data Services, address resources, create a query expression, access payload formats, Data Services interceptors

Manipulate data (22%)

• Create, update, or delete data by using SQL statements
  • Create/Update/Delete (CUD), use DataSets, call stored procedures, use parameters
• Create, update, or delete data by using DataContext
  • CUD, call stored procedures, use parameters
  • This objective does not include: ObjectTrackingEnabled
• Create, update, or delete data by using ObjectContext
  • CUD, calling stored procedures, using parameters, setting SaveOptions
• Manage transactions
  • System.Transactions, DBTransaction, roll back a transaction, Lightweight Transaction Manager (LTM)
  • This objective does not include: distributed transactions, multiple updates within a transaction, multiple synchronization of data within an acidic transaction
• Create disconnected objects
  • Create self-tracking entities in the Entity Framework, attach objects, DataSets, table adapters

Develop and deploy reliable applications (18%)

• Monitor and collect performance data
  • Log generated SQL (ToTraceString), collect response times, implement performance counters, implement logging, implement instrumentation
• Handle exceptions
  • Resolve data concurrency issues (handle OptimisticConcurrency exception, Refresh method), handle errors, transaction exceptions, connection exceptions, timeout exceptions, handle an exception from the Entity Framework disconnected object, security exceptions
• Protect data
  • Encryption, digital signature, hashing, salting, least privilege
• Synchronize data
  • Online/offline Entity Framework, synchronization services, save locally
• Deploy ADO.NET components
  • Package and publish from Visual Studio, deploy an ADO.NET Services application, package and deploy Entity Framework metadata
  • This objective does not include: configure IIS, MSDeploy, MSBuild

Preparation options

Show all

Instructor-led trainingPractice test

Who should take this exam?

Candidates for this exam use Microsoft Visual Studio 2010 and ADO.NET 4 to develop the data access layer of an application. Candidates should have a minimum of two to three years of experience developing application components that interact with a variety of data sources. In addition, candidates should have a thorough understanding of relational database concepts and should have a minimum of one to two years of experience using a relational database management system.

Candidates should also have a good grasp of the following:

• ADO.NET 4 coding techniques and framework components
• ADO.NET Data Services LINQ
• LINQ to SQL
• Entity Framework technologies
• Structured Query Language (SQL)
• Stored procedures
• Database structures/schemas (objects) XML

이 때 한 창 마이크로소프트 엑셀 자동화도 공부를 했었던 것 같은데, 버전별 짜 놓은 프로그램이 다르게 돌아서 접었던 것 같다. return 값이 제대로 돌아와도 엑셀 버전별로 동작이 다른... 호환성 유지가 참 중요하다. 그러니 아직 윈도우 10에서도 32비트 프로그램이 돌아가지.

지금은 공부 내용은 다 까먹었다. 설계 능력, 영어 실력만 남았네 ㅋㅋ 

만나는 MVP 들이 보시면 참 부끄러운 자격증이기도 하지만 올려 본다. 그냥 공부하는 마일스톤 찍어 보려고, 미국에서 남는 시간 심심해서 공부했다고 보면 되겠다. 술 때문에 병나지 않았거나 한국처럼 인터넷이 빠르고 PC 방이 있었다면 절대 도전하지 않았을 것이다.