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

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



  • 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



  • 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



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

Categories: SQLServer

Nome :
Comentarios :
Os Últimos Comentários
data: 9/18/2017 5:43:00 PM
nome: colts jerseys
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
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
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

data: 8/13/2017 1:56:00 AM
nome: adidas yeezy
I would like to express my thanks to the writer just for rescuing me from such a scenario. Just after surfing throughout the world-wide-web and getting basics that were not beneficial, I believed my life was well over. Living without the presence of answers to the issues you have sorted out by way of this short post is a crucial case, and the kind that could have in a negative way damaged my entire career if I had not come across the website. Your good knowledge and kindness in maneuvering almost everything was priceless. I'm not sure what I would have done if I had not discovered such a step like this. I can also at this point relish my future. Thank you so much for your specialized and effective guide. I will not hesitate to recommend your web page to any individual who needs counselling about this subject.

data: 8/8/2017 5:45:00 PM
nome: adidas ultra boost
I would like to express my appreciation to you just for bailing me out of such a situation. As a result of surfing around through the internet and getting proposals which are not pleasant, I figured my entire life was done. Existing minus the answers to the difficulties you've resolved through your good guide is a serious case, and the kind that could have negatively affected my career if I had not noticed the blog. Your good capability and kindness in dealing with the whole thing was tremendous. I don't know what I would've done if I had not encountered such a thing like this. It's possible to at this time look forward to my future. Thanks for your time so much for the high quality and results-oriented help. I will not be reluctant to propose your blog post to anybody who would like counselling about this issue.

Dica do Dia
Receba Dicas Por Email
E-mail :  

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 :