Get real exam questions for 70-767 Implementing a SQL Data Warehouse (beta). 100% Free.
Q1. You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure.The package uses a Foreach container to process text files found in a folder. The package must be deployed to a single server by using the Project Deployment model.Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule.Each job
Q1. You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All the appropriate permissions are granted.DQS users are experiencing issues connecting to the new Data Quality Server. You need to enable users to connect to the new server.Which Surface Area Configuration property shou
Q1. DRAG DROPYou are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the @CustomerID parameter of type INT.A project parameter named CustID will be mapped to the stored procedure parameter@CustomerID.You nee
Q1. You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse; and the dimDistrict table contains information about sales districts.The system is accessed by users from certain districts, as w
Q1. You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure.Most of the dimensions have the same structure and content. However, the geography dimension is slightly different in each data mart.You need to design a consolidated dimensional structure that will be easy to maintain while ensuring that all d
Q1. You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Server change data capture (CDC) feature.You have added a CDC Source component to the data flow to read changed data from the source system.You need to add a data flow transformation to redirect rows for separate proc