没有合适的资源?快使用搜索试试~ 我知道了~
首页2018年7月70-463微软SQLServer数据仓库设计改进
在2018年7月的70-463微软数据库认证考试题库中,涵盖了SQL Server 2012/2014的相关知识。这次考试主要测试考生对实施数据仓库技术的理解和应用能力,特别是在设计和管理数据仓库结构时的关键决策。题目涉及的一个具体场景是关于在SQL Azure上托管的数据仓库中客户维度表的设计优化。 在第1题中,问题描述了一个现有客户维度表的挑战:该表设计不允许保留历史更改,如邮政编码的历史记录。为了实现对多个客户属性,包括邮政编码的完整历史报告,需要对维度表进行改进。正确答案是A,即添加起始日期和结束日期列。这样做可以记录每个属性值的生效时间范围,从而支持对过去状态的追溯。通过这种方式,每当一个客户的属性发生变化时,新的记录将被插入并附带新的开始日期,旧的记录则记录其结束日期,确保了历史数据的完整性和可报告性。 该部分题目位于Volume A,主要关注的是数据库设计和管理中的时间序列数据处理。考试可能还会涉及到其他主题,比如数据仓库架构、ETL(提取、转换、加载)过程、星型或雪花模式的设计、维度和事实表的区分、以及SQL Server在数据仓库性能优化中的角色,如使用分区、索引和事务隔离级别等。 考生需要掌握如何根据业务需求调整数据模型,理解不同设计选择对查询性能和数据一致性的影响,并能够有效地利用SQL Server的特性来支持复杂的数据分析。通过这个题目,可以考察到考生对于SQL Server在实际工作场景中的灵活性和适应性,以及他们对数据仓库最佳实践的深入理解。
资源详情
资源推荐
https://www.gratisexam.com/
Correct Answer:
https://www.gratisexam.com/
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
References: http://msdn.microsoft.com/en-us/library/ms141003.aspx
http://msdn.microsoft.com/en-us/library/ms141261.aspx
http://msdn.microsoft.com/en-us/library/ms141722.aspx
http://msdn.microsoft.com/en-us/library/ms139895.aspx
QUESTION 17
You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?
A. Run the DQSInstaller.exe command.
B. Install the data providers that are used for data refresh.
C. Install ADOMD.NET.
D. Run the dbimpexp.exe command.
Correct Answer: A
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
Note: DQS stands for Data Quality Server.
References: http://msdn.microsoft.com/en-us/library/ff877917.aspx
http://msdn.microsoft.com/en-us/library/gg492277.aspx
QUESTION 18
You are creating a SQL Server Master Data Services (MDS) model for a company.
The source data for the company is stored in a single table that contains the manager-to-subordinate relationships.
You need to create a hierarchy representing the organizational structure of the company.
https://www.gratisexam.com/
Which hierarchy type should you use?
A. Organizational
B. Recursive
C. Non-Mandatory Explicit
D. Many-to-Many
E. Natural
F. Explicit
G. Parent
Correct Answer: B
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
References: http://technet.microsoft.com/en-us/library/ff487006.aspx
http://msdn.microsoft.com/en-us/library/ee633747.aspx
http://technet.microsoft.com/en-us/library/ee633759.aspx
QUESTION 19
You are the data steward for a Business Intelligence project.
You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been
created to support this project.
You need to produce the CSV file with the least amount of development effort.
What should you do?
https://www.gratisexam.com/
A. Create an Integration Services package and use a Data Profiling transform.
B.
Create a custom .NET application based on the Knowledgebase class.
https://www.gratisexam.com/
C.
Create a data quality project.
D. Create a CLR stored procedure based on the Knowledgebase class.
E. Create a Master Data Services (MDS) business rule.
Correct Answer: C
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
References: http://msdn.microsoft.com/en-us/library/hh213052.aspx
QUESTION 20
You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS repository.
You need to design a solution that gives the application access to the product data with the least amount of development effort.
What should you do?
A. Create a Subscription View in MDS.
B. Access the product entity tables in the MDS database directly.
C. Use SQL Server Integration Services (SSIS) to extract the data and put it in a staging database.
D. Use change data capture on the product entity tables.
E.
Create an OLE DB connection string that sets the Provider property to MDS.
F. Use transactional replication for data synchronization.
Correct Answer: A
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
You create a subscription view to export Master Data Services data to a subscribing system such as SQL Server. You use the subscribing system to view the data
in the Master Data Services database.
https://www.gratisexam.com/
References: https://docs.microsoft.com/en-us/sql/master-data-services/overview-exporting-data-master-data-services?view=sql-server-2017
QUESTION 21
You are installing SQL Server Data Quality Services (DQS).
You need to give users belonging to a specific Active Directory group access to the Data Quality Server.
Which SQL Server application should you use?
A. Data Quality Client with administrative credentials
B. SQL Server Configuration Manager with local administrative credentials
C. SQL Server Data Tools with local administrative permissions
D. SQL Server Management Studio with administrative credentials
Correct Answer: D
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
QUESTION 22
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Team Type, does not yet
have a domain.
You need to complete the mapping of the Team Type column.
What should you do?
A. Add a column mapping for the Team Type column.
B. Map a composite domain to the source column.
C. Create a composite domain that includes the Team Type column.
D. Add a domain for the Team Type column.
Correct Answer: D
Section: Volume A
Explanation
Explanation/Reference:
Explanation:
References: http://msdn.microsoft.com/en-us/library/ff877917.aspx
http://msdn.microsoft.com/en-us/library/hh213015.aspx
剩余109页未读,继续阅读
vithal
- 粉丝: 1
- 资源: 17
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 多模态联合稀疏表示在视频目标跟踪中的应用
- Kubernetes资源管控与Gardener开源软件实践解析
- MPI集群监控与负载平衡策略
- 自动化PHP安全漏洞检测:静态代码分析与数据流方法
- 青苔数据CEO程永:技术生态与阿里云开放创新
- 制造业转型: HyperX引领企业上云策略
- 赵维五分享:航空工业电子采购上云实战与运维策略
- 单片机控制的LED点阵显示屏设计及其实现
- 驻云科技李俊涛:AI驱动的云上服务新趋势与挑战
- 6LoWPAN物联网边界路由器:设计与实现
- 猩便利工程师仲小玉:Terraform云资源管理最佳实践与团队协作
- 类差分度改进的互信息特征选择提升文本分类性能
- VERITAS与阿里云合作的混合云转型与数据保护方案
- 云制造中的生产线仿真模型设计与虚拟化研究
- 汪洋在PostgresChina2018分享:高可用 PostgreSQL 工具与架构设计
- 2018 PostgresChina大会:阿里云时空引擎Ganos在PostgreSQL中的创新应用与多模型存储
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功