Implementing a SQL 2016 Data Warehouse (SSIS) Quiz Questions and Answers
Answer :
Use a granularity of one day.
Explanation :
We create on partition for each day, which means that a granularity of one day is used.
Note: If
we calculate the partitions that are needed, we get: 7 years times 365 days is 2,555. Make that 2,557 to provide for leap years.
From scenario: Partition the Fact.Order table and retain a total of seven years of data.
The Fact.Order table is optimized for
weekly reporting, but the company wants to change it to daily.
Maximize the performance during the data loading process for the Fact.Order partition.
Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-partition
PrepAway - Latest Free Exam Questions & Answers
In 70-767 (v.2)briefing 70-767 (v.2)
Post navigation
Previous question
Leave a Reply
You must be logged in to post a comment.
70-767 Training Products
70-767 Questions & Answers
Premium File
147 Q& A
$49.99
Last Update: Jul 19,21
70-767 Video Training Course
Training Course
60 Lectures
$24.99
Last Update: Jul 21,21
70-767 Study Guide
Study Guide
1080 PDF Pages
$24.99
Last Update: Jul 22,21
By Prepaway.com
Related questions
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Question 21
Question 22
Question 23
Question 24
Question 25
Question 26
Question 27
Question 28
Question 29
Question 30
Question 31
Question 32
Question 33
Question 34
Question 35
Question 36
Question 37 (2 comments)
Question 38
Question 39
Question 40
Question 41
Question 42
Question 43
Question 44 (1 comment)
Question 45
Question 46
Question 47
Question 48
Question 49
PrepAway - Latest Free Exam Questions & Answers
Recent comments
wellingtonluis wrote Bec
Deploy to the msdb database on the secondary replica.
Explanation :
Before you can configure SSIS to enable support of AlwaysOn on the new added secondary Replicas, you must connect to all new added secondary replicas.Note: To use SSIS with AlwaysOn, you-ll need to add the SSIS Catalog (SSISDB) into an Availability Group. You-ll need to do the following steps:
Make sure you meet the prerequisites for using AlwaysOn
Connect to every node and create the SSISDB catalog. We need to create the catalog even on secondary nodes to create the other server-level objects (cleanup jobs, keys, accounts etc) that are used by SSIS.
Delete the SSISDB databases on secondary nodes.
Create an availability group, specifying SSISDB as the user database
Specify secondary replicas.
References: https://chrislumnah.com/2017/05/09/enabling-alwayson-for-ssisdb/
Use a matching rule, and use completeness and uniqueness data to determine what weight to give a field in the matching process.
If there is a high level of uniqueness in a field, using the field in a matching policy c
an decrease the matching results, so you may want to set the weight for that field to a relatively small value. If you have a low level of uniqueness for a column, but low completeness, you may not want to include a domain for that column.
References: htt
ps://docs.microsoft.com/en-us/sql/data-quality-services/create-a-matching-policy?view=sql-server-2017
Use a matching rule, and use completeness and uniqueness data to determine what weight to give a field in the matching process.
If there is a high level of
uniqueness in a field, using the field in a matching policy can decrease the matching results, so you may want to set the weight for that field to a relatively small value. If you have a low level of uniqueness for a column, but low completeness, you may
not want to include a domain for that column.
References: https://docs.microsoft.com/en-us/sql/data-quality-services/create-a-matching-policy?view=sql-server-2017
According to the Storage Networking Industry Association (SNIA), the
definition of RAID 6 is: -Any form of RAID that can continue to execute read and write requests to all of a RAID arrays virtual disks in the presence of any two concurrent disk failures.-
Incorrect Answers:
A: RAID 1 can only handle a single disk failure
.
B: RAID 5 can only handle a single disk failure.
D: RAID 10 is a stripe of mirrors. It requires more disks compared with RAID 6.
References: https://en.wikipedia.org/wiki/Standard_RAID_levels#RAID_6
SQL Server 2017 provides two features that track changes to data in a database: change data capture and change tracking.
Change data capture provides historical change information for a user table by capturing both the fact that DML changes were made and the actual data that was changed. Changes are captured by using an asynchronous process that reads the transaction log and has a low impact on the system.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/track-data-changes-sql-server
sys.sp_cdc_disable_db disables
change data capture for all tables in the database currently enabled. All system objects related to change data capture, such as change tables, jobs, stored procedures and functions, are dropped.
References: https://docs.microsoft.com/en-us/sql/relational
-databases/system-stored-procedures/sys-sp-cdc-disable-db-transact-sql?view=sql-server-2017
catalog.stop_operation stops a validation or instance of execution in the Integration Services catalog.
Incorrect Answers:
H: sys.sp_cdc_stop_job stops a change data capture cleanup or capture job for the current database.
References:
https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-stop-operation-ssisdb-database?view=sql-server-2017
The minimum similarity between the values of a field is 60%. If the calculated matching score for a field of two records is less than 60, the similarity score is automatically set to 0.
References: https://docs.microsoft.com/en-us/sql/data-qu
ality-services/create-a-matching-policy?view=sql-server-2017
catalog.deploy_project deploys a project to a folder in the Integration Services catalog or updates an existing project that
has been deployed previously.
References: https://docs.microsoft.com/en-us/sql/integration-services/system-stored-procedures/catalog-deploy-project-ssisdb-database
