Skip Navigation Links
Novas Tecnologias
Ferramentas Adicionais
Ferramentas Adicionais
Prova 70-767: Implementando um SQL Data Warehouse
Data:12/27/2016

Translate this page now :





Categories: SQLServer

Gostou do texto ? Vote e dê sua opinião! Pontuação atual :
Adicione aos Favoritos!
BlogBlogs Rec6 Linkk Ueba Technorati Delicious DiggIt! StumbleUpon

Veja Também


sqlDepois de várias provas beta de SQL Server, é possível identificar de forma mais clara o formato que está sendo adotado nas provas.

  • As 9 questões iniciais se dividem em 3 conjuntos que impedem o uso de back. Todas apresentam um cenário e uma solução, sendo a pergunta apenas “A solução atende ao cenário?”. Em cada conjunto de 3 questões o cenário é o mesmo, com 3 diferentes soluções
  • Existem alguns (3 ou mais) conjuntos de questões com um mesmo cenário, bem longo, e perguntas diversas sobre o cenário
  • Existem alguns (3 ou mais) conjuntos de questões com o mesmo conjunto de respostas mas perguntas diferentes, cada uma se encaixando com uma das respostas
  • Demais questões comuns de múltipla escolha

Na prova de data warehouse, 767, o total é de 56 questões com o tempo de 2:30, sempre o mesmo tempo. Nesta prova me chamou a atenção o termo SQL Data Warehouse, fácil de confundir com Azure SQL Data Warehouse, um produto diferenciado e que também é mencionado nas questões da prova.

 

Modelagem e Tunning

  • Modelagem da tabela de fato
  • Tipos de dimensão
  • Modelagem de dimensões
  • Covering indexes
  • filtered indexes
  • Partições e compressão de dados
  • Operações com partições, incluindo switch
  • Isolation Levels otimistas e pessimistas
  • Organização de filegroups e storage

 

SSIS

  • Regras de precedência, com vários cenários incluindo  precedências condicionais com variáveis
  • Merge Transformation e necessidade de sort
  • lookup
  • union all
  • script task/C#
  • conditional split
  • agregate
  • fuzzy grouping
  • cdc control task
  • Row Count
  • For/Each e o enumerador para cada caso
  • Logging level e environment no SSIS
  • package deployment x project deployment x ssis catalog

 

Integração e Nuvem

  • carga do azure sql data warehouse
  • stretch database
  • Polybase
    •     Integração com HDInsight
    •     Integração com blog storage
  • Azure sql data warehouse

 

DQS

  • Usar knowledge no ssis
  • Criar knowledge base
  • Importar dados do MDS

 

Modelagem Multidimensional

 

  • directquery x in-memory
    •     impersonation
    •     rolebased security
    •     calculated columns
    •     real-time access

 

MDS

  • evitar duplicações com chave composta
  • fechar e publicar um modelo
  • atribuição de permissões


Categories: SQLServer


Nome :
E-mail:
Comentarios :
 
 
Os Últimos Comentários
data: 9/26/2017 4:39:00 AM
nome: coach factory outlet
email: ykcoik@gmail.com
comentário:
I wish to show my thanks to this writer for bailing me out of this issue. Just after looking through the the web and finding opinions which are not beneficial, I figured my entire life was gone. Living without the presence of answers to the difficulties you've sorted out through your good website is a crucial case, and those that would have in a negative way affected my career if I had not noticed your web site. Your own personal capability and kindness in handling all the things was crucial. I'm not sure what I would have done if I had not come upon such a subject like this. I can at this time look ahead to my future. Thank you very much for the expert and results-oriented help. I will not hesitate to recommend the sites to any individual who needs and wants guide about this topic.

data: 9/22/2017 7:52:00 PM
nome: fitflops sale clearance
email: wfewdpj@gmail.com
comentário:
My wife and i have been fortunate Albert could carry out his investigations through the precious recommendations he discovered from your web page. It is now and again perplexing just to always be freely giving key points which others might have been selling. And we all remember we now have the blog owner to give thanks to for that. The most important illustrations you made, the simple blog navigation, the relationships your site give support to promote - it's got most overwhelming, and it is assisting our son in addition to us recognize that this matter is fun, which is certainly seriously indispensable. Thank you for the whole thing!

data: 9/18/2017 5:43:00 PM
nome: colts jerseys
email: cxgdszs@gmail.com
comentário:
I enjoy you because of your entire efforts on this web page. Gloria enjoys setting aside time for internet research and it's easy to understand why. Almost all know all relating to the compelling ways you render practical steps through the web blog and even recommend contribution from some other people about this issue so our own girl is certainly understanding a whole lot. Take pleasure in the remaining portion of the new year. You're the one performing a stunning job.

data: 8/17/2017 1:25:00 AM
nome: nmd
email: scwuwburfdb@gmail.com
comentário:
I together with my friends were found to be checking the good tips and hints from your web blog while all of the sudden got a horrible feeling I had not thanked the site owner for those strategies. These ladies had been certainly glad to read them and now have without a doubt been having fun with them. I appreciate you for turning out to be considerably helpful as well as for using such great tips most people are really eager to know about. My personal sincere apologies for not expressing gratitude to sooner.

data: 8/16/2017 9:38:00 PM
nome: curry 3
email: jhwnbegc@gmail.com
comentário:
There are some interesting time limits on this article but I don?t know if I see all of them center to heart. There is some validity but I'll take hold opinion till I look into it further. Good article , thanks and we wish extra! Added to FeedBurner as nicely

 1  
Dicas
Dica do Dia
Receba Dicas Por Email
E-mail :  
 


 (help)
Aceito receber informativos do devASPNet, informações de eventos e treinamentos

Veja Quais Informativos Você Receberá

Pesquisar Dicas
Pesquisar Artigos, Dicas e Noticias

Banco de Dados
Algumas Entrevistas
Links Importantes

Búfalo Informática, Treinamento e Consultoria
R. Alvaro Alvim, 37/920 Centro - Cinelândia - Rio de Janeiro Cep: 20031-010
Tel : (21) 2262-1368 (21) 9240-5134 E-mail : Contato@bufaloinfo.com.br