Sql预访问测试 [英] Sql pre-interview test

问题描述

Nemeste Baya，



我知道你很忙但我觉得你可以帮我解决这个SQL面试问题我无法回答它。



我是一名初级SQL开发人员，每当我需要帮助时都会关注并引用codeproject.com。



一位在某公司申请工作的朋友被问了一些问题我回答了其中一些问题，除了下面列出的问题。



我复制并粘贴了它，我正在请求你的帮助和指导来回答这三个问题。



我非常感谢你的帮助和时间。



Q1-每天在服务器上丢弃一个包含18列事实数据的100 GB平面文件。描述所需的体系结构（包括硬件和软件）1）识别文件已到达并准备好摄取2）解压缩文件并在合理的时间内将其提取到分段模式（100GB = ~300M行）。





Q2-名为WorkContracts的工作表具有以下列：ContractId，Product和Value。名为DimContracts的维度有一个名为ContractKey的代理键字段和上面相同的3列。 ContractId是唯一的业务密钥。编写最有效的语句，在WorkContracts中生成不在DimContracts中的所有行。





Q3-新专栏EmailOptOut已添加到Customer表中的源OLTP系统。描述将这些新数据一直传播到数据仓库系统所需的步骤到多维数据集中Customer维度中的新属性。





再次感谢您的时间。





Joseph



我尝试了什么：



我回答了其他问题，但我不能这样做。我只需要指导。

Nemeste Baya,

I understand you are busy but I feel you can help me on this SQL interview question I can't able to answer it.

I am a junior SQL Developer and have been following and referencing codeproject.com whenever I need some help.

A friend who applied for a job in a certain company was asked some questions and I answered some of them except those listed below.

I copied and pasted it, I am requesting your help and guidance to answer these three questions.

I really appreciate your help and time.

Q1- A 100 GB flat file containing 18 columns of fact data is being dropped daily on your server. Describe the architecture (both hardware and software) required to 1) Recognize that a file has arrived and is ready for ingestion 2) Decompress the file and extract it into a staging schema in a reasonable amount of time (100GB = ~300M rows).


Q2- A work table named WorkContracts has the following columns: ContractId, Product, and Value. A dimension named DimContracts has a surrogate key field called ContractKey and the same 3 columns above. ContractId is the unique business key. Write the most efficient statement that produces all rows in WorkContracts that are not in DimContracts.


Q3- A new column, EmailOptOut, has been added to the source OLTP system in the Customer table. Describe the steps required to propagate this new data all the way through the data warehouse system to a new attribute in the Customer dimension in the cube.


Thank you for your time, again.


Joseph

What I have tried:

I answered the other questions but I can't do these. I just need guidance.

推荐答案

至于......

Q1：

平面文件数据库 - 维基百科 [ ^ ]

Q2：

SQL联接的可视化表示 [ ^ ]

EXCEPT和INTERSECT（Transact-SQL） [ ^ ]

EXISTS（Transact-SQL） [ ^ ]

IN（Transact-SQL） [ ^ ]

Q3：

如何在SSAS Cube中添加新列 [ ^ ]



注意：我们不会为此提供准确答案作为问题。你必须自己做。请点击链接。

As to the...

Q1:

Flat file database - Wikipedia[^]

Q2:

Visual Representation of SQL Joins[^]
EXCEPT and INTERSECT (Transact-SQL)[^]
EXISTS (Transact-SQL)[^]
IN (Transact-SQL)[^]

Q3:

How to add new column into SSAS Cube[^]

Note: we won't provide exact answers for such as questions. You have to do it yourself. Please, follow the links.

这篇关于Sql预访问测试的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！