70-463 Practice Questions

You need to extract data from delimited text files. What connection manager type would you choose?

Some of the data your company processes is sent in from partners via email. How would you configure an SMTP connection manager to extract files from email messages?

You need to extract data from a table in a SQL Server 2012 database. What connection manager types can you use? (Choose all that apply.)

In your SSIS solution, you need to load a large set of rows into the database as quickly as possible. The rows are stored in a delimited text file, and only one source column needs...

A part of your data consolidation process involves extracting data from Excel workbooks. Occasionally, the data contains errors that cannot be corrected automatically. How can you...

In your ETL process, there are three external processes that need to be executed in sequence, but you do not want to stop execution if any of them fails. Can this be achieved by us...

You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Quality Assurance (QA) testers in the company must have p...

You are designing a data warehouse that uses SQL Server 2012. The data warehouse contains a table named factSales that stores product sales. The table has a clustered index on the...

You are designing a complex SQL Server Integration Services (SSIS) project that uses the Project Deployment model. The project will contain between 15 and 20 packages. All the pack...

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Databa...

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 Se...

You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the contents of a fact table that contains a non-clustered columnstore index. You need to...

Reporting from a Star schema is simpler than reporting from a normalized online transactional processing (OLTP) schema. What are the reasons for wanting simpler reporting? (Choose...

If you want to switch content from a nonpartitioned table to a partition of a partitioned table, what conditions must the nonpartitioned table meet? (Choose all that apply.)

Which of the following T-SQL functions is not very useful for capturing lineage information?

Which statements best describe SQL Server Development Tools (SSDT)? (Choose all that apply.)

Which of the following statements about simple and complex data movements are true? (Choose all that apply.)

Which of the following statements are true? (Choose all that apply.)

You are designing a data warehouse that uses SQL Server 2012. The data warehouse contains a table named factSales that stores product sales. The table has a clustered index on the...

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 Se...

You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of d...

You are designing a SQL Server Integration Services (SSIS) project that uses the Project Deployment Model. The project will contain 10 packages. All the packages must connect to th...

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One...

Your company uses a proprietary encryption algorithm to secure sensitive data. A custom cryptographic assembly was developed in Microsoft .NET and is used in several applications....

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation changes with every...

Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases. You need that the business appli...

You have a secured database that contains all of the customer data for your company. You plan to use a project deployment model. You need to create a SQL Server Integration Service...

You have Master Data Services (MDS) in a SQL Server deployment. You need to deploy a model that contains data to the MDS repository. What should you use?

You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight CPUs, 8 GB of RAM, RAID-1 storage, and a 10-gigabit Ethernet connection. A pa...

You are developing a SQL Server Integration Services (SSIS) package that loads data from a source transactional tables in a data warehouse. You discover that one of the data flows...

You have a SQL Server Integration Services (SSIS) package that is configured as shown in the exhibit. (Click the Exhibit button.) You need to recommend changes to the package to re...

You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services (SSIS) catalog. You need to ensure that the package cr...

You are the administrator for a Master Data Services (MDS) environment. A user who is not an administrator must be able to access Master Data Manager. You need to assign permission...

You have a database named Sales and a data warehouse named DataW. From Sales, you plan to bulk insert to a table in DataW that is more than 2 TB. The process will insert a minimum...